contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24537941 | 24537941 | PRJNA1164198_P_NODE_3780_length_648_cov_1.213913_g3535_i0 | PRJNA1164198 | 3780 | 648 | 1.213913 | 7.86615624 | Eukaryota | 2759 | Plants | Plants | 282 | 9.51e-85 | NR | PSC75377.1 | 554055 | g3535 | i0 | 64.6 | 12.3796296296296 | 212 | 69 | 96.8 | 4 | 18 | 644 | 824 | 1032 | PSC75377.1 eukaryotic translation elongation factor 1 alpha 2 [Micractinium conductrix] | diamond | 8022 | 282 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 26679669 | 26679669 | PRJNA1164198_P_NODE_20241_length_275_cov_2.950495_g19972_i0 | PRJNA1164198 | 20241 | 275 | 2.950495 | 8.11386125 | Chlamydomonadales | 3042 | Plants | Plants | 86.3 | 3.57e-18 | NR | KAG2482049.1 | 47281 | g19972 | i0 | 50 | 3.91636363636364 | 90 | 43 | 97.1 | 2 | 274 | 8 | 1 | 89 | KAG2482049.1 hypothetical protein HYH03_018999 [Edaphochlamys debaryana] | diamond | 1077 | 86.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 26692168 | 26692168 | PRJNA1164198_P_NODE_31741_length_228_cov_2.012903_g31472_i0 | PRJNA1164198 | 31741 | 228 | 2.012903 | 4.5894188400000004 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 132 | 8.32e-38 | NR | XP_005645730.1 | 574566 | g31472 | i0 | 81.3 | 20.7236842105263 | 75 | 14 | 98.7 | 0 | 227 | 3 | 20 | 94 | XP_005645730.1 ribosomal protein S1 [Coccomyxa subellipsoidea C-169] | diamond | 4725 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27154101 | 27154101 | PRJNA1164198_P_NODE_10362_length_386_cov_2.498403_g10094_i0 | PRJNA1164198 | 10362 | 386 | 2.498403 | 9.64383558 | Trebouxiophyceae | 75966 | Plants | Plants | 157 | 5.2e-45 | NR | PRW39386.1 | 3076 | g10094 | i0 | 58.2 | 15.1165803108808 | 122 | 51 | 94.8 | 0 | 366 | 1 | 7 | 128 | PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana] | diamond | 5835 | 158 | 0.993670886075949 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27514442 | 27514442 | PRJNA1164198_P_NODE_24303_length_253_cov_0.866667_g24034_i0 | PRJNA1164198 | 24303 | 253 | 0.866667 | 2.19266751 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 89.7 | 4.76e-20 | NR | GAX75726.1 | 1157962 | g24034 | i0 | 56.9 | 0.853754940711462 | 72 | 31 | 85.4 | 0 | 253 | 38 | 121 | 192 | GAX75726.1 hypothetical protein CEUSTIGMA_g3169.t1 [Chlamydomonas eustigma] | diamond | 216 | 89.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27830133 | 27830133 | PRJNA1164198_P_NODE_20124_length_276_cov_2.009852_g19855_i0 | PRJNA1164198 | 20124 | 276 | 2.009852 | 5.54719152 | Chlamydomonas sp. HS-5 | 108458 | Plants | Plants | 101 | 1.55e-25 | NR | BAA78583.1 | 108458 | g19855 | i0 | 63.3 | 1.67391304347826 | 79 | 29 | 85.9 | 0 | 237 | 1 | 7 | 85 | BAA78583.1 60S ribosomal protein L31 [Chlamydomonas sp. HS-5] | diamond | 462 | 101 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. HS-5 | |
| 27924880 | 27924880 | PRJNA1164198_P_NODE_21605_length_267_cov_2.082474_g21336_i0 | PRJNA1164198 | 21605 | 267 | 2.082474 | 5.56020558 | Polytomella parva | 51329 | Plants | Plants | 132 | 4.86e-35 | NR | QKY14960.1 | 51329 | g21336 | i0 | 73.9 | 0.98876404494382 | 88 | 23 | 98.9 | 0 | 3 | 266 | 236 | 323 | QKY14960.1 pyruvate dehydrogenase E1 component subunit alpha - subunit beta (PDh-E1 BETA) [Polytomella parva] | diamond | 264 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 28240455 | 28240455 | PRJNA1164198_P_NODE_31066_length_242_cov_0.923077_g30797_i0 | PRJNA1164198 | 31066 | 242 | 0.923077 | 2.23384634 | Gonium pectorale | 33097 | Plants | Plants | 90.5 | 2.04e-20 | NR | KXZ45155.1 | 33097 | g30797 | i0 | 56.6 | 1.02892561983471 | 83 | 33 | 99.2 | 1 | 2 | 241 | 53 | 135 | KXZ45155.1 hypothetical protein GPECTOR_58g604 [Gonium pectorale] | diamond | 249 | 90.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 29566637 | 29566637 | PRJNA1164198_P_NODE_24330_length_253_cov_0.866667_g24061_i0 | PRJNA1164198 | 24330 | 253 | 0.866667 | 2.19266751 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 84.7 | 6.92e-17 | NR | KAL4539999.1 | 1650286 | g24061 | i0 | 51.2 | 1.99209486166008 | 84 | 40 | 99.6 | 1 | 252 | 1 | 130 | 212 | KAL4539999.1 hypothetical protein Ndes2526A_g03002 [Chlorella desiccata (nom. nud.)] | diamond | 504 | 84.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30723132 | 30723132 | PRJNA1164198_P_NODE_21134_length_270_cov_1.583756_g20865_i0 | PRJNA1164198 | 21134 | 270 | 1.583756 | 4.2761412 | Eukaryota | 2759 | Plants | Plants | 133 | 1.7999999999999998e-36 | NR | KAJ9522600.1 | 44745 | g20865 | i0 | 64 | 53.3555555555556 | 89 | 32 | 98.9 | 0 | 269 | 3 | 97 | 185 | KAJ9522600.1 hypothetical protein QJQ45_019660 [Haematococcus lacustris] | diamond | 14406 | 133 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31083131 | 31083131 | PRJNA1164198_P_NODE_30455_length_243_cov_0.917647_g30186_i0 | PRJNA1164198 | 30455 | 243 | 0.917647 | 2.22988221 | Micractinium conductrix | 554055 | Plants | Plants | 74.7 | 2.02e-13 | NR | PSC74434.1 | 554055 | g30186 | i0 | 44.3 | 2.92592592592593 | 79 | 44 | 97.5 | 0 | 239 | 3 | 15 | 93 | PSC74434.1 translation factor SUI1-like protein [Micractinium conductrix] | diamond | 711 | 74.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix |
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);;