contig_metadata
5 rows where analysis = "diamond", tax_clade = "Provora" and tax_phylum = "Nebulidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16757566 | 16757566 | PRJNA1067370_P_NODE_15474_length_470_cov_2.100756_g14926_i0 | PRJNA1067370 | 15474 | 470 | 2.100756 | 9.8735532 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 181 | 3.4399999999999986e-55 | NR | YP_009446453.1 | 2044563 | g14926 | i0 | 85.6 | 110.1 | 97 | 14 | 61.9 | 0 | 292 | 2 | 7 | 103 | YP_009446453.1 NADH dehydrogenase subunit 10 [Ancoracysta twista] | diamond | 51747 | 182 | 0.994505494505495 | Eukaryota | Provora | Nebulidia | Nebulidea | Nebulidida | Nebulidae | Ancoracysta | Ancoracysta twista | ||
| 28392142 | 28392142 | PRJEB66218_P_NODE_61066_length_420_cov_2.183844_g58645_i0 | PRJEB66218 | 61066 | 420 | 2.183844 | 9.1721448 | Ancoracysta twista | 2044563 | Nebulidia | other_Eukaryota | 70.5 | 2.05e-11 | NR | YP_009446442.1 | 2044563 | g58645 | i0 | 50 | 1.37142857142857 | 64 | 32 | 45.7 | 0 | 314 | 123 | 104 | 167 | YP_009446442.1 cytochrome c oxidase subunit III [Ancoracysta twista] | diamond | 576 | 70.5 | 1 | Eukaryota | Provora | Nebulidia | Nebulidea | Nebulidida | Nebulidae | Ancoracysta | Ancoracysta twista | ||
| 28815925 | 28815925 | PRJNA564810_S_NODE_7368_length_219_cov_2.207792_g7346_i0 | PRJNA564810 | 7368 | 219 | 2.207792 | 4.83506448 | Ancoracysta twista | 2044563 | Nebulidia | other_Eukaryota | 49.3 | 7.05e-6 | NR | YP_009446473.1 | 2044563 | g7346 | i0 | 46 | 1.23287671232877 | 50 | 27 | 68.5 | 0 | 196 | 47 | 1 | 50 | YP_009446473.1 Sec-independent protein translocase component TatA/E [Ancoracysta twista] | diamond | 270 | 49.3 | 1 | Eukaryota | Provora | Nebulidia | Nebulidea | Nebulidida | Nebulidae | Ancoracysta | Ancoracysta twista | ||
| 29622108 | 29622108 | PRJEB14803_P_NODE_32610_length_188_cov_1.294118_g32144_i0 | PRJEB14803 | 32610 | 188 | 1.294118 | 2.43294184 | Ancoracysta twista | 2044563 | Nebulidia | other_Eukaryota | 102 | 6.11e-25 | NR | ATY40842.1 | 2044563 | g32144 | i0 | 71 | 1.97872340425532 | 62 | 18 | 98.9 | 0 | 188 | 3 | 56 | 117 | ATY40842.1 holocytochrome c synthase, partial [Ancoracysta twista] | diamond | 372 | 102 | 1 | Eukaryota | Provora | Nebulidia | Nebulidea | Nebulidida | Nebulidae | Ancoracysta | Ancoracysta twista | ||
| 32685020 | 32685020 | PRJNA564013_P_NODE_313100_length_217_cov_4.916667_g310248_i0 | PRJNA564013 | 313100 | 217 | 4.916667 | 10.66916739 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.4 | 1.97e-9 | NR | YP_009446442.1 | 2044563 | g310248 | i0 | 57.4 | 10.6175115207373 | 47 | 20 | 65 | 0 | 1 | 141 | 106 | 152 | YP_009446442.1 cytochrome c oxidase subunit III [Ancoracysta twista] | diamond | 2304 | 62.8 | 0.993630573248408 | Eukaryota | Provora | Nebulidia | Nebulidea | Nebulidida | Nebulidae | Ancoracysta | Ancoracysta twista |
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);;