contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA846486" and tax_clade = "core chlorophytes"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3384095 | 3384095 | PRJNA846486_P_NODE_74623_length_170_cov_1.388430_g74527_i0 | PRJNA846486 | 74623 | 170 | 1.38843 | 2.360331 | Tetradesmus obliquus | 3088 | Plants | Plants | 309 | 7.64e-80 | NTclustered | gi|1240946771|gb|KX756229.1| | 3088 | g74527 | i0 | 99.412 | 21.0117647058824 | 170 | 1 | 100 | 0 | 1 | 170 | 80269 | 80100 | Tetradesmus obliquus chloroplast, complete genome | blastn | 3572 | 309 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 8486202 | 8486202 | PRJNA846486_P_NODE_96827_length_151_cov_28.754902_g96731_i0 | PRJNA846486 | 96827 | 151 | 28.754902 | 43.41990202 | Microglena monadina | 47904 | Plants | Plants | 52.8 | 0.012 | NTclustered | gi|952953016|gb|KT624790.1| | 47904 | g96731 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 63 | 90 | 1738 | 1711 | Microglena monadina clone contig-59 chloroplast, partial genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Microglena | Microglena monadina | |
| 17411492 | 17411492 | PRJNA846486_P_NODE_70434_length_174_cov_1.248000_g70338_i0 | PRJNA846486 | 70434 | 174 | 1.248 | 2.17152 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 126 | 8.5e-25 | NTclustered | gi|2082265001|ref|XM_001689780.2| | 3055 | g70338 | i0 | 86.726 | 0.649425287356322 | 113 | 15 | 65 | 0 | 50 | 162 | 368 | 480 | Chlamydomonas reinhardtii ribosomal protein L35 (CHLRE_14g617900v5), mRNA | blastn | 113 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17808961 | 17808961 | PRJNA846486_P_NODE_62774_length_182_cov_1.075188_g62678_i0 | PRJNA846486 | 62774 | 182 | 1.075188 | 1.95684216 | Eukaryota | 2759 | Plants | Plants | 292 | 8.38e-75 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g62678 | i0 | 99.379 | 103.368131868132 | 161 | 1 | 100 | 0 | 22 | 182 | 58 | 218 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 18813 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 21235400 | 21235400 | PRJNA846486_P_NODE_75937_length_169_cov_1.300000_g75841_i0 | PRJNA846486 | 75937 | 169 | 1.3 | 2.197 | Jenufa minuta | 993092 | Plants | Plants | 291 | 2.75e-74 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g75841 | i0 | 97.633 | 1 | 169 | 4 | 100 | 0 | 1 | 169 | 159152 | 158984 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 169 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 24182990 | 24182990 | PRJNA846486_P_NODE_10279_length_386_cov_1.323442_g10184_i0 | PRJNA846486 | 10279 | 386 | 1.323442 | 5.10848612 | Bryopsis | 3128 | Plants | Plants | 409 | 1.9e-109 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g10184 | i0 | 85.751 | 99.6450777202073 | 386 | 55 | 100 | 0 | 1 | 386 | 194 | 579 | Bryopsis maxima actin gene, partial cds | blastn | 38463 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;