RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJDB12134", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 2 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12134 · 2 ✖

analysis 1

tax_clade 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
2255863 2255863 PRJDB12134_P_NODE_1122_length_984_cov_1.376509_g1029_i0 PRJDB12134 1122 984 1.376509 13.54484856 Pseudomonadati 3379134 Bacteria Bacteria 676 0   NTclustered gi|1015516084|gb|CP015080.1| 1823759 g1029 i0 80.085 198.368902439024 944 160 95 23 46 979 2847942 2847017 Desulfuromonas sp. DDH964 chromosome, complete genome blastn 195195 678 0.997050147492625 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp. DDH964
11478124 11478124 PRJDB12134_P_NODE_7830_length_348_cov_2.189091_g7695_i0 PRJDB12134 7830 348 2.189091 7.61803668 Desulfovibrio desulfuricans 876 Bacteria Bacteria 279 1.39e-70   NTclustered gi|2172810686|gb|CP077745.1| 876 g7695 i0 100 2.60344827586207 151 0 87 0 1 151 137028 137178 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 906 279 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans

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