contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA358490" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 398942 | 398942 | PRJNA358490_P_NODE_10541_length_305_cov_6.921053_g10199_i0 | PRJNA358490 | 10541 | 305 | 6.921053 | 21.10921165 | Stichococcus bacillaris | 37433 | Plants | Plants | 529 | 1.0799999999999996e-145 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g10199 | i0 | 100 | 93.2622950819672 | 286 | 0 | 94 | 0 | 1 | 286 | 3203 | 2918 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 28445 | 529 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 399129 | 399129 | PRJNA358490_P_NODE_6981_length_486_cov_4.794183_g6649_i0 | PRJNA358490 | 6981 | 486 | 4.794183 | 23.29972938 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 99 | 6e-16 | NTclustered | gi|2917929806|emb|OZ234924.1| | 3350044 | g6649 | i0 | 82.456 | 0.234567901234568 | 114 | 19 | 23 | 1 | 1 | 113 | 618902 | 618789 | Trebouxia sp. SL0000003 genome assembly, chromosome: 19 | blastn | 114 | 99 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 4226116 | 4226116 | PRJNA358490_P_NODE_12244_length_243_cov_1.745098_g11900_i0 | PRJNA358490 | 12244 | 243 | 1.745098 | 4.24058814 | uncultured Chlamydomonadales | 341166 | Plants | Plants | 302 | 1.97e-77 | NTclustered | gi|2006881308|emb|HG996264.1| | 341166 | g11900 | i0 | 89.256 | 99.5020576131687 | 242 | 24 | 99 | 2 | 1 | 241 | 934 | 694 | uncultured Chlamydomonadales genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone d9c15149 | blastn | 24179 | 302 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | uncultured Chlamydomonadales | |||
| 6776614 | 6776614 | PRJNA358490_P_NODE_146_length_2289_cov_4.738222_g130_i0 | PRJNA358490 | 146 | 2289 | 4.738222 | 108.45790158 | Stichococcus bacillaris | 37433 | Plants | Plants | 4178 | 0 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g130 | i0 | 99.868 | 51.9598077763215 | 2273 | 0 | 99 | 2 | 1 | 2270 | 30493 | 28221 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 118936 | 4178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 7451100 | 7451100 | PRJNA358490_P_NODE_12966_length_222_cov_3.278689_g12622_i0 | PRJNA358490 | 12966 | 222 | 3.278689 | 7.27868958 | Trebouxiophyceae | 75966 | Plants | Plants | 274 | 3.86e-69 | NTclustered | gi|2724824453|gb|PP746560.1| | 173497 | g12622 | i0 | 91.089 | 89.2117117117117 | 202 | 18 | 91 | 0 | 1 | 202 | 2324 | 2123 | Pseudochlorella signiensis culture SAG:7.90 mitochondrion, complete genome | blastn | 19805 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 9327199 | 9327199 | PRJNA358490_P_NODE_5188_length_602_cov_2.751332_g4901_i0 | PRJNA358490 | 5188 | 602 | 2.751332 | 16.56301864 | Volvox carteri | 3067 | Plants | Plants | 128 | 9.63e-25 | NTclustered | gi|302853011|ref|XM_002957977.1| | 3068 | g4901 | i0 | 82.877 | 0.365448504983389 | 146 | 21 | 24 | 4 | 96 | 239 | 38 | 181 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl28), mRNA | blastn | 220 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 10602661 | 10602661 | PRJNA358490_P_NODE_10189_length_323_cov_3.366197_g9847_i0 | PRJNA358490 | 10189 | 323 | 3.366197 | 10.87281631 | Koliella longiseta | 33092 | Plants | Plants | 305 | 2.11e-78 | NTclustered | gi|2724824530|gb|PP746562.1| | 33092 | g9847 | i0 | 85.235 | 2.81733746130031 | 298 | 43 | 92 | 1 | 20 | 316 | 48056 | 48353 | Koliella longiseta culture UTEX:339 mitochondrion, complete genome | blastn | 910 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 10602676 | 10602676 | PRJNA358490_P_NODE_10969_length_288_cov_3.879518_g10627_i0 | PRJNA358490 | 10969 | 288 | 3.879518 | 11.17301184 | Myrmecia israelensis | 3171 | Plants | Plants | 111 | 4.33e-20 | NTclustered | gi|2724824566|gb|PP746563.1| | 3171 | g10627 | i0 | 91.358 | 5.19097222222222 | 81 | 7 | 28 | 0 | 82 | 162 | 2787 | 2867 | Myrmecia israelensis culture UTEX:1181 mitochondrion, complete genome | blastn | 1495 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia israelensis | |
| 10602766 | 10602766 | PRJNA358490_P_NODE_17669_length_155_cov_1.741379_g17325_i0 | PRJNA358490 | 17669 | 155 | 1.741379 | 2.69913745 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 215 | 1.54e-51 | NTclustered | gi|2917929690|emb|OZ234918.1| | 3350044 | g17325 | i0 | 91.613 | 1 | 155 | 13 | 100 | 0 | 1 | 155 | 2272917 | 2273071 | Trebouxia sp. SL0000003 genome assembly, chromosome: 13 | blastn | 155 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 13152622 | 13152622 | PRJNA358490_P_NODE_10151_length_325_cov_4.531469_g9809_i0 | PRJNA358490 | 10151 | 325 | 4.531469 | 14.72727425 | Stichococcus bacillaris | 37433 | Plants | Plants | 595 | 1.1299999999999995e-165 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g9809 | i0 | 99.693 | 89.3815384615385 | 326 | 0 | 100 | 1 | 1 | 325 | 75413 | 75738 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 29049 | 595 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 13152648 | 13152648 | PRJNA358490_P_NODE_12051_length_248_cov_5.220096_g11707_i0 | PRJNA358490 | 12051 | 248 | 5.220096 | 12.94583808 | Stichococcus bacillaris | 37433 | Plants | Plants | 383 | 7.0000000000000005e-102 | NTclustered | gi|371782130|emb|HE610162.1| | 37433 | g11707 | i0 | 96.943 | 110.895161290323 | 229 | 5 | 92 | 2 | 1 | 228 | 1040 | 813 | Stichococcus bacillaris plastid partial 23S rRNA gene, strain SAG 379-2 | blastn | 27502 | 383 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 14427714 | 14427714 | PRJNA358490_P_NODE_12272_length_242_cov_2.295567_g11928_i0 | PRJNA358490 | 12272 | 242 | 2.295567 | 5.55527214 | Stichococcus bacillaris | 37433 | Plants | Plants | 448 | 2.3799999999999995e-121 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g11928 | i0 | 100 | 35.099173553719 | 242 | 0 | 100 | 0 | 1 | 242 | 59638 | 59879 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 8494 | 448 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 14427857 | 14427857 | PRJNA358490_P_NODE_5372_length_589_cov_3.576364_g5076_i0 | PRJNA358490 | 5372 | 589 | 3.576364 | 21.06478396 | Ulva compressa | 63659 | Plants | Plants | 390 | 1.09e-103 | NTclustered | gi|2043344467|gb|MW353781.1| | 63659 | g5076 | i0 | 79.928 | 113.560271646859 | 558 | 91 | 94 | 13 | 30 | 585 | 69734 | 69196 | Ulva compressa isolate Uco3 plastid, complete genome | blastn | 66887 | 390 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva compressa | |
| 14427898 | 14427898 | PRJNA358490_P_NODE_8512_length_411_cov_5.446237_g8171_i0 | PRJNA358490 | 8512 | 411 | 5.446237 | 22.38403407 | Stichococcus bacillaris | 37433 | Plants | Plants | 723 | 0 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g8171 | i0 | 100 | 0.951338199513382 | 391 | 0 | 95 | 0 | 1 | 391 | 86773 | 86383 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 391 | 723 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 16976326 | 16976326 | PRJNA358490_P_NODE_11614_length_263_cov_2.883929_g11270_i0 | PRJNA358490 | 11614 | 263 | 2.883929 | 7.58473327 | Stichococcus bacillaris | 37433 | Plants | Plants | 449 | 7.29e-122 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g11270 | i0 | 100 | 0.923954372623574 | 243 | 0 | 92 | 0 | 1 | 243 | 72016 | 71774 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 243 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 18250598 | 18250598 | PRJNA358490_P_NODE_13795_length_202_cov_4.177914_g13451_i0 | PRJNA358490 | 13795 | 202 | 4.177914 | 8.43938628 | uncultured Apatococcus | 1229086 | Plants | Plants | 331 | 2.02e-86 | NTclustered | gi|1031961072|gb|KX025113.1| | 1229086 | g13451 | i0 | 99.451 | 87.3762376237624 | 182 | 1 | 90 | 0 | 21 | 202 | 1026 | 1207 | Uncultured Apatococcus clone GOGs_K31 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 17650 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Apatococcus | ||||
| 19524894 | 19524894 | PRJNA358490_P_NODE_4816_length_633_cov_3.276094_g4544_i0 | PRJNA358490 | 4816 | 633 | 3.276094 | 20.73767502 | Trebouxia lynnae | 1825957 | Plants | Plants | 551 | 5.079999999999998e-152 | NTclustered | gi|1812100161|ref|NC_045839.1| | 1825957 | g4544 | i0 | 96.687 | 85.4533965244866 | 332 | 10 | 76 | 1 | 273 | 603 | 214706 | 214375 | Trebouxia sp. TR9 chloroplast, partial genome | blastn | 54092 | 551 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 20800454 | 20800454 | PRJNA358490_P_NODE_13297_length_213_cov_4.109195_g12953_i0 | PRJNA358490 | 13297 | 213 | 4.109195 | 8.75258535 | Stichococcus bacillaris | 37433 | Plants | Plants | 355 | 1.28e-93 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g12953 | i0 | 100 | 35.6291079812207 | 192 | 0 | 90 | 0 | 22 | 213 | 97666 | 97857 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 7589 | 355 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 20800596 | 20800596 | PRJNA358490_P_NODE_6717_length_503_cov_1.719828_g6387_i0 | PRJNA358490 | 6717 | 503 | 1.719828 | 8.65073484 | Stichococcus bacillaris | 37433 | Plants | Plants | 889 | 0 | NTclustered | gi|723457333|ref|NC_025527.1| | 37433 | g6387 | i0 | 100 | 1.01192842942346 | 481 | 0 | 96 | 0 | 21 | 501 | 73839 | 74319 | Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome | blastn | 509 | 889 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 22075524 | 22075524 | PRJNA358490_P_NODE_15638_length_174_cov_1.496296_g15294_i0 | PRJNA358490 | 15638 | 174 | 1.496296 | 2.60355504 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 224 | 2.93e-54 | NTclustered | gi|760444702|ref|XM_011401118.1| | 3075 | g15294 | i0 | 90.533 | 65.4540229885057 | 169 | 16 | 97 | 0 | 1 | 169 | 230 | 398 | Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA | blastn | 11389 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;