RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1105232" and tax_phylum = "Preaxostyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preaxostyla · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1105232 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 0

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
20613750 20613750 PRJNA1105232_S_NODE_437_length_685_cov_12.809748_g246_i0 PRJNA1105232 437 685 12.809748 87.7467738 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 331 9.5e-106   NR KAJ4460960.1 342808 g246 i0 73.4 10.4058394160584 218 57 95.5 1 1 654 532 748 KAJ4460960.1 putative 60S ribosomal protein L8-3 [Paratrimastix pyriformis] diamond 7128 333 0.993993993993994 Eukaryota Metamonada   Preaxostyla     Paratrimastigidae Paratrimastix Paratrimastix pyriformis
24438525 24438525 PRJNA1105232_S_NODE_6520_length_239_cov_1.368421_g6304_i0 PRJNA1105232 6520 239 1.368421 3.27052619 Paratrimastix pyriformis 342808 Preaxostyla other_Eukaryota 67.8 4.66e-11   NR KAJ4459997.1 342808 g6304 i0 41.5 0.815899581589958 65 38 81.6 0 223 29 259 323 KAJ4459997.1 Transmembrane amino acid transporter [Paratrimastix pyriformis] diamond 195 67.8 1 Eukaryota Metamonada   Preaxostyla     Paratrimastigidae Paratrimastix Paratrimastix pyriformis
29562256 29562256 PRJNA1105232_S_NODE_15190_length_169_cov_1.300000_g14974_i0 PRJNA1105232 15190 169 1.3 2.197 Streblomastix strix 222440 Preaxostyla other_Eukaryota 90.5 1.98e-19   NR KAA6392760.1 222440 g14974 i0 69.1 8.78698224852071 55 17 97.6 0 167 3 1194 1248 KAA6392760.1 MAG: putative Pre-mRNA-processing-splicing factor 8 [Streblomastix strix] diamond 1485 90.5 1 Eukaryota Metamonada   Preaxostyla   Oxymonadida Streblomastigidae Streblomastix Streblomastix strix
32407327 32407327 PRJNA1105232_S_NODE_14179_length_174_cov_1.248000_g13963_i0 PRJNA1105232 14179 174 1.248 2.17152 Paratrimastix pyriformis 342808 Preaxostyla other_Eukaryota 63.5 4.07e-10   NR KAJ4460705.1 342808 g13963 i0 51.8 1.89655172413793 56 26 96.6 1 3 170 96 150 KAJ4460705.1 hypothetical protein PAPYR_2933 [Paratrimastix pyriformis] diamond 330 63.5 1 Eukaryota Metamonada   Preaxostyla     Paratrimastigidae Paratrimastix Paratrimastix pyriformis

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;