contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13314151 | 13314151 | PRJNA575566_P_NODE_28811_length_202_cov_1.361702_g28614_i0 | PRJNA575566 | 28811 | 202 | 1.361702 | 2.75063804 | Chlorophyta | 3041 | Plants | Plants | 97.8 | 4.04e-22 | NR | NP_042252.1 | 3111 | g28614 | i0 | 83 | 17.3168316831683 | 53 | 9 | 78.7 | 0 | 1 | 159 | 348 | 400 | NP_042252.1 NADH dehydrogenase (ubiquinone), subunit 7 [Prototheca wickerhamii] | diamond | 3498 | 97.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 14589052 | 14589052 | PRJNA575566_P_NODE_4432_length_497_cov_1.165138_g4235_i0 | PRJNA575566 | 4432 | 497 | 1.165138 | 5.79073586 | Raphidocelis subcapitata | 307507 | Plants | Plants | 113 | 3.37e-26 | NR | GBF94078.1 | 307507 | g4235 | i0 | 38.9 | 1.73843058350101 | 144 | 88 | 86.9 | 0 | 10 | 441 | 294 | 437 | GBF94078.1 COP9 signalosome complex subunit [Raphidocelis subcapitata] | diamond | 864 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 24786226 | 24786226 | PRJNA575566_P_NODE_20720_length_230_cov_1.218935_g20523_i0 | PRJNA575566 | 20720 | 230 | 1.218935 | 2.8035505 | Scenedesmus | 3087 | Plants | Plants | 127 | 3.83e-35 | NR | KAF6251048.1 | 2650976 | g20523 | i0 | 80.8 | 16.3173913043478 | 73 | 14 | 95.2 | 0 | 11 | 229 | 1 | 73 | KAF6251048.1 ribosomal protein S8 [Scenedesmus sp. NREL 46B-D3] | diamond | 3753 | 128 | 0.9921875 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 27124390 | 27124390 | PRJNA575566_P_NODE_15322_length_269_cov_1.538462_g15125_i0 | PRJNA575566 | 15322 | 269 | 1.538462 | 4.13846278 | Eukaryota | 2759 | Plants | Plants | 98.2 | 3.56e-22 | NR | CAL5218399.1 | 1274662 | g15125 | i0 | 51.6 | 2.02973977695167 | 91 | 42 | 99.3 | 1 | 267 | 1 | 173 | 263 | CAL5218399.1 g74 [Coccomyxa viridis] | diamond | 546 | 99 | 0.991919191919192 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 28247942 | 28247942 | PRJNA575566_P_NODE_27486_length_204_cov_0.895105_g27289_i0 | PRJNA575566 | 27486 | 204 | 0.895105 | 1.8260142 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 87.4 | 3.49e-18 | NR | KAK9916882.1 | 248742 | g27289 | i0 | 60 | 1.02941176470588 | 70 | 25 | 98.5 | 1 | 202 | 2 | 73 | 142 | KAK9916882.1 hypothetical protein WJX75_008277 [Coccomyxa subellipsoidea] | diamond | 210 | 87.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 28532451 | 28532451 | PRJNA575566_P_NODE_29367_length_202_cov_0.907801_g29170_i0 | PRJNA575566 | 29367 | 202 | 0.907801 | 1.83375802 | Chlorella vulgaris | 3077 | Plants | Plants | 48.1 | 2.61e-4 | NR | KAI3428226.1 | 3077 | g29170 | i0 | 46.3 | 0.801980198019802 | 54 | 29 | 80.2 | 0 | 200 | 39 | 136 | 189 | KAI3428226.1 hypothetical protein D9Q98_006606 [Chlorella vulgaris] | diamond | 162 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 29795050 | 29795050 | PRJNA575566_P_NODE_17011_length_256_cov_0.984615_g16814_i0 | PRJNA575566 | 17011 | 256 | 0.984615 | 2.5206144 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 43.5 | 0.0234 | NR | KAA6429529.1 | 2608996 | g16814 | i0 | 36.8 | 1.01953125 | 87 | 51 | 98.4 | 3 | 3 | 254 | 77 | 162 | KAA6429529.1 MAG: cullin-associated NEDD8-dissociated 1-like [Trebouxia sp. A1-2] | diamond | 261 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32039456 | 32039456 | PRJNA575566_P_NODE_21458_length_225_cov_2.268293_g21261_i0 | PRJNA575566 | 21458 | 225 | 2.268293 | 5.10365925 | Chlorella sorokiniana | 3076 | Plants | Plants | 90.1 | 6.13e-19 | NR | PRW51008.1 | 3076 | g21261 | i0 | 63.1 | 4.37333333333333 | 65 | 24 | 86.7 | 0 | 215 | 21 | 978 | 1042 | PRW51008.1 eukaryotic translation elongation factor 1 alpha 2 [Chlorella sorokiniana] | diamond | 984 | 90.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32229461 | 32229461 | PRJNA575566_P_NODE_8178_length_367_cov_1.633987_g7981_i0 | PRJNA575566 | 8178 | 367 | 1.633987 | 5.99673229 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 67 | 2.49e-11 | NR | KAK9904198.1 | 248742 | g7981 | i0 | 40.9 | 0.940054495912807 | 115 | 64 | 93.2 | 2 | 360 | 19 | 2 | 113 | KAK9904198.1 hypothetical protein WJX75_006622 [Coccomyxa subellipsoidea] | diamond | 345 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea |
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);;