contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16989021 | 16989021 | PRJNA395690_P_NODE_18554_length_190_cov_1.241135_g18402_i0 | PRJNA395690 | 18554 | 190 | 1.241135 | 2.3581565 | Eukaryota | 2759 | Plants | Plants | 90.9 | 9.36e-21 | NR | KAK9817689.1 | 41462 | g18402 | i0 | 70.5 | 2.92105263157895 | 61 | 18 | 96.3 | 0 | 8 | 190 | 139 | 199 | KAK9817689.1 hypothetical protein WJX72_000657 [[Myrmecia] bisecta] | diamond | 555 | 90.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 26854086 | 26854086 | PRJNA395690_P_NODE_30661_length_165_cov_1.318966_g30509_i0 | PRJNA395690 | 30661 | 165 | 1.318966 | 2.1762939 | Chlorella sorokiniana | 3076 | Plants | Plants | 67 | 6.16e-12 | NR | PRW57226.1 | 3076 | g30509 | i0 | 57.4 | 12.7454545454545 | 54 | 23 | 98.2 | 0 | 162 | 1 | 67 | 120 | PRW57226.1 60S ribosomal L18a-2 [Chlorella sorokiniana] | diamond | 2103 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27043716 | 27043716 | PRJNA395690_P_NODE_17502_length_194_cov_1.055172_g17350_i0 | PRJNA395690 | 17502 | 194 | 1.055172 | 2.04703368 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 98.2 | 2.51e-23 | NR | KDD75837.1 | 1291522 | g17350 | i0 | 70.3 | 1.97938144329897 | 64 | 19 | 99 | 0 | 2 | 193 | 90 | 153 | KDD75837.1 hypothetical protein H632_c477p1 [Helicosporidium sp. ATCC 50920] | diamond | 384 | 98.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 27486168 | 27486168 | PRJNA395690_P_NODE_24103_length_177_cov_1.195312_g23951_i0 | PRJNA395690 | 24103 | 177 | 1.195312 | 2.11570224 | Chlorochytrium lemnae | 1199099 | Plants | Plants | 76.6 | 3.14e-16 | NR | CCI69515.1 | 1199099 | g23951 | i0 | 67.2 | 2.94915254237288 | 58 | 19 | 98.3 | 0 | 175 | 2 | 50 | 107 | CCI69515.1 40S ribosomal protein S9, partial [Chlorochytrium lemnae] | diamond | 522 | 76.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorochytriaceae | Chlorochytrium | Chlorochytrium lemnae | |
| 29096518 | 29096518 | PRJNA395690_P_NODE_13328_length_223_cov_1.465517_g13176_i0 | PRJNA395690 | 13328 | 223 | 1.465517 | 3.26810291 | Haematococcus lacustris | 44745 | Plants | Plants | 63.2 | 1.84e-9 | NR | KAJ9532970.1 | 44745 | g13176 | i0 | 51.9 | 2.04484304932735 | 79 | 31 | 98.2 | 3 | 1 | 219 | 133 | 210 | KAJ9532970.1 hypothetical protein QJQ45_018059, partial [Haematococcus lacustris] | diamond | 456 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29397345 | 29397345 | PRJNA395690_P_NODE_32349_length_164_cov_0.886957_g32197_i0 | PRJNA395690 | 32349 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | Plants | Plants | 42.7 | 0.0131 | NR | XP_042924905.1 | 3055 | g32197 | i0 | 46.3 | 7.15243902439024 | 41 | 20 | 71.3 | 1 | 146 | 30 | 595 | 635 | XP_042924905.1 uncharacterized protein CHLRE_05g239450v5 [Chlamydomonas reinhardtii] | diamond | 1173 | 43.1 | 0.990719257540603 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 30865175 | 30865175 | PRJNA395690_P_NODE_3194_length_440_cov_1.414322_g3045_i0 | PRJNA395690 | 3194 | 440 | 1.414322 | 6.2230168 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 45.1 | 0.042 | NR | KAG1662144.1 | 1653778 | g3045 | i0 | 30.8 | 0.531818181818182 | 78 | 45 | 47 | 2 | 95 | 301 | 368 | 445 | KAG1662144.1 hypothetical protein FOA52_011017 [Chlamydomonas sp. UWO 241] | diamond | 234 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 31529218 | 31529218 | PRJNA395690_P_NODE_17836_length_192_cov_1.916084_g17684_i0 | PRJNA395690 | 17836 | 192 | 1.916084 | 3.67888128 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 90.5 | 2.83e-19 | NR | GAX84909.1 | 1157962 | g17684 | i0 | 60.3 | 3.9375 | 63 | 25 | 98.4 | 0 | 191 | 3 | 3824 | 3886 | GAX84909.1 hypothetical protein CEUSTIGMA_g12330.t1 [Chlamydomonas eustigma] | diamond | 756 | 90.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 31560914 | 31560914 | PRJNA395690_P_NODE_24156_length_176_cov_3.716535_g24004_i0 | PRJNA395690 | 24156 | 176 | 3.716535 | 6.5411016 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 46.2 | 9.15e-4 | NR | KAF8072570.1 | 2742167 | g24004 | i0 | 54.3 | 0.596590909090909 | 35 | 16 | 59.7 | 0 | 4 | 108 | 1125 | 1159 | KAF8072570.1 hypothetical protein HT031_000230 [Scenedesmus sp. PABB004] | diamond | 105 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 |
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);;