contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27641325 | 27641325 | PRJNA1195551_S_NODE_23684_length_207_cov_2.601266_g23331_i0 | PRJNA1195551 | 23684 | 207 | 2.601266 | 5.38462062 | Symbiochloris irregularis | 706552 | Plants | Plants | 41.2 | 0.048 | NR | KAK9812212.1 | 706552 | g23331 | i0 | 45.2 | 0.608695652173913 | 42 | 23 | 60.9 | 0 | 161 | 36 | 91 | 132 | KAK9812212.1 hypothetical protein WJX73_004385 [Symbiochloris irregularis] | diamond | 126 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 27799166 | 27799166 | PRJNA1195551_S_NODE_26664_length_196_cov_1.414966_g26311_i0 | PRJNA1195551 | 26664 | 196 | 1.414966 | 2.77333336 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 44.3 | 0.00563 | NR | KAF8057726.1 | 2742167 | g26311 | i0 | 56.8 | 0.566326530612245 | 37 | 14 | 53.6 | 1 | 174 | 70 | 257 | 293 | KAF8057726.1 NAP1 [Scenedesmus sp. PABB004] | diamond | 111 | 44.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 27893596 | 27893596 | PRJNA1195551_S_NODE_36685_length_169_cov_0.866667_g36332_i0 | PRJNA1195551 | 36685 | 169 | 0.866667 | 1.46466723 | Coccomyxa viridis | 1274662 | Plants | Plants | 41.2 | 0.0482 | NR | CAL5222282.1 | 1274662 | g36332 | i0 | 70 | 0.355029585798817 | 20 | 6 | 35.5 | 0 | 3 | 62 | 4065 | 4084 | CAL5222282.1 g4621 [Coccomyxa viridis] | diamond | 60 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 28177636 | 28177636 | PRJNA1195551_S_NODE_9106_length_305_cov_2.843750_g8753_i0 | PRJNA1195551 | 9106 | 305 | 2.84375 | 8.6734375 | Monoraphidium neglectum | 145388 | Plants | Plants | 70.5 | 5.67e-12 | NR | XP_013900720.1 | 145388 | g8753 | i0 | 66 | 0.924590163934426 | 47 | 16 | 46.2 | 0 | 303 | 163 | 217 | 263 | XP_013900720.1 PsbP domain-containing protein 6 [Monoraphidium neglectum] | diamond | 282 | 70.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 29018090 | 29018090 | PRJNA1195551_S_NODE_29788_length_186_cov_1.138686_g29435_i0 | PRJNA1195551 | 29788 | 186 | 1.138686 | 2.11795596 | Coccomyxa | 41891 | Plants | Plants | 54.7 | 1.17e-7 | NR | CAL8469249.1 | 1965095 | g29435 | i0 | 56.3 | 1.54838709677419 | 48 | 21 | 77.4 | 0 | 185 | 42 | 61 | 108 | CAL8469249.1 g8790 [Coccomyxa elongata] | diamond | 288 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 29175815 | 29175815 | PRJNA1195551_S_NODE_12069_length_275_cov_3.681416_g11716_i0 | PRJNA1195551 | 12069 | 275 | 3.681416 | 10.123894 | Chlorellaceae | 35461 | Plants | Plants | 91.3 | 4.06e-19 | NR | PRW57126.1 | 3076 | g11716 | i0 | 85.4 | 5.71636363636364 | 48 | 7 | 52.4 | 0 | 273 | 130 | 441 | 488 | PRW57126.1 Photosystem II 10 kDa chloroplastic [Chlorella sorokiniana] | diamond | 1572 | 91.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30514774 | 30514774 | PRJNA1195551_S_NODE_19953_length_224_cov_1.188571_g19600_i0 | PRJNA1195551 | 19953 | 224 | 1.188571 | 2.66239904 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 74.3 | 2.1e-13 | NR | KAL4458929.1 | 2728915 | g19600 | i0 | 50 | 0.883928571428571 | 66 | 33 | 88.4 | 0 | 224 | 27 | 423 | 488 | KAL4458929.1 hypothetical protein ABPG75_013794 [Micractinium tetrahymenae] | diamond | 198 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 30672634 | 30672634 | PRJNA1195551_S_NODE_27153_length_194_cov_2.593103_g26800_i0 | PRJNA1195551 | 27153 | 194 | 2.593103 | 5.03061982 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 47.4 | 2.61e-4 | NR | GFR53048.1 | 47775 | g26800 | i0 | 71.4 | 0.43298969072165 | 28 | 8 | 43.3 | 0 | 179 | 96 | 150 | 177 | GFR53048.1 hypothetical protein Agub_g15749 [Astrephomene gubernaculifera] | diamond | 84 | 47.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 31178015 | 31178015 | PRJNA1195551_S_NODE_22795_length_211_cov_1.604938_g22442_i0 | PRJNA1195551 | 22795 | 211 | 1.604938 | 3.38641918 | [Myrmecia] bisecta | 41462 | Plants | Plants | 85.9 | 3.69e-19 | NR | KAK9815510.1 | 41462 | g22442 | i0 | 70.2 | 0.81042654028436 | 57 | 17 | 81 | 0 | 1 | 171 | 107 | 163 | KAK9815510.1 hypothetical protein WJX72_004886 [[Myrmecia] bisecta] | diamond | 171 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 31779107 | 31779107 | PRJNA1195551_S_NODE_16337_length_244_cov_2.400000_g15984_i0 | PRJNA1195551 | 16337 | 244 | 2.4 | 5.856 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 55.8 | 2.12e-7 | NR | CAG9461740.1 | 765719 | g15984 | i0 | 60.4 | 1.79508196721311 | 48 | 19 | 59 | 0 | 242 | 99 | 106 | 153 | CAG9461740.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 438 | 55.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31893052 | 31893052 | PRJNA1195551_S_NODE_7537_length_327_cov_3.348921_g7184_i0 | PRJNA1195551 | 7537 | 327 | 3.348921 | 10.95097167 | Volvocaceae | 3065 | Plants | Plants | 42 | 0.0343 | NR | KXZ52926.1 | 33097 | g7184 | i0 | 46.2 | 1.28440366972477 | 65 | 28 | 55 | 4 | 327 | 148 | 24 | 86 | KXZ52926.1 hypothetical protein GPECTOR_8g302 [Gonium pectorale] | diamond | 420 | 42 | 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);;