RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA591000", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJNA591000 · 5 ✖

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
26699650 26699650 PRJNA591000_P_NODE_181_length_1773_cov_4.336009_g130_i0 PRJNA591000 181 1773 4.336009 76.87743957 Spirochaetota bacterium 2202144 Bacteria Bacteria 209 1.54e-53   NR TXH10273.1 2202144 g130 i0 60.9 0.285956006768189 169 63 28.6 1 1772 1266 544 709 TXH10273.1 MAG: DNA polymerase III subunit alpha [Spirochaetota bacterium] diamond 507 209 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28753422 28753422 PRJNA591000_P_NODE_9967_length_446_cov_1.223022_g8405_i0 PRJNA591000 9967 446 1.223022 5.45467812 Spirochaetia bacterium 2053615 Bacteria Bacteria 48.9 9.85e-4   NR HBD95731.1 2053615 g8405 i0 66.7 0.221973094170404 33 11 22.2 0 415 317 84 116 HBD95731.1 hypothetical protein [Spirochaetia bacterium] diamond 99 48.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30901242 30901242 PRJNA591000_P_NODE_6394_length_563_cov_1.142322_g5065_i0 PRJNA591000 6394 563 1.142322 6.43127286 Spirochaetota bacterium 2202144 Bacteria Bacteria 60.1 8.58e-7   NR TXG81115.1 2202144 g5065 i0 59.1 0.234458259325044 44 18 23.4 0 561 430 340 383 TXG81115.1 MAG: hypothetical protein E6R13_06825, partial [Spirochaetota bacterium] diamond 132 60.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32451166 32451166 PRJNA591000_P_NODE_13439_length_401_cov_2.545699_g11847_i0 PRJNA591000 13439 401 2.545699 10.20825299 Spirochaetota bacterium 2202144 Bacteria Bacteria 52 6.38e-6   NR TXH08899.1 2202144 g11847 i0 43.7 0.531172069825436 71 40 53.1 0 244 32 4 74 TXH08899.1 MAG: hypothetical protein E6R04_09835 [Spirochaetota bacterium] diamond 213 52 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32860750 32860750 PRJNA591000_P_NODE_5240_length_643_cov_2.571661_g4127_i0 PRJNA591000 5240 643 2.571661 16.53578023 Spirochaetota bacterium 2202144 Bacteria Bacteria 70.1 4.96e-10   NR TXG80950.1 2202144 g4127 i0 60.7 0.261275272161742 56 20 26.1 1 234 401 107 160 TXG80950.1 MAG: collagen-like protein, partial [Spirochaetota bacterium] diamond 168 70.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium

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