contig_metadata
14 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8213096 | 8213096 | PRJNA575566_P_NODE_17667_length_251_cov_1.010526_g17470_i0 | PRJNA575566 | 17667 | 251 | 1.010526 | 2.53642026 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 215 | 2.74e-51 | NTclustered | gi|635557420|emb|FN984965.1| | 37502 | g17470 | i0 | 82.213 | 29.8924302788845 | 253 | 41 | 100 | 4 | 1 | 251 | 1325 | 1075 | Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene) | blastn | 7503 | 215 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 11340014 | 11340014 | PRJNA575566_P_NODE_26569_length_206_cov_0.882759_g26372_i0 | PRJNA575566 | 26569 | 206 | 0.882759 | 1.81848354 | Eukaryota | 2759 | Plants | Plants | 381 | 2.0199999999999994e-101 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g26372 | i0 | 100 | 99.6019417475728 | 206 | 0 | 100 | 0 | 1 | 206 | 771 | 566 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 20518 | 381 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 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 | |
| 15862813 | 15862813 | PRJNA575566_P_NODE_27253_length_205_cov_0.888889_g27056_i0 | PRJNA575566 | 27253 | 205 | 0.888889 | 1.82222245 | Chlamydomonas sp. ICE-L | 309537 | Plants | Plants | 135 | 1.7300000000000003e-27 | NTclustered | gi|1433048021|gb|MF780877.1| | 309537 | g27056 | i0 | 79 | 85.0048780487805 | 200 | 40 | 97 | 2 | 1 | 199 | 1107 | 1305 | Chlamydomonas sp. ICE-L heat shock protein 70A (HSP70A) mRNA, partial cds | blastn | 17426 | 135 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. ICE-L | |
| 19686433 | 19686433 | PRJNA575566_P_NODE_13736_length_284_cov_1.062780_g13539_i0 | PRJNA575566 | 13736 | 284 | 1.06278 | 3.0182952 | Dicloster acuatus | 91190 | Plants | Plants | 172 | 1.93e-38 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g13539 | i0 | 80.717 | 52.9014084507042 | 223 | 41 | 78 | 2 | 57 | 278 | 41874 | 41653 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 15024 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 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 | |
| 24786406 | 24786406 | PRJNA575566_P_NODE_4320_length_503_cov_2.000000_g4123_i0 | PRJNA575566 | 4320 | 503 | 2 | 10.06 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 366 | 1.5499999999999995e-96 | NTclustered | gi|224593220|gb|FJ715708.1| | 3055 | g4123 | i0 | 83.212 | 40.7574552683897 | 411 | 57 | 81 | 9 | 44 | 448 | 6 | 410 | Chlamydomonas reinhardtii strain CC1690 translation elongation factor-like protein mRNA, partial cds | blastn | 20501 | 366 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 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);;