contig_metadata
19 rows where bioproject = "PRJNA682774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174713 | 1174713 | PRJNA682774_P_NODE_801_length_479_cov_2.229064_g772_i0 | PRJNA682774 | 801 | 479 | 2.229064 | 10.67721656 | Bryopsis | 3128 | Plants | Plants | 468 | 3.91e-127 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g772 | i0 | 84.914 | 98.8496868475992 | 464 | 68 | 97 | 2 | 17 | 479 | 617 | 155 | Bryopsis maxima actin gene, partial cds | blastn | 47349 | 468 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 3215416 | 3215416 | PRJNA682774_P_NODE_1003_length_432_cov_1.086351_g974_i0 | PRJNA682774 | 1003 | 432 | 1.086351 | 4.69303632 | Eukaryota | 2759 | Plants | Plants | 151 | 2.74e-43 | NR | KAG2491764.1 | 47281 | g974 | i0 | 66.4 | 8.29861111111111 | 119 | 39 | 82.6 | 1 | 2 | 358 | 75 | 192 | KAG2491764.1 hypothetical protein HYH03_009925 [Edaphochlamys debaryana] | diamond | 3585 | 152 | 0.993421052631579 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 8317787 | 8317787 | PRJNA682774_P_NODE_1767_length_335_cov_2.381679_g1738_i0 | PRJNA682774 | 1767 | 335 | 2.381679 | 7.97862465 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 82.4 | 1.33e-15 | NR | KAF8054880.1 | 2742167 | g1738 | i0 | 51.9 | 1.86268656716418 | 104 | 47 | 93.1 | 2 | 24 | 335 | 1 | 101 | KAF8054880.1 ARSA1 [Scenedesmus sp. PABB004] | diamond | 624 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 8317817 | 8317817 | PRJNA682774_P_NODE_4227_length_248_cov_2.142857_g4198_i0 | PRJNA682774 | 4227 | 248 | 2.142857 | 5.31428536 | Chlamydomonadales | 3042 | Plants | Plants | 148 | 3.41e-39 | NR | XP_001691785.2 | 3055 | g4198 | i0 | 84.1 | 8.89112903225806 | 82 | 13 | 99.2 | 0 | 247 | 2 | 235 | 316 | XP_001691785.2 uncharacterized protein CHLRE_17g699100v5 [Chlamydomonas reinhardtii] | diamond | 2205 | 149 | 0.993288590604027 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10868624 | 10868624 | PRJNA682774_P_NODE_1389_length_370_cov_1.575758_g1360_i0 | PRJNA682774 | 1389 | 370 | 1.575758 | 5.8303046 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 355 | 2.39e-93 | NTclustered | gi|5738230|gb|AF175385.1|AF175385 | 3055 | g1360 | i0 | 85.07 | 77.7594594594595 | 355 | 46 | 95 | 6 | 15 | 367 | 57 | 406 | Chlamydomonas reinhardtii 60S ribosomal protein L10a mRNA, complete cds | blastn | 28771 | 355 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17752547 | 17752547 | PRJNA682774_P_NODE_4354_length_248_cov_0.891429_g4325_i0 | PRJNA682774 | 4354 | 248 | 0.891429 | 2.21074392 | Eukaryota | 2759 | Plants | Plants | 457 | 4.07e-124 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g4325 | i0 | 100 | 99.9354838709677 | 247 | 0 | 99 | 0 | 2 | 248 | 769 | 523 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 24784 | 457 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23617541 | 23617541 | PRJNA682774_P_NODE_3359_length_254_cov_2.585635_g3330_i0 | PRJNA682774 | 3359 | 254 | 2.585635 | 6.5675129 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 217 | 7.73e-52 | NTclustered | gi|545374848|ref|XM_005651606.1| | 574566 | g3330 | i0 | 84.475 | 34.988188976378 | 219 | 34 | 86 | 0 | 4 | 222 | 271 | 53 | Coccomyxa subellipsoidea C-169 ribosomal protein S26 component of cytosolic 80S ribosome and 40S small subunit mRNA | blastn | 8887 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24126671 | 24126671 | PRJNA682774_P_NODE_1339_length_377_cov_0.921053_g1310_i0 | PRJNA682774 | 1339 | 377 | 0.921053 | 3.47236981 | Chlamydomonadales | 3042 | Plants | Plants | 140 | 1.22e-39 | NR | KAF5836517.1 | 3046 | g1310 | i0 | 80.2 | 3.68435013262599 | 116 | 23 | 92.3 | 0 | 30 | 377 | 1 | 116 | KAF5836517.1 ribosomal protein S27a component of cytosolic 80S ribosome and 40S small subunit [Dunaliella salina] | diamond | 1389 | 140 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 24890790 | 24890790 | PRJNA682774_P_NODE_2640_length_284_cov_0.957346_g2611_i0 | PRJNA682774 | 2640 | 284 | 0.957346 | 2.71886264 | Monoraphidium neglectum | 145388 | Plants | Plants | 267 | 8.599999999999999e-67 | NTclustered | gi|926766867|ref|XM_014037032.1| | 145388 | g2611 | i0 | 86.92 | 81.5387323943662 | 237 | 31 | 83 | 0 | 2 | 238 | 237 | 1 | Monoraphidium neglectum Tubulin alpha-1 chain mRNA | blastn | 23157 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 27303530 | 27303530 | PRJNA682774_P_NODE_4723_length_246_cov_0.901734_g4694_i0 | PRJNA682774 | 4723 | 246 | 0.901734 | 2.21826564 | Trebouxia sp. C | 2796353 | Plants | Plants | 55.5 | 1.29e-6 | NR | KAL0048818.1 | 2905655 | g4694 | i0 | 35.7 | 2.5609756097561 | 70 | 45 | 85.4 | 0 | 211 | 2 | 1719 | 1788 | KAL0048818.1 hypothetical protein WJX82_011724 [Trebouxia sp. C0006] | diamond | 630 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 27315185 | 27315185 | PRJNA682774_P_NODE_3963_length_250_cov_0.881356_g3934_i0 | PRJNA682774 | 3963 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | Plants | Plants | 52.4 | 1.66e-5 | NR | KAK9908934.1 | 248742 | g3934 | i0 | 40.5 | 2.964 | 74 | 32 | 88.8 | 1 | 234 | 13 | 314 | 375 | KAK9908934.1 hypothetical protein WJX75_004938 [Coccomyxa subellipsoidea] | diamond | 741 | 52.8 | 0.992424242424242 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27694299 | 27694299 | PRJNA682774_P_NODE_4804_length_245_cov_0.906977_g4775_i0 | PRJNA682774 | 4804 | 245 | 0.906977 | 2.22209365 | Chlamydomonadales | 3042 | Plants | Plants | 110 | 1.63e-29 | NR | XP_042927436.1 | 3055 | g4775 | i0 | 88.7 | 2.27755102040816 | 62 | 7 | 75.9 | 0 | 189 | 4 | 1 | 62 | XP_042927436.1 uncharacterized protein CHLRE_02g105950v5 [Chlamydomonas reinhardtii] | diamond | 558 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 28136200 | 28136200 | PRJNA682774_P_NODE_245_length_872_cov_8.782228_g220_i0 | PRJNA682774 | 245 | 872 | 8.782228 | 76.58102816 | Chlamydomonas | 3052 | Plants | Plants | 58.2 | 1.48e-5 | NR | KAG2423999.1 | 51695 | g220 | i0 | 39.2 | 1.32110091743119 | 125 | 62 | 42.3 | 5 | 818 | 450 | 6 | 118 | KAG2423999.1 hypothetical protein HXX76_014825 [Chlamydomonas incerta] | diamond | 1152 | 58.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 30113650 | 30113650 | PRJNA682774_P_NODE_3332_length_255_cov_1.714286_g3303_i0 | PRJNA682774 | 3332 | 255 | 1.714286 | 4.3714293 | Chlorella sorokiniana | 3076 | Plants | Plants | 128 | 1.01e-33 | NR | PRW33552.1 | 3076 | g3303 | i0 | 67.8 | 2.05882352941176 | 90 | 23 | 98.8 | 1 | 255 | 4 | 226 | 315 | PRW33552.1 Fructose-1,6- cytosolic [Chlorella sorokiniana] | diamond | 525 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30156711 | 30156711 | PRJNA682774_P_NODE_4712_length_246_cov_0.901734_g4683_i0 | PRJNA682774 | 4712 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.2e-5 | NR | KAI3437560.1 | 3077 | g4683 | i0 | 37 | 5.5609756097561 | 81 | 46 | 96.3 | 3 | 237 | 1 | 609 | 686 | KAI3437560.1 hypothetical protein D9Q98_000013 [Chlorella vulgaris] | diamond | 1368 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 31472774 | 31472774 | PRJNA682774_P_NODE_3856_length_251_cov_0.876404_g3827_i0 | PRJNA682774 | 3856 | 251 | 0.876404 | 2.19977404 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 125 | 5.05e-32 | NR | KAF8063068.1 | 2742167 | g3827 | i0 | 73.5 | 1.9840637450199201 | 83 | 22 | 99.2 | 0 | 2 | 250 | 327 | 409 | KAF8063068.1 hslO [Scenedesmus sp. PABB004] | diamond | 498 | 125 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 31705658 | 31705658 | PRJNA682774_P_NODE_5517_length_235_cov_3.080247_g5488_i0 | PRJNA682774 | 5517 | 235 | 3.080247 | 7.23858045 | Chlamydomonadales | 3042 | Plants | Plants | 105 | 3.0400000000000004e-27 | NR | GIL66009.1 | 51714 | g5488 | i0 | 78.5 | 1.6595744680851101 | 65 | 14 | 83 | 0 | 39 | 233 | 1 | 65 | GIL66009.1 hypothetical protein Vafri_19640, partial [Volvox africanus] | diamond | 390 | 106 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 32831737 | 32831737 | PRJNA682774_P_NODE_2080_length_313_cov_0.829167_g2051_i0 | PRJNA682774 | 2080 | 313 | 0.829167 | 2.59529271 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 87.4 | 1.79e-17 | NR | KAF8054880.1 | 2742167 | g2051 | i0 | 54 | 4.62939297124601 | 100 | 43 | 95.8 | 2 | 13 | 312 | 1 | 97 | KAF8054880.1 ARSA1 [Scenedesmus sp. PABB004] | diamond | 1449 | 87.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 32906228 | 32906228 | PRJNA682774_P_NODE_5240_length_243_cov_0.917647_g5211_i0 | PRJNA682774 | 5240 | 243 | 0.917647 | 2.22988221 | Chlamydomonadales | 3042 | Plants | Plants | 67 | 1.04e-10 | NR | KXZ41737.1 | 33097 | g5211 | i0 | 64 | 4.69135802469136 | 50 | 18 | 61.7 | 0 | 241 | 92 | 536 | 585 | KXZ41737.1 BBS9 protein [Gonium pectorale] | diamond | 1140 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;