contig_metadata
20 rows where bioproject = "PRJNA564810", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9482557 | 9482557 | PRJNA564810_S_NODE_928_length_412_cov_1.959654_g906_i0 | PRJNA564810 | 928 | 412 | 1.959654 | 8.07377448 | Prototheca bovis | 2509265 | Plants | Plants | 150 | 1.36e-31 | NTclustered | gi|1770690688|ref|NC_045058.1| | 2509265 | g906 | i0 | 81.283 | 23.9126213592233 | 187 | 33 | 45 | 2 | 226 | 411 | 3155 | 2970 | Prototheca zopfii strain SAG 2021 mitochondrion, complete genome | blastn | 9852 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca bovis | |
| 13308226 | 13308226 | PRJNA564810_S_NODE_1431_length_366_cov_13.026578_g1409_i0 | PRJNA564810 | 1431 | 366 | 13.026578 | 47.67727548 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 60.2 | 2.08e-4 | NTclustered | gi|2082249810|ref|XM_043063891.1| | 3055 | g1409 | i0 | 100 | 0.087431693989071 | 32 | 0 | 9 | 0 | 48 | 79 | 4560 | 4529 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g316900v5), mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18406212 | 18406212 | PRJNA564810_S_NODE_7795_length_215_cov_1.360000_g7773_i0 | PRJNA564810 | 7795 | 215 | 1.36 | 2.924 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 54.7 | 0.005 | NTclustered | gi|2917929806|emb|OZ234924.1| | 3350044 | g7773 | i0 | 100 | 0.134883720930233 | 29 | 0 | 13 | 0 | 151 | 179 | 244081 | 244109 | Trebouxia sp. SL0000003 genome assembly, chromosome: 19 | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 20956267 | 20956267 | PRJNA564810_S_NODE_1377_length_371_cov_2.212418_g1355_i0 | PRJNA564810 | 1377 | 371 | 2.212418 | 8.20807078 | Chlorellaceae | 35461 | Plants | Plants | 78.6 | 1.96e-14 | NR | PRW20369.1 | 3076 | g1355 | i0 | 53.3 | 3 | 75 | 32 | 60.6 | 1 | 369 | 145 | 237 | 308 | PRW20369.1 hypothetical protein C2E21_9039 [Chlorella sorokiniana] | diamond | 1113 | 78.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 24085440 | 24085440 | PRJNA564810_S_NODE_459_length_507_cov_14.190045_g438_i0 | PRJNA564810 | 459 | 507 | 14.190045 | 71.94352815 | Trebouxiophyceae | 75966 | Plants | Plants | 63.9 | 2.29e-5 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g438 | i0 | 95 | 12.9151873767258 | 40 | 2 | 8 | 0 | 84 | 123 | 76 | 37 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 6548 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 27047729 | 27047729 | PRJNA564810_S_NODE_2062_length_334_cov_3.680297_g2040_i0 | PRJNA564810 | 2062 | 334 | 3.680297 | 12.29219198 | Tetradesmus obliquus | 3088 | Plants | Plants | 82.8 | 2.9e-18 | NR | WIA21139.1 | 3088 | g2040 | i0 | 69.5 | 1.63473053892216 | 59 | 18 | 53 | 0 | 331 | 155 | 14 | 72 | WIA21139.1 hypothetical protein OEZ85_005450 [Tetradesmus obliquus] | diamond | 546 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 27173910 | 27173910 | PRJNA564810_S_NODE_8602_length_201_cov_3.330882_g8580_i0 | PRJNA564810 | 8602 | 201 | 3.330882 | 6.69507282 | Haematococcus lacustris | 44745 | Plants | Plants | 71.6 | 1.39e-12 | NR | KAJ9527271.1 | 44745 | g8580 | i0 | 60 | 3.88059701492537 | 65 | 24 | 97 | 1 | 5 | 199 | 172 | 234 | KAJ9527271.1 hypothetical protein QJQ45_025513 [Haematococcus lacustris] | diamond | 780 | 71.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27598752 | 27598752 | PRJNA564810_S_NODE_2124_length_331_cov_2.721805_g2102_i0 | PRJNA564810 | 2124 | 331 | 2.721805 | 9.00917455 | root | 1 | Root_unresolved | Root_unresolved | 93.2 | 2.1e-19 | NR | BAU61517.1 | 3074 | g2102 | i0 | 69.9 | 18.797583081571 | 73 | 18 | 62.5 | 1 | 330 | 124 | 691 | 763 | BAU61517.1 inorganic pyrophosphatase [Parachlorella kessleri] | diamond | 6222 | 93.6 | 0.995726495726496 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 28546040 | 28546040 | PRJNA564810_S_NODE_687_length_451_cov_14.888601_g665_i0 | PRJNA564810 | 687 | 451 | 14.888601 | 67.14759051 | Chlorophyta | 3041 | Plants | Plants | 80.1 | 5.38e-16 | NR | XP_011396614.1 | 3075 | g665 | i0 | 67.8 | 1.17738359201774 | 59 | 19 | 39.2 | 0 | 449 | 273 | 76 | 134 | XP_011396614.1 60S ribosomal protein L32-1 [Auxenochlorella protothecoides] | diamond | 531 | 80.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 28910645 | 28910645 | PRJNA564810_S_NODE_3148_length_294_cov_1.781659_g3126_i0 | PRJNA564810 | 3148 | 294 | 1.781659 | 5.23807746 | Trebouxia sp. C | 2796353 | Plants | Plants | 123 | 5.94e-31 | NR | KAL3161496.1 | 3373145 | g3126 | i0 | 57.1 | 2 | 98 | 42 | 100 | 0 | 1 | 294 | 227 | 324 | KAL3161496.1 hypothetical protein ABBQ32_010371 [Trebouxia sp. C0010 RCD-2024] | diamond | 588 | 123 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 28942790 | 28942790 | PRJNA564810_S_NODE_4608_length_260_cov_3.517949_g4586_i0 | PRJNA564810 | 4608 | 260 | 3.517949 | 9.1466674 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 51.6 | 3.49e-5 | NR | KAF8062729.1 | 2742167 | g4586 | i0 | 67.9 | 0.969230769230769 | 28 | 9 | 32.3 | 0 | 1 | 84 | 838 | 865 | KAF8062729.1 hypothetical protein HT031_004059 [Scenedesmus sp. PABB004] | diamond | 252 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 29258009 | 29258009 | PRJNA564810_S_NODE_2789_length_305_cov_1.895833_g2767_i0 | PRJNA564810 | 2789 | 305 | 1.895833 | 5.78229065 | Prototheca wickerhamii | 3111 | Plants | Plants | 76.3 | 1.39e-14 | NR | KAK2076667.1 | 3111 | g2767 | i0 | 59 | 1.78032786885246 | 61 | 25 | 60 | 0 | 303 | 121 | 124 | 184 | KAK2076667.1 hypothetical protein QBZ16_005427 [Prototheca wickerhamii] | diamond | 543 | 76.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29605226 | 29605226 | PRJNA564810_S_NODE_2290_length_324_cov_1.312741_g2268_i0 | PRJNA564810 | 2290 | 324 | 1.312741 | 4.25328084 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 87.4 | 2.29e-19 | NR | BDA43119.1 | 2315456 | g2268 | i0 | 44.9 | 1.64814814814815 | 89 | 49 | 82.4 | 0 | 322 | 56 | 40 | 128 | BDA43119.1 Transcription initiation factor TFIID subunit 13 [Coccomyxa sp. Obi] | diamond | 534 | 87.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 30061258 | 30061258 | PRJNA564810_S_NODE_991_length_405_cov_3.741176_g969_i0 | PRJNA564810 | 991 | 405 | 3.741176 | 15.1517628 | Trebouxia | 13786 | Plants | Plants | 90.5 | 1.17e-18 | NR | KAA6426741.1 | 2608996 | g969 | i0 | 59.3 | 2.54814814814815 | 86 | 33 | 62.2 | 2 | 5 | 256 | 108 | 193 | KAA6426741.1 MAG: Aquaporin NIP1-2 [Trebouxia sp. A1-2] | diamond | 1032 | 90.9 | 0.995599559955996 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 30237317 | 30237317 | PRJNA564810_S_NODE_2172_length_329_cov_2.155303_g2150_i0 | PRJNA564810 | 2172 | 329 | 2.155303 | 7.09094687 | Chlamydomonas incerta | 51695 | Plants | Plants | 51.6 | 7.71e-5 | NR | KAG2443497.1 | 51695 | g2150 | i0 | 61.9 | 0.756838905775076 | 42 | 16 | 38.3 | 0 | 3 | 128 | 600 | 641 | KAG2443497.1 hypothetical protein HXX76_001850 [Chlamydomonas incerta] | diamond | 249 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 30332543 | 30332543 | PRJNA564810_S_NODE_1172_length_387_cov_7.686335_g1150_i0 | PRJNA564810 | 1172 | 387 | 7.686335 | 29.74611645 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 85.9 | 2.66e-18 | NR | KAG2453719.1 | 2026947 | g1150 | i0 | 70.2 | 1.75968992248062 | 57 | 16 | 43.4 | 1 | 385 | 218 | 100 | 156 | KAG2453719.1 hypothetical protein HYH02_001931 [Chlamydomonas schloesseri] | diamond | 681 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 30377778 | 30377778 | PRJNA564810_S_NODE_1392_length_369_cov_8.197368_g1370_i0 | PRJNA564810 | 1392 | 369 | 8.197368 | 30.24828792 | Chlorophyta | 3041 | Plants | Plants | 56.2 | 8.86e-7 | NR | KAK9815843.1 | 41462 | g1370 | i0 | 51 | 1.69105691056911 | 51 | 25 | 41.5 | 0 | 2 | 154 | 127 | 177 | KAK9815843.1 hypothetical protein WJX72_010618 [[Myrmecia] bisecta] | diamond | 624 | 56.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30774574 | 30774574 | PRJNA564810_S_NODE_2654_length_310_cov_1.889796_g2632_i0 | PRJNA564810 | 2654 | 310 | 1.889796 | 5.8583676 | Chlamydomonas incerta | 51695 | Plants | Plants | 97.8 | 1.88e-21 | NR | KAG2435827.1 | 51695 | g2632 | i0 | 56.2 | 2.11935483870968 | 73 | 32 | 70.6 | 0 | 279 | 61 | 326 | 398 | KAG2435827.1 hypothetical protein HXX76_007022 [Chlamydomonas incerta] | diamond | 657 | 97.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 31420244 | 31420244 | PRJNA564810_S_NODE_8236_length_208_cov_2.370629_g8214_i0 | PRJNA564810 | 8236 | 208 | 2.370629 | 4.93090832 | Trebouxiophyceae | 75966 | Plants | Plants | 108 | 2.8e-28 | NR | KAK9789411.1 | 706552 | g8214 | i0 | 74.6 | 1.93269230769231 | 67 | 17 | 96.6 | 0 | 202 | 2 | 93 | 159 | KAK9789411.1 hypothetical protein WJX73_010454 [Symbiochloris irregularis] | diamond | 402 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 32829025 | 32829025 | PRJNA564810_S_NODE_3640_length_281_cov_2.078704_g3618_i0 | PRJNA564810 | 3640 | 281 | 2.078704 | 5.84115824 | Chlorella vulgaris | 3077 | Plants | Plants | 87 | 1.22e-18 | NR | KAI3435619.1 | 3077 | g3618 | i0 | 40.5 | 0.896797153024911 | 84 | 50 | 89.7 | 0 | 5 | 256 | 139 | 222 | KAI3435619.1 hypothetical protein D9Q98_001679 [Chlorella vulgaris] | diamond | 252 | 87 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;