contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2296948 | 2296948 | PRJNA1111146_P_NODE_169202_length_214_cov_1.260870_g168064_i0 | PRJNA1111146 | 169202 | 214 | 1.26087 | 2.6982618 | Chlorophyta | 3041 | Plants | Plants | 396 | 7.559999999999996e-106 | NTclustered | gi|1518373083|gb|MK201746.1| | 152768 | g168064 | i0 | 100 | 99.1728971962617 | 214 | 0 | 100 | 0 | 1 | 214 | 991 | 778 | Diplosphaera chodatii strain KZ-26-5 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21223 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera chodatii | |
| 3572264 | 3572264 | PRJNA1111146_P_NODE_253543_length_195_cov_3.500000_g252405_i0 | PRJNA1111146 | 253543 | 195 | 3.5 | 6.825 | Trebouxia | 13786 | Plants | Plants | 361 | 2.46e-95 | NTclustered | gi|94448695|emb|AJ969523.1| | 285713 | g252405 | i0 | 100 | 99.8 | 195 | 0 | 100 | 0 | 1 | 195 | 1391 | 1197 | Uncultured Trebouxia photobiont 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 26S rRNA gene (partial), isolate L-43 | blastn | 19461 | 361 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 4043034 | 4043034 | PRJNA1111146_P_NODE_282104_length_190_cov_1.635036_g280966_i0 | PRJNA1111146 | 282104 | 190 | 1.635036 | 3.1065684 | Volvox carteri | 3067 | Plants | Plants | 52.8 | 0.016 | NTclustered | gi|302840865|ref|XM_002951933.1| | 3068 | g280966 | i0 | 100 | 0.147368421052632 | 28 | 0 | 15 | 0 | 116 | 143 | 67 | 40 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_105299), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 5319848 | 5319848 | PRJNA1111146_P_NODE_45805_length_294_cov_2.161826_g44668_i0 | PRJNA1111146 | 45805 | 294 | 2.161826 | 6.35576844 | Stichococcus bacillaris | 37433 | Plants | Plants | 318 | 2.439999999999999e-82 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g44668 | i0 | 96.842 | 14.187074829932 | 190 | 6 | 65 | 0 | 105 | 294 | 7182 | 6993 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 4171 | 318 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 6125369 | 6125369 | PRJNA1111146_P_NODE_98565_length_244_cov_1.345550_g97427_i0 | PRJNA1111146 | 98565 | 244 | 1.34555 | 3.283142 | Trebouxia | 13786 | Plants | Plants | 451 | 1.86e-122 | NTclustered | gi|255653890|gb|FJ804758.1| | 664443 | g97427 | i0 | 100 | 107.91393442623 | 244 | 0 | 100 | 0 | 1 | 244 | 1458 | 1701 | Trebouxia australis strain SAG 2205 large subunit ribosomal RNA gene, partial sequence; and hypothetical protein gene, complete cds; chloroplast | blastn | 26331 | 451 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia australis | |
| 6594065 | 6594065 | PRJNA1111146_P_NODE_214766_length_203_cov_1.553333_g213628_i0 | PRJNA1111146 | 214766 | 203 | 1.553333 | 3.15326599 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 348 | 2.0100000000000006e-91 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g213628 | i0 | 97.537 | 100.64039408867 | 203 | 5 | 100 | 0 | 1 | 203 | 2276 | 2074 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 20430 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 9949659 | 9949659 | PRJNA1111146_P_NODE_15108_length_411_cov_3.148045_g13974_i0 | PRJNA1111146 | 15108 | 411 | 3.148045 | 12.93846495 | Trebouxia | 13786 | Plants | Plants | 743 | 0 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g13974 | i0 | 99.27 | 100.216545012165 | 411 | 3 | 100 | 0 | 1 | 411 | 6600 | 6190 | Uncultured Trebouxia photobiont voucher Lendemer 46119 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 | 41189 | 743 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 11695840 | 11695840 | PRJNA1111146_P_NODE_75890_length_260_cov_1.091787_g74752_i0 | PRJNA1111146 | 75890 | 260 | 1.091787 | 2.8386462 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 481 | 2.55e-131 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g74752 | i0 | 100 | 100.873076923077 | 260 | 0 | 100 | 0 | 1 | 260 | 269 | 528 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 26227 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 16792734 | 16792734 | PRJNA1111146_P_NODE_120894_length_233_cov_1.250000_g119756_i0 | PRJNA1111146 | 120894 | 233 | 1.25 | 2.9125 | Trebouxia angustilobata | 664442 | Plants | Plants | 431 | 2.2899999999999996e-116 | NTclustered | gi|255654043|gb|FJ694755.1| | 664442 | g119756 | i0 | 100 | 131.618025751073 | 233 | 0 | 100 | 0 | 1 | 233 | 3109 | 2877 | Trebouxia angustilobata strain SAG 2204 23S ribosomal RNA gene, partial sequence; and hypothetical protein genes, complete cds; chloroplast | blastn | 30667 | 431 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia angustilobata | |
| 16793993 | 16793993 | PRJNA1111146_P_NODE_422834_length_178_cov_0.896000_g421696_i0 | PRJNA1111146 | 422834 | 178 | 0.896 | 1.59488 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 248 | 1.7899999999999997e-61 | NTclustered | gi|2917929693|emb|OZ234920.1| | 3350044 | g421696 | i0 | 92.045 | 0.98876404494382 | 176 | 14 | 99 | 0 | 3 | 178 | 1443990 | 1443815 | Trebouxia sp. SL0000003 genome assembly, chromosome: 15 | blastn | 176 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 22698417 | 22698417 | PRJNA1111146_P_NODE_161758_length_216_cov_2.975460_g160620_i0 | PRJNA1111146 | 161758 | 216 | 2.97546 | 6.4269936 | Chlorophyta | 3041 | Plants | Plants | 390 | 3.559999999999999e-104 | NTclustered | gi|1523765370|gb|MK231279.1| | 29647 | g160620 | i0 | 99.533 | 99.0231481481482 | 214 | 1 | 99 | 0 | 3 | 216 | 825 | 612 | Stichococcus sp. strain KZ-5-1-1 small subunit ribosomal RNA gene, partial sequence | blastn | 21389 | 390 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 23169401 | 23169401 | PRJNA1111146_P_NODE_66539_length_268_cov_1.651163_g65401_i0 | PRJNA1111146 | 66539 | 268 | 1.651163 | 4.42511684 | Trebouxia aggregata | 160068 | Plants | Plants | 479 | 9.499999999999996e-131 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g65401 | i0 | 98.885 | 126.667910447761 | 269 | 2 | 100 | 1 | 1 | 268 | 2312 | 2044 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 33947 | 479 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 23974467 | 23974467 | PRJNA1111146_P_NODE_444879_length_172_cov_2.369748_g443741_i0 | PRJNA1111146 | 444879 | 172 | 2.369748 | 4.07596656 | Trebouxia | 13786 | Plants | Plants | 313 | 5.989999999999998e-81 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g443741 | i0 | 100 | 24.5639534883721 | 169 | 0 | 98 | 0 | 1 | 169 | 8505 | 8673 | Uncultured Trebouxia photobiont voucher Lendemer 46119 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 | 4225 | 315 | 0.993650793650794 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 24442492 | 24442492 | PRJNA1111146_P_NODE_352720_length_182_cov_0.883721_g351582_i0 | PRJNA1111146 | 352720 | 182 | 0.883721 | 1.60837222 | Chlamydomonas sp. KGE21 | 1220820 | Plants | Plants | 322 | 1.07e-83 | NTclustered | gi|408440877|emb|HE974909.1| | 1220820 | g351582 | i0 | 98.895 | 82.0769230769231 | 181 | 1 | 99 | 1 | 3 | 182 | 512 | 332 | Chlamydomonas sp. KGE21 partial 28S rRNA gene, strain KGE21 | blastn | 14938 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. KGE21 | |
| 24443038 | 24443038 | PRJNA1111146_P_NODE_59540_length_276_cov_1.170404_g58403_i0 | PRJNA1111146 | 59540 | 276 | 1.170404 | 3.23031504 | Monoraphidium pusillum | 307512 | Plants | Plants | 510 | 3.48e-140 | NTclustered | gi|2720437858|gb|PP711304.1| | 307512 | g58403 | i0 | 100 | 100.300724637681 | 276 | 0 | 100 | 0 | 1 | 276 | 3028 | 2753 | Monoraphidium pusillum strain Ga024 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 | 27683 | 510 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium pusillum |
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);;