RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

bioproject 1

  • PRJEB73599 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
5237740 5237740 PRJEB73599_P_NODE_5465_length_271_cov_4.789256_g5178_i0 PRJEB73599 5465 271 4.789256 12.97888376 Thermococcus 2263 Archaea Archaea 179 7.6600000000000005e-50   NR WP_167728776.1 163002 g5178 i0 100 10.8376383763838 89 0 98.5 0 3 269 234 322 WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] diamond 2937 179 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp. 9N3
16298152 16298152 PRJEB73599_P_NODE_4733_length_305_cov_2.057971_g4446_i0 PRJEB73599 4733 305 2.057971 6.27681155 Thermococcus 2263 Archaea Archaea 191 9.659999999999998e-55   NR MEO2152736.1 35749 g4446 i0 100 14.9016393442623 101 0 99.3 0 1 303 549 649 MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.] diamond 4545 191 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp.
26995005 26995005 PRJEB73599_P_NODE_3542_length_376_cov_1.700288_g3256_i0 PRJEB73599 3542 376 1.700288 6.39308288 Thermococcus 2263 Archaea Archaea 248 1.44e-73   NR WP_167728776.1 163002 g3256 i0 97.6 3.98936170212766 125 3 99.7 0 2 376 64 188 WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] diamond 1500 248 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp. 9N3
30532414 30532414 PRJEB73599_P_NODE_9993_length_153_cov_2.129032_g9706_i0 PRJEB73599 9993 153 2.129032 3.25741896 Thermococcus 2263 Archaea Archaea 102 7.8e-24   NR MEO2152736.1 35749 g9706 i0 96.1 12.8039215686275 51 2 100 0 153 1 679 729 MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.] diamond 1959 102 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus sp.

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