contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 739485 | 739485 | PRJNA758398_S_NODE_13861_length_265_cov_1.083333_g13720_i0 | PRJNA758398 | 13861 | 265 | 1.083333 | 2.87083245 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 100 | 8.53e-17 | NTclustered | gi|1825511251|gb|MN642622.1| | 2608996 | g13720 | i0 | 89.024 | 2.52830188679245 | 82 | 8 | 31 | 1 | 53 | 133 | 86210 | 86129 | Trebouxia sp. A1-2 mitochondrion, complete genome | blastn | 670 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 739681 | 739681 | PRJNA758398_S_NODE_2861_length_556_cov_1.765286_g2725_i0 | PRJNA758398 | 2861 | 556 | 1.765286 | 9.81499016 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 370 | 1.33e-97 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g2725 | i0 | 79.099 | 85.0647482014388 | 555 | 102 | 99 | 13 | 1 | 548 | 834 | 287 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 47296 | 370 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 2015903 | 2015903 | PRJNA758398_S_NODE_40622_length_169_cov_2.975000_g40481_i0 | PRJNA758398 | 40622 | 169 | 2.975 | 5.02775 | Prototheca blaschkeae | 328666 | Plants | Plants | 148 | 1.75e-31 | NTclustered | gi|1159431138|gb|KX389282.1| | 328666 | g40481 | i0 | 94.737 | 55.3431952662722 | 95 | 5 | 56 | 0 | 1 | 95 | 192 | 98 | Prototheca blaschkeae isolate SAG-2064 alpha tubulin (TUA1) mRNA, complete cds | blastn | 9353 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca blaschkeae | |
| 4568356 | 4568356 | PRJNA758398_S_NODE_54864_length_160_cov_2.108108_g54723_i0 | PRJNA758398 | 54864 | 160 | 2.108108 | 3.3729728 | Chlorella variabilis | 554065 | Plants | Plants | 246 | 5.67e-61 | NTclustered | gi|552844675|ref|XM_005851082.1| | 554065 | g54723 | i0 | 94.375 | 98.89375 | 160 | 9 | 100 | 0 | 1 | 160 | 350 | 191 | Chlorella variabilis alpha-tubulin (CHLNCDRAFT_33793) mRNA, complete cds | blastn | 15823 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 5843440 | 5843440 | PRJNA758398_S_NODE_46165_length_165_cov_0.879310_g46024_i0 | PRJNA758398 | 46165 | 165 | 0.87931 | 1.4508615 | Monoraphidium neglectum | 145388 | Plants | Plants | 126 | 8.02e-25 | NTclustered | gi|926777351|ref|XM_014041696.1| | 145388 | g46024 | i0 | 89.899 | 11.6787878787879 | 99 | 8 | 59 | 2 | 51 | 148 | 191 | 94 | Monoraphidium neglectum 60S ribosomal protein L38 mRNA | blastn | 1927 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 8392748 | 8392748 | PRJNA758398_S_NODE_10427_length_300_cov_2.466135_g10286_i0 | PRJNA758398 | 10427 | 300 | 2.466135 | 7.398405 | Chlorella variabilis | 554065 | Plants | Plants | 148 | 3.4599999999999996e-31 | NTclustered | gi|552841639|ref|XM_005850301.1| | 554065 | g10286 | i0 | 79.343 | 2.00666666666667 | 213 | 42 | 71 | 2 | 62 | 273 | 485 | 274 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59600) mRNA, complete cds | blastn | 602 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 8393031 | 8393031 | PRJNA758398_S_NODE_32247_length_188_cov_1.417266_g32106_i0 | PRJNA758398 | 32247 | 188 | 1.417266 | 2.66446008 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 121 | 4.3499999999999997e-23 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g32106 | i0 | 87.619 | 4.03191489361702 | 105 | 11 | 55 | 2 | 15 | 118 | 247 | 144 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 758 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10133013 | 10133013 | PRJNA758398_S_NODE_17508_length_239_cov_3.057895_g17367_i0 | PRJNA758398 | 17508 | 239 | 3.057895 | 7.30836905 | Eukaryota | 2759 | Plants | Plants | 331 | 2.46e-86 | NTclustered | gi|760442684|ref|XM_011400109.1| | 3075 | g17367 | i0 | 91.632 | 98.2092050209205 | 239 | 20 | 100 | 0 | 1 | 239 | 324 | 562 | Auxenochlorella protothecoides Tubulin alpha chain partial mRNA | blastn | 23472 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 10943665 | 10943665 | PRJNA758398_S_NODE_17409_length_240_cov_1.429319_g17268_i0 | PRJNA758398 | 17409 | 240 | 1.429319 | 3.4303656 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 132 | 2.7e-26 | NTclustered | gi|545354978|ref|XM_005643253.1| | 574566 | g17268 | i0 | 87.179 | 34.2875 | 117 | 13 | 48 | 2 | 18 | 133 | 270 | 155 | Coccomyxa subellipsoidea C-169 ribosomal protein S11 component of cytosolic 80S ribosome and 40S small subunit mRNA | blastn | 8229 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19866587 | 19866587 | PRJNA758398_S_NODE_27496_length_201_cov_1.006579_g27355_i0 | PRJNA758398 | 27496 | 201 | 1.006579 | 2.02322379 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 89.8 | 1.33e-13 | NTclustered | gi|545354978|ref|XM_005643253.1| | 574566 | g27355 | i0 | 87.179 | 24.2437810945274 | 78 | 10 | 39 | 0 | 61 | 138 | 241 | 164 | Coccomyxa subellipsoidea C-169 ribosomal protein S11 component of cytosolic 80S ribosome and 40S small subunit mRNA | blastn | 4873 | 89.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19866875 | 19866875 | PRJNA758398_S_NODE_51796_length_162_cov_0.902655_g51655_i0 | PRJNA758398 | 51796 | 162 | 0.902655 | 1.4623011 | Chlorella variabilis | 554065 | Plants | Plants | 60.2 | 8.06e-5 | NTclustered | gi|552833102|ref|XM_005848420.1| | 554065 | g51655 | i0 | 90.909 | 0.271604938271605 | 44 | 4 | 27 | 0 | 92 | 135 | 1234 | 1191 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_57621) mRNA, complete cds | blastn | 44 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 20330813 | 20330813 | PRJNA758398_S_NODE_2156_length_628_cov_3.901554_g2026_i0 | PRJNA758398 | 2156 | 628 | 3.901554 | 24.50175912 | Eukaryota | 2759 | Plants | Plants | 58.4 | 0.001 | NTclustered | gi|2089724583|gb|MZ446957.1| | 78182 | g2026 | i0 | 100 | 2.38057324840764 | 31 | 0 | 5 | 0 | 101 | 131 | 1384 | 1414 | Vitreochlamys ordinata strain NIES-882 pumilio family protein mRNA, partial cds | blastn | 1495 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Vitreochlamys | Vitreochlamys ordinata | |
| 21142210 | 21142210 | PRJNA758398_S_NODE_2437_length_595_cov_2.016484_g2305_i0 | PRJNA758398 | 2437 | 595 | 2.016484 | 11.9980798 | Chlamydomonas incerta | 51695 | Plants | Plants | 453 | 1.38e-122 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g2305 | i0 | 84.683 | 86.0621848739496 | 457 | 66 | 76 | 4 | 53 | 507 | 34 | 488 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 51207 | 453 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 22417146 | 22417146 | PRJNA758398_S_NODE_33158_length_186_cov_1.116788_g33017_i0 | PRJNA758398 | 33158 | 186 | 1.116788 | 2.07722568 | Chlorella sp. ArM0029B | 1415603 | Plants | Plants | 73.1 | 1.22e-8 | NTclustered | gi|1432229018|gb|MG669273.1| | 1415603 | g33017 | i0 | 90.741 | 0.290322580645161 | 54 | 5 | 29 | 0 | 103 | 156 | 657 | 710 | Chlorella sp. ArM0029B RHP1 protein mRNA, complete cds | blastn | 54 | 73.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. ArM0029B | |
| 23692440 | 23692440 | PRJNA758398_S_NODE_1279_length_794_cov_2.761074_g1178_i0 | PRJNA758398 | 1279 | 794 | 2.761074 | 21.92292756 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 390 | 1.49e-103 | NTclustered | gi|2082259086|ref|XM_001697336.2| | 3055 | g1178 | i0 | 84.557 | 49.1523929471033 | 395 | 59 | 50 | 2 | 290 | 683 | 515 | 122 | Chlamydomonas reinhardtii ribosomal protein S14 (CHLRE_11g480150v5), mRNA | blastn | 39027 | 390 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23692828 | 23692828 | PRJNA758398_S_NODE_42339_length_167_cov_0.864407_g42198_i0 | PRJNA758398 | 42339 | 167 | 0.864407 | 1.44355969 | Monoraphidium neglectum | 145388 | Plants | Plants | 87.9 | 3.84e-13 | NTclustered | gi|926788852|ref|XM_014047446.1| | 145388 | g42198 | i0 | 79.508 | 0.730538922155689 | 122 | 25 | 73 | 0 | 45 | 166 | 700 | 821 | Monoraphidium neglectum putative 60S ribosomal protein L13 mRNA | blastn | 122 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;