contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA489308" and tax_phylum = "Parabasalia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724858 | 1724858 | PRJNA489308_P_NODE_19982_length_287_cov_1.439252_g19906_i0 | PRJNA489308 | 19982 | 287 | 1.439252 | 4.13065324 | Spirotrichonymphida | 285693 | Parabasalia | other_Eukaryota | 131 | 2.9e-34 | NR | BAF48678.1 | 104086 | g19906 | i0 | 68.9 | 4.70383275261324 | 90 | 28 | 94.1 | 0 | 271 | 2 | 126 | 215 | BAF48678.1 enolase, partial [Holomastigotoides mirabile] | diamond | 1350 | 131 | 1 | Eukaryota | Metamonada | Parabasalia | Spirotrichonymphida | Holomastigotoididae | Holomastigotoides | Holomastigotoides mirabile | |||
| 29492303 | 29492303 | PRJNA489308_P_NODE_24870_length_268_cov_2.133333_g24794_i0 | PRJNA489308 | 24870 | 268 | 2.133333 | 5.71733244 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 8.26e-4 | NR | XP_001329858.1 | 412133 | g24794 | i0 | 33.9 | 2.92164179104478 | 56 | 37 | 62.7 | 0 | 176 | 9 | 14 | 69 | XP_001329858.1 phosphopyruvate hydratase protein [Trichomonas vaginalis G3] | diamond | 783 | 48.1 | 0.993762993762994 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30613348 | 30613348 | PRJNA489308_P_NODE_20613_length_284_cov_2.189573_g20537_i0 | PRJNA489308 | 20613 | 284 | 2.189573 | 6.21838732 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 44.7 | 0.0129 | NR | XP_001306132.1 | 412133 | g20537 | i0 | 34.9 | 0.665492957746479 | 63 | 38 | 64.4 | 2 | 1 | 183 | 56 | 117 | XP_001306132.1 sperm-tail PG-rich repeat-containing protein [Trichomonas vaginalis G3] | diamond | 189 | 44.7 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31751384 | 31751384 | PRJNA489308_P_NODE_23237_length_274_cov_1.532338_g23161_i0 | PRJNA489308 | 23237 | 274 | 1.532338 | 4.19860612 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 43.1 | 0.0403 | NR | XP_001301974.1 | 412133 | g23161 | i0 | 51.4 | 0.405109489051095 | 37 | 18 | 40.5 | 0 | 118 | 8 | 330 | 366 | XP_001301974.1 spectrin binding [Trichomonas vaginalis G3] | diamond | 111 | 43.1 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31799004 | 31799004 | PRJNA489308_P_NODE_31057_length_251_cov_0.865169_g30981_i0 | PRJNA489308 | 31057 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.9 | 4.53e-6 | NR | XP_067770170.1 | 135588 | g30981 | i0 | 38.7 | 1.57768924302789 | 62 | 38 | 74.1 | 0 | 222 | 37 | 298 | 359 | XP_067770170.1 histidine acid phosphatase [Histomonas meleagridis] | diamond | 396 | 53.9 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis |
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);;