contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16175631 | 16175631 | PRJNA896758_P_NODE_3513_length_613_cov_2.694444_g3132_i0 | PRJNA896758 | 3513 | 613 | 2.694444 | 16.51694172 | Chlorophyta | 3041 | Plants | Plants | 248 | 8.85e-74 | NR | PRW32846.1 | 3076 | g3132 | i0 | 74.9 | 28.1500815660685 | 179 | 45 | 87.6 | 0 | 613 | 77 | 2 | 180 | PRW32846.1 60S ribosomal L19-2 isoform A [Chlorella sorokiniana] | diamond | 17256 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27348078 | 27348078 | PRJNA896758_P_NODE_21863_length_250_cov_0.870056_g21473_i0 | PRJNA896758 | 21863 | 250 | 0.870056 | 2.17514 | Coccomyxa | 41891 | Plants | Plants | 57 | 4.01e-7 | NR | CAL8470626.1 | 1965095 | g21473 | i0 | 44.6 | 4.104 | 65 | 36 | 78 | 0 | 201 | 7 | 1735 | 1799 | CAL8470626.1 g10168 [Coccomyxa elongata] | diamond | 1026 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 27498175 | 27498175 | PRJNA896758_P_NODE_12803_length_321_cov_1.862903_g12413_i0 | PRJNA896758 | 12803 | 321 | 1.862903 | 5.97991863 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 45.8 | 0.00297 | NR | KAG7671249.1 | 1650286 | g12413 | i0 | 49.2 | 0.570093457943925 | 61 | 23 | 49.5 | 2 | 320 | 162 | 81 | 141 | KAG7671249.1 hypothetical protein KSW81_003387 [Chlorella desiccata (nom. nud.)] | diamond | 183 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 27529636 | 27529636 | PRJNA896758_P_NODE_9643_length_367_cov_1.897959_g9253_i0 | PRJNA896758 | 9643 | 367 | 1.897959 | 6.96550953 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 51.6 | 9.71e-5 | NR | XP_002957370.1 | 3068 | g9253 | i0 | 41.3 | 1.25068119891008 | 63 | 37 | 51.5 | 0 | 84 | 272 | 40 | 102 | XP_002957370.1 chitinase, lysozyme [Volvox carteri f. nagariensis] | diamond | 459 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 27845218 | 27845218 | PRJNA896758_P_NODE_17564_length_277_cov_0.906863_g17174_i0 | PRJNA896758 | 17564 | 277 | 0.906863 | 2.51201051 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 45.1 | 0.00633 | NR | XP_002948120.1 | 3068 | g17174 | i0 | 43.1 | 0.703971119133574 | 65 | 31 | 70.4 | 1 | 75 | 269 | 130 | 188 | XP_002948120.1 uncharacterized protein VOLCADRAFT_88419 [Volvox carteri f. nagariensis] | diamond | 195 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 28318955 | 28318955 | PRJNA896758_P_NODE_25126_length_244_cov_0.900585_g24736_i0 | PRJNA896758 | 25126 | 244 | 0.900585 | 2.1974274 | [Myrmecia] bisecta | 41462 | Plants | Plants | 45.1 | 0.00569 | NR | KAK9803630.1 | 41462 | g24736 | i0 | 36.8 | 0.700819672131147 | 57 | 36 | 70.1 | 0 | 173 | 3 | 509 | 565 | KAK9803630.1 hypothetical protein WJX72_007017 [[Myrmecia] bisecta] | diamond | 171 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 28540258 | 28540258 | PRJNA896758_P_NODE_14487_length_301_cov_1.877193_g14097_i0 | PRJNA896758 | 14487 | 301 | 1.877193 | 5.65035093 | Monoraphidium minutum | 39955 | Plants | Plants | 42.4 | 0.0296 | NR | KAI8470570.1 | 39955 | g14097 | i0 | 66.7 | 0.32890365448505 | 33 | 10 | 32.9 | 1 | 74 | 172 | 53 | 84 | KAI8470570.1 MAG: hypothetical protein J3K34DRAFT_468978 [Monoraphidium minutum] | diamond | 99 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 29266044 | 29266044 | PRJNA896758_P_NODE_23749_length_246_cov_1.780347_g23359_i0 | PRJNA896758 | 23749 | 246 | 1.780347 | 4.37965362 | [Myrmecia] bisecta | 41462 | Plants | Plants | 45.4 | 0.00447 | NR | KAK9816436.1 | 41462 | g23359 | i0 | 32.1 | 0.98780487804878 | 81 | 50 | 98.8 | 1 | 1 | 243 | 243 | 318 | KAK9816436.1 hypothetical protein WJX72_000212 [[Myrmecia] bisecta] | diamond | 243 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 29707830 | 29707830 | PRJNA896758_P_NODE_26470_length_241_cov_0.916667_g26080_i0 | PRJNA896758 | 26470 | 241 | 0.916667 | 2.20916747 | Volvox africanus | 51714 | Plants | Plants | 52.8 | 8.05e-6 | NR | GLI69515.1 | 51714 | g26080 | i0 | 33.8 | 2.73858921161826 | 74 | 48 | 92.1 | 1 | 228 | 7 | 154 | 226 | GLI69515.1 hypothetical protein VaNZ11_014151 [Volvox africanus] | diamond | 660 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 30505784 | 30505784 | PRJNA896758_P_NODE_23933_length_246_cov_0.890173_g23543_i0 | PRJNA896758 | 23933 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | Plants | Plants | 61.6 | 4.13e-9 | NR | KAF5838424.1 | 3046 | g23543 | i0 | 46.2 | 2.3780487804878 | 65 | 35 | 79.3 | 0 | 52 | 246 | 1 | 65 | KAF5838424.1 ribosomal protein L10-domain-containing protein [Dunaliella salina] | diamond | 585 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 30687502 | 30687502 | PRJNA896758_P_NODE_24753_length_244_cov_1.637427_g24363_i0 | PRJNA896758 | 24753 | 244 | 1.637427 | 3.99532188 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 70.9 | 4.61e-12 | NR | KAL4531732.1 | 1650286 | g24363 | i0 | 39 | 3 | 82 | 48 | 98.4 | 1 | 243 | 4 | 164 | 245 | KAL4531732.1 hypothetical protein Ndes2437A_g09046 [Chlorella desiccata (nom. nud.)] | diamond | 732 | 70.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 31161192 | 31161192 | PRJNA896758_P_NODE_26115_length_242_cov_0.911243_g25725_i0 | PRJNA896758 | 26115 | 242 | 0.911243 | 2.20520806 | Monoraphidium neglectum | 145388 | Plants | Plants | 75.5 | 1.08e-13 | NR | XP_013902452.1 | 145388 | g25725 | i0 | 62.5 | 1.38842975206612 | 56 | 21 | 69.4 | 0 | 238 | 71 | 139 | 194 | XP_013902452.1 leucyl aminopeptidase [Monoraphidium neglectum] | diamond | 336 | 75.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;