contig_metadata
15 rows where bioproject = "PRJNA1247234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1625970 | 1625970 | PRJNA1247234_P_NODE_12742_length_310_cov_1.645570_g12586_i0 | PRJNA1247234 | 12742 | 310 | 1.64557 | 5.101267 | Lobosphaera incisa | 312850 | Plants | Plants | 422 | 1.92e-113 | NTclustered | gi|725539263|gb|KM821265.1| | 312850 | g12586 | i0 | 91.195 | 130.351612903226 | 318 | 17 | 100 | 7 | 1 | 310 | 136438 | 136752 | Lobosphaera incisa chloroplast, complete genome | blastn | 40409 | 422 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Lobosphaera | Lobosphaera incisa | |
| 2902203 | 2902203 | PRJNA1247234_P_NODE_17083_length_274_cov_1.830846_g16927_i0 | PRJNA1247234 | 17083 | 274 | 1.830846 | 5.01651804 | Paradoxia multiseta | 249350 | Plants | Plants | 442 | 1.2799999999999994e-119 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g16927 | i0 | 95.985 | 76.8394160583942 | 274 | 7 | 100 | 3 | 1 | 274 | 156633 | 156902 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 21054 | 442 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 4879799 | 4879799 | PRJNA1247234_P_NODE_2364_length_623_cov_4.325455_g2216_i0 | PRJNA1247234 | 2364 | 623 | 4.325455 | 26.94758465 | Coccomyxa | 41891 | Plants | Plants | 924 | 0 | NTclustered | gi|1601875646|gb|MK694759.1| | 2315456 | g2216 | i0 | 93.471 | 100.288924558587 | 628 | 31 | 100 | 8 | 1 | 623 | 4546 | 3924 | Coccomyxa sp. Obi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 62480 | 924 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 5454941 | 5454941 | PRJNA1247234_P_NODE_24845_length_246_cov_0.901734_g24689_i0 | PRJNA1247234 | 24845 | 246 | 0.901734 | 2.21826564 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 407 | 4.12e-109 | NTclustered | gi|2106301938|dbj|AP025008.1| | 2315456 | g24689 | i0 | 96.735 | 2.70731707317073 | 245 | 7 | 99 | 1 | 3 | 246 | 11027 | 11271 | Coccomyxa sp. Obi chloroplast DNA, complete genome | blastn | 666 | 407 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 6154394 | 6154394 | PRJNA1247234_P_NODE_15845_length_283_cov_2.352381_g15689_i0 | PRJNA1247234 | 15845 | 283 | 2.352381 | 6.65723823 | Trebouxiophyceae | 75966 | Plants | Plants | 523 | 4.5999999999999983e-144 | NTclustered | gi|359385265|emb|FR865679.1| | 3082 | g15689 | i0 | 100 | 100.028268551237 | 283 | 0 | 100 | 0 | 1 | 283 | 347 | 65 | 'Chlorella' saccharophila genomic DNA containing 18S rRNA gene, ITS1, culture collection CCAP 211/60 | blastn | 28308 | 523 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium saccharophilum | |
| 6729051 | 6729051 | PRJNA1247234_P_NODE_10786_length_331_cov_9.701550_g10630_i0 | PRJNA1247234 | 10786 | 331 | 9.70155 | 32.1121305 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 604 | 1.9099999999999992e-168 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g10630 | i0 | 99.697 | 63.6283987915408 | 330 | 1 | 99 | 0 | 2 | 331 | 39846 | 39517 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 21061 | 604 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 8004723 | 8004723 | PRJNA1247234_P_NODE_20087_length_253_cov_0.866667_g19931_i0 | PRJNA1247234 | 20087 | 253 | 0.866667 | 2.19266751 | Paradoxia multiseta | 249350 | Plants | Plants | 320 | 5.7e-83 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g19931 | i0 | 96.859 | 2.25691699604743 | 191 | 6 | 75 | 0 | 4 | 194 | 77650 | 77460 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 571 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 13105103 | 13105103 | PRJNA1247234_P_NODE_10071_length_341_cov_1.160448_g9915_i0 | PRJNA1247234 | 10071 | 341 | 1.160448 | 3.95712768 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 311 | 4.82e-80 | NTclustered | gi|545371217|ref|XM_005650135.1| | 574566 | g9915 | i0 | 88.627 | 0.747800586510264 | 255 | 29 | 75 | 0 | 1 | 255 | 1185 | 931 | Coccomyxa subellipsoidea C-169 Aminomethyltransferase folate-binding domain-containing protein partial mRNA | blastn | 255 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 15654508 | 15654508 | PRJNA1247234_P_NODE_24973_length_246_cov_0.901734_g24817_i0 | PRJNA1247234 | 24973 | 246 | 0.901734 | 2.21826564 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 198 | 2.7e-46 | NTclustered | gi|545374899|ref|XM_005651627.1| | 574566 | g24817 | i0 | 92.143 | 0.991869918699187 | 140 | 11 | 57 | 0 | 107 | 246 | 2210 | 2071 | Coccomyxa subellipsoidea C-169 acetyl-CoA synthetase-like protein partial mRNA | blastn | 244 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17629449 | 17629449 | PRJNA1247234_P_NODE_1914_length_681_cov_2.465461_g1777_i0 | PRJNA1247234 | 1914 | 681 | 2.465461 | 16.78978941 | Chlorellales | 35460 | Plants | Plants | 1238 | 0 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g1777 | i0 | 99.558 | 109.660792951542 | 679 | 3 | 99 | 0 | 1 | 679 | 2883 | 3561 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 74679 | 1243 | 0.99597747385358 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 18203105 | 18203105 | PRJNA1247234_P_NODE_18975_length_260_cov_1.673797_g18819_i0 | PRJNA1247234 | 18975 | 260 | 1.673797 | 4.3518722 | uncultured Xylochloris | 1240681 | Plants | Plants | 481 | 2.55e-131 | NTclustered | gi|1604999876|gb|MH807086.1| | 1240681 | g18819 | i0 | 100 | 100.046153846154 | 260 | 0 | 100 | 0 | 1 | 260 | 350 | 91 | Uncultured Xylochloris clone GJF_0cmS_K30 18S ribosomal RNA gene, partial sequence | blastn | 26012 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Xylochloris | ||||
| 20177863 | 20177863 | PRJNA1247234_P_NODE_23276_length_248_cov_3.565714_g23120_i0 | PRJNA1247234 | 23276 | 248 | 3.565714 | 8.84297072 | Coccomyxaceae | 35472 | Plants | Plants | 448 | 2.4499999999999996e-121 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g23120 | i0 | 99.592 | 143.395161290323 | 245 | 1 | 99 | 0 | 4 | 248 | 2143 | 1899 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 35562 | 448 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 23304010 | 23304010 | PRJNA1247234_P_NODE_8959_length_357_cov_2.961268_g8803_i0 | PRJNA1247234 | 8959 | 357 | 2.961268 | 10.57172676 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 394 | 4.87e-105 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g8803 | i0 | 86.685 | 23.9271708683473 | 368 | 33 | 100 | 13 | 1 | 357 | 5749 | 5387 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 8542 | 394 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 27597335 | 27597335 | PRJNA1247234_P_NODE_14104_length_298_cov_1.040000_g13948_i0 | PRJNA1247234 | 14104 | 298 | 1.04 | 3.0992 | Coccomyxa | 41891 | Plants | Plants | 179 | 1.93e-51 | NR | XP_005650226.1 | 574566 | g13948 | i0 | 89.2 | 1.91275167785235 | 93 | 10 | 93.6 | 0 | 18 | 296 | 66 | 158 | XP_005650226.1 cytochrome P450 [Coccomyxa subellipsoidea C-169] | diamond | 570 | 180 | 0.994444444444444 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 30041948 | 30041948 | PRJNA1247234_P_NODE_17371_length_272_cov_1.557789_g17215_i0 | PRJNA1247234 | 17371 | 272 | 1.557789 | 4.23718608 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 169 | 1.93e-51 | NR | BDA49585.1 | 2315456 | g17215 | i0 | 90 | 0.992647058823529 | 90 | 9 | 99.3 | 0 | 1 | 270 | 77 | 166 | BDA49585.1 hypothetical protein COCOBI_14-2040 [Coccomyxa sp. Obi] | diamond | 270 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi |
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);;