RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJDB3785 · 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
29337788 29337788 PRJDB3785_S_NODE_989_length_808_cov_3.525692_g892_i0 PRJDB3785 989 808 3.525692 28.48759136 Leptospiraceae bacterium 2026757 Bacteria Bacteria 126 1.1299999999999998e-31   NR MDX1959828.1 2026757 g892 i0 40.9 0.571782178217822 154 78 56.4 4 145 600 54 196 MDX1959828.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 462 126 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
30411928 30411928 PRJDB3785_S_NODE_22753_length_168_cov_1.277311_g22600_i0 PRJDB3785 22753 168 1.277311 2.14588248 Spirochaetales bacterium 2026792 Bacteria Bacteria 41.2 0.0473   NR MDO4505486.1 2026792 g22600 i0 43.4 0.946428571428571 53 29 94.6 1 9 167 452 503 MDO4505486.1 hypothetical protein [Spirochaetales bacterium] diamond 159 41.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30632584 30632584 PRJDB3785_S_NODE_1793_length_597_cov_2.074818_g1656_i0 PRJDB3785 1793 597 2.074818 12.38666346 Leptospiraceae bacterium 2026757 Bacteria Bacteria 63.5 4.57e-8   NR MCB1190498.1 2026757 g1656 i0 32.9 1.63819095477387 164 102 81.9 6 501 13 147 303 MCB1190498.1 CAP domain-containing protein [Leptospiraceae bacterium] diamond 978 63.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31100644 31100644 PRJDB3785_S_NODE_315_length_1341_cov_3.154025_g282_i0 PRJDB3785 315 1341 3.154025 42.29547525 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.74e-11   NR MDR2632347.1 166 g282 i0 27.5 2.24608501118568 189 121 39.6 5 1298 768 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 3012 77 0.990909090909091 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31612690 31612690 PRJDB3785_S_NODE_3956_length_385_cov_1.511905_g3803_i0 PRJDB3785 3956 385 1.511905 5.82083425 Treponema sp. 166 Bacteria Bacteria 57 1.3e-7   NR MBR1613865.1 166 g3803 i0 55.3 1.0987012987013 47 21 36.6 0 384 244 59 105 MBR1613865.1 CAP domain-containing protein [Treponema sp.] diamond 423 57 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema 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);;