contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3049787 | 3049787 | PRJNA529241_P_NODE_160363_length_181_cov_1.083333_g158041_i0 | PRJNA529241 | 160363 | 181 | 1.083333 | 1.96083273 | Coccomyxa | 41891 | Plants | Plants | 121 | 2.2799999999999998e-32 | NR | XP_005646819.1 | 574566 | g158041 | i0 | 95 | 9.94475138121547 | 60 | 3 | 99.4 | 0 | 180 | 1 | 188 | 247 | XP_005646819.1 ribosomal protein L8 component of cytosolic 80S ribosome and 60S large subunit [Coccomyxa subellipsoidea C-169] | diamond | 1800 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 26902994 | 26902994 | PRJNA529241_P_NODE_366581_length_173_cov_2.698529_g364259_i0 | PRJNA529241 | 366581 | 173 | 2.698529 | 4.66845517 | Eukaryota | 2759 | Plants | Plants | 47.4 | 2.93e-4 | NR | KAK9918745.1 | 248742 | g364259 | i0 | 91.3 | 8.0635838150289 | 23 | 2 | 39.9 | 0 | 100 | 168 | 168 | 190 | KAK9918745.1 hypothetical protein WJX75_006512 [Coccomyxa subellipsoidea] | diamond | 1395 | 47.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27282402 | 27282402 | PRJNA529241_P_NODE_551103_length_151_cov_2.596491_g548781_i0 | PRJNA529241 | 551103 | 151 | 2.596491 | 3.92070141 | Chlorophyceae | 3166 | Plants | Plants | 48.5 | 5.46e-5 | NR | KXZ45106.1 | 33097 | g548781 | i0 | 60 | 1.1523178807947 | 30 | 12 | 59.6 | 0 | 150 | 61 | 71 | 100 | KXZ45106.1 hypothetical protein GPECTOR_58g555 [Gonium pectorale] | diamond | 174 | 48.9 | 0.991820040899796 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 27756294 | 27756294 | PRJNA529241_P_NODE_279964_length_173_cov_3.845588_g277642_i0 | PRJNA529241 | 279964 | 173 | 3.845588 | 6.65286724 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.02 | NR | KAI8469007.1 | 39955 | g277642 | i0 | 66.7 | 1.21387283236994 | 24 | 8 | 41.6 | 0 | 168 | 97 | 206 | 229 | KAI8469007.1 MAG: major facilitator superfamily transporter [Monoraphidium minutum] | diamond | 210 | 42.7 | 0.992974238875878 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 29319452 | 29319452 | PRJNA529241_P_NODE_167209_length_178_cov_1.078014_g164887_i0 | PRJNA529241 | 167209 | 178 | 1.078014 | 1.91886492 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 39.7 | 0.0423 | NR | KAF6261890.1 | 2650976 | g164887 | i0 | 42.9 | 0.471910112359551 | 28 | 16 | 47.2 | 0 | 74 | 157 | 32 | 59 | KAF6261890.1 hypothetical protein COO60DRAFT_1499080 [Scenedesmus sp. NREL 46B-D3] | diamond | 84 | 39.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 30172144 | 30172144 | PRJNA529241_P_NODE_244052_length_173_cov_4.573529_g241730_i0 | PRJNA529241 | 244052 | 173 | 4.573529 | 7.91220517 | Trebouxia sp. C | 2796353 | Plants | Plants | 53.9 | 1.62e-6 | NR | KAL3135587.1 | 3373144 | g241730 | i0 | 60.4 | 2.4971098265896 | 48 | 16 | 83.2 | 1 | 1 | 144 | 88 | 132 | KAL3135587.1 hypothetical protein ABBQ38_006067 [Trebouxia sp. C0009 RCD-2024] | diamond | 432 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 30661371 | 30661371 | PRJNA529241_P_NODE_420153_length_168_cov_1.190840_g417831_i0 | PRJNA529241 | 420153 | 168 | 1.19084 | 2.0006112 | Chlorophyta | 3041 | Plants | Plants | 71.2 | 1.61e-14 | NR | KAF5837181.1 | 3046 | g417831 | i0 | 77.3 | 2.25 | 44 | 10 | 78.6 | 0 | 168 | 37 | 42 | 85 | KAF5837181.1 60S ribosomal protein L38 [Dunaliella salina] | diamond | 378 | 71.6 | 0.994413407821229 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31025437 | 31025437 | PRJNA529241_P_NODE_374755_length_173_cov_2.625000_g372433_i0 | PRJNA529241 | 374755 | 173 | 2.625 | 4.54125 | Chlamydomonas incerta | 51695 | Plants | Plants | 45.8 | 0.00118 | NR | KAG2426295.1 | 51695 | g372433 | i0 | 54.5 | 0.763005780346821 | 44 | 18 | 72.8 | 1 | 171 | 46 | 141 | 184 | KAG2426295.1 hypothetical protein HXX76_013052 [Chlamydomonas incerta] | diamond | 132 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;