RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA807347", 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

  • PRJNA807347 · 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
27022539 27022539 PRJNA807347_P_NODE_8442_length_285_cov_1.141509_g8339_i0 PRJNA807347 8442 285 1.141509 3.25330065 Spirochaetota bacterium 2202144 Bacteria Bacteria 105 5.94e-25   NR TXG82933.1 2202144 g8339 i0 70.3 0.673684210526316 64 19 67.4 0 1 192 237 300 TXG82933.1 MAG: hypothetical protein E6R13_04375 [Spirochaetota bacterium] diamond 192 105 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27528080 27528080 PRJNA807347_P_NODE_4343_length_398_cov_0.956923_g4240_i0 PRJNA807347 4343 398 0.956923 3.80855354 Spirochaetota bacterium 2202144 Bacteria Bacteria 109 8.410000000000001e-27   NR TXG81377.1 2202144 g4240 i0 75.8 0.49748743718593 66 16 49.7 0 200 397 1 66 TXG81377.1 MAG: hypothetical protein E6R13_06300 [Spirochaetota bacterium] diamond 198 109 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29611694 29611694 PRJNA807347_P_NODE_17590_length_233_cov_2.225000_g17487_i0 PRJNA807347 17590 233 2.225 5.18425 Spirochaetota bacterium 2202144 Bacteria Bacteria 107 2.41e-25   NR TXH08468.1 2202144 g17487 i0 66.2 0.991416309012876 77 26 99.1 0 233 3 252 328 TXH08468.1 MAG: hypothetical protein E6R04_10600 [Spirochaetota bacterium] diamond 231 107 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
30117227 30117227 PRJNA807347_P_NODE_15672_length_244_cov_1.812865_g15569_i0 PRJNA807347 15672 244 1.812865 4.4233906 Treponema vincentii ATCC 3558 69710 Bacteria Bacteria 133 6.11e-34   NR EEV21391.1 596324 g15569 i0 75.9 0.971311475409836 79 19 97.1 0 241 5 1001 1079 EEV21391.1 BNR domain protein [Treponema vincentii ATCC 35580] diamond 237 133 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
30433677 30433677 PRJNA807347_P_NODE_5973_length_336_cov_1.182510_g5870_i0 PRJNA807347 5973 336 1.18251 3.9732336 Spirochaetota bacterium 2202144 Bacteria Bacteria 46.6 0.00202   NR TXG86456.1 2202144 g5870 i0 44.1 0.526785714285714 59 30 50 1 169 2 5 63 TXG86456.1 MAG: hypothetical protein E6R13_00545 [Spirochaetota bacterium] diamond 177 46.6 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);;