contig_metadata
4 rows where bioproject = "PRJNA484127", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27756024 | 27756024 | PRJNA484127_P_NODE_31984_length_250_cov_0.881356_g31835_i0 | PRJNA484127 | 31984 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 1.29e-26 | NR | KAA6388004.1 | 222440 | g31835 | i0 | 55.6 | 2.916 | 81 | 36 | 97.2 | 0 | 248 | 6 | 87 | 167 | KAA6388004.1 MAG: putative Translationally-controlled tumor protein [Streblomastix strix] | diamond | 729 | 105 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28718555 | 28718555 | PRJNA484127_P_NODE_25267_length_269_cov_2.091837_g25118_i0 | PRJNA484127 | 25267 | 269 | 2.091837 | 5.62704153 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 51.6 | 1.7e-5 | NR | KAK2956265.1 | 2049346 | g25118 | i0 | 66.7 | 0.401486988847584 | 36 | 12 | 40.1 | 0 | 268 | 161 | 130 | 165 | KAK2956265.1 putative 60S ribosomal protein L18-3 [Blattamonas nauphoetae] | diamond | 108 | 51.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28781428 | 28781428 | PRJNA484127_P_NODE_35067_length_246_cov_1.410405_g34918_i0 | PRJNA484127 | 35067 | 246 | 1.410405 | 3.4695963 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 52.8 | 1.13e-5 | NR | KAJ4463103.1 | 342808 | g34918 | i0 | 45.8 | 2.96341463414634 | 59 | 28 | 72 | 1 | 178 | 2 | 182 | 236 | KAJ4463103.1 putative Hydroxylamine reductase [Paratrimastix pyriformis] | diamond | 729 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31024200 | 31024200 | PRJNA484127_P_NODE_14475_length_332_cov_2.123552_g14326_i0 | PRJNA484127 | 14475 | 332 | 2.123552 | 7.05019264 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 87.8 | 1.72e-17 | NR | KAJ4461259.1 | 342808 | g14326 | i0 | 42.4 | 1.8433734939759 | 99 | 56 | 88.6 | 1 | 310 | 17 | 1106 | 1204 | KAJ4461259.1 putative MFS-type transporter [Paratrimastix pyriformis] | diamond | 612 | 87.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;