contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4245384 | 4245384 | PRJNA408129_S_NODE_12864_length_205_cov_4.464286_g12846_i0 | PRJNA408129 | 12864 | 205 | 4.464286 | 9.1517863 | Trebouxia lynnae | 1825957 | Plants | Plants | 353 | 4.38e-93 | NTclustered | gi|1812100161|ref|NC_045839.1| | 1825957 | g12846 | i0 | 98.03 | 27.390243902439 | 203 | 4 | 99 | 0 | 3 | 205 | 197226 | 197428 | Trebouxia sp. TR9 chloroplast, partial genome | blastn | 5615 | 353 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 4245405 | 4245405 | PRJNA408129_S_NODE_14904_length_196_cov_2.232704_g14886_i0 | PRJNA408129 | 14904 | 196 | 2.232704 | 4.37609984 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 108 | 3.57e-19 | NTclustered | gi|2917929623|emb|OZ234911.1| | 3350044 | g14886 | i0 | 95.522 | 0.341836734693878 | 67 | 3 | 34 | 0 | 2 | 68 | 3352184 | 3352250 | Trebouxia sp. SL0000003 genome assembly, chromosome: 6 | blastn | 67 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 5522209 | 5522209 | PRJNA408129_S_NODE_24645_length_167_cov_20.315385_g24627_i0 | PRJNA408129 | 24645 | 167 | 20.315385 | 33.92669295 | Polulichloris maxima | 2704661 | Plants | Plants | 244 | 2.15e-60 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g24627 | i0 | 96.599 | 10.3173652694611 | 147 | 5 | 88 | 0 | 2 | 148 | 125451 | 125305 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 1723 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 6796102 | 6796102 | PRJNA408129_S_NODE_15026_length_195_cov_5.626582_g15008_i0 | PRJNA408129 | 15026 | 195 | 5.626582 | 10.9718349 | Microspora stagnorum | 163317 | Plants | Plants | 141 | 3.5e-29 | NTclustered | gi|563940464|ref|NC_022862.1| | 163317 | g15008 | i0 | 91.262 | 0.528205128205128 | 103 | 9 | 53 | 0 | 85 | 187 | 271 | 169 | Microspora stagnorum culture-collection SAG:51.86 mitochondrion, complete genome | blastn | 103 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Microsporaceae | Microspora | Microspora stagnorum | ||
| 9346605 | 9346605 | PRJNA408129_S_NODE_31528_length_156_cov_1.411765_g31510_i0 | PRJNA408129 | 31528 | 156 | 1.411765 | 2.2023534 | Chlorella variabilis | 554065 | Plants | Plants | 152 | 1.23e-32 | NTclustered | gi|552809028|ref|XM_005842781.1| | 554065 | g31510 | i0 | 84.868 | 11.3846153846154 | 152 | 21 | 97 | 2 | 6 | 156 | 299 | 449 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_37706) mRNA, complete cds | blastn | 1776 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 13172038 | 13172038 | PRJNA408129_S_NODE_13031_length_204_cov_4.664671_g13013_i0 | PRJNA408129 | 13031 | 204 | 4.664671 | 9.51592884 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 111 | 2.89e-20 | NTclustered | gi|760439244|ref|XM_011398389.1| | 3075 | g13013 | i0 | 83.2 | 5.76960784313725 | 125 | 17 | 60 | 4 | 16 | 138 | 591 | 713 | Auxenochlorella protothecoides 60S ribosomal protein L7-2 partial mRNA | blastn | 1177 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 13172103 | 13172103 | PRJNA408129_S_NODE_19451_length_180_cov_4.216783_g19433_i0 | PRJNA408129 | 19451 | 180 | 4.216783 | 7.5902094 | Characiochloris acuminata | 167768 | Plants | Plants | 187 | 4.01e-43 | NTclustered | gi|959124528|ref|NC_028584.1| | 167768 | g19433 | i0 | 87.805 | 117.605555555556 | 164 | 14 | 88 | 5 | 4 | 162 | 94109 | 93947 | Characiochloris acuminata culture-collection SAG:31.95 chloroplast, complete genome | blastn | 21169 | 187 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Characiochloridaceae | Characiochloris | Characiochloris acuminata | |
| 13172141 | 13172141 | PRJNA408129_S_NODE_2331_length_323_cov_8.500000_g2313_i0 | PRJNA408129 | 2331 | 323 | 8.5 | 27.455 | Nannochloris normandinae | 926285 | Plants | Plants | 553 | 6.819999999999998e-153 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g2313 | i0 | 98.714 | 95.9009287925697 | 311 | 4 | 96 | 0 | 12 | 322 | 519 | 829 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 30976 | 553 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 14447198 | 14447198 | PRJNA408129_S_NODE_10332_length_219_cov_12.758242_g10314_i0 | PRJNA408129 | 10332 | 219 | 12.758242 | 27.94054998 | uncultured Symbiochloris | 2562465 | Plants | Plants | 281 | 2.27e-71 | NTclustered | gi|2509725906|gb|OR042192.1| | 2562465 | g10314 | i0 | 91.304 | 93.4063926940639 | 207 | 17 | 95 | 1 | 12 | 218 | 1017 | 1222 | Uncultured Symbiochloris clone BW01 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 | 20456 | 281 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Symbiochloris | ||||
| 14447346 | 14447346 | PRJNA408129_S_NODE_27892_length_161_cov_8.709677_g27874_i0 | PRJNA408129 | 27892 | 161 | 8.709677 | 14.02257997 | Trebouxia aggregata | 160068 | Plants | Plants | 122 | 1.0099999999999999e-23 | NTclustered | gi|162134308|gb|EU123972.1| | 160068 | g27874 | i0 | 89.583 | 0.596273291925466 | 96 | 10 | 60 | 0 | 2 | 97 | 7905 | 8000 | Trebouxia aggregata strain SAG 219-1d J protein of photosystem II (psbJ), L protein of photosystem II (psbL), cytochrome b559 beta subunit of photosystem II (psbF), and cytochrome b559 alpha subunit of photosystem II (psbE) genes, complete cds; chloroplast | blastn | 96 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 16385127 | 16385127 | PRJNA408129_S_NODE_18713_length_182_cov_5.572414_g18695_i0 | PRJNA408129 | 18713 | 182 | 5.572414 | 10.14179348 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.015 | NTclustered | gi|1008861523|ref|NC_029671.1| | 31300 | g18695 | i0 | 100 | 2.15384615384615 | 28 | 0 | 15 | 0 | 149 | 176 | 3227 | 3254 | Mychonastes homosphaera strain CAUP H6502 chloroplast, complete genome | blastn | 392 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Mychonastaceae | Mychonastes | Mychonastes homosphaera | |
| 24644793 | 24644793 | PRJNA408129_S_NODE_24040_length_169_cov_2.227273_g24022_i0 | PRJNA408129 | 24040 | 169 | 2.227273 | 3.76409137 | Stichococcus bacillaris | 37433 | Plants | Plants | 292 | 7.64e-75 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g24022 | i0 | 99.383 | 9.24852071005917 | 162 | 0 | 96 | 1 | 8 | 169 | 50344 | 50184 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 1563 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 25308871 | 25308871 | PRJNA408129_S_NODE_17420_length_186_cov_7.228188_g17402_i0 | PRJNA408129 | 17420 | 186 | 7.228188 | 13.44442968 | Trebouxia | 13786 | Plants | Plants | 311 | 2.38e-80 | NTclustered | gi|2105087|emb|Z95381.1| | 53268 | g17402 | i0 | 99.415 | 92.005376344086 | 171 | 1 | 92 | 0 | 16 | 186 | 132 | 302 | T.arboricola 26S rRNA gene | blastn | 17113 | 311 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia arboricola |
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);;