RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA400171" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400171 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1688525 1688525 PRJNA400171_S_NODE_2602_length_248_cov_2.684932_g2512_i0 PRJNA400171 2602 248 2.684932 6.65863136 Staphylococcus epidermidis 1282 Bacteria Bacteria 448 2.4499999999999996e-121   NTclustered gi|1214725545|gb|CP022247.1| 1282 g2512 i0 99.194 487.016129032258 248 2 100 0 1 248 1785375 1785622 Staphylococcus epidermidis strain AMT chromosome, complete genome blastn 120780 448 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
7458921 7458921 PRJNA400171_S_NODE_6946_length_171_cov_2.992958_g6856_i0 PRJNA400171 6946 171 2.992958 5.11795818 Staphylococcus 1279 Bacteria Bacteria 316 4.6e-82   NTclustered gi|2482395019|gb|CP094927.1| 1280 g6856 i0 100 547.87134502924 171 0 100 0 1 171 969467 969637 Staphylococcus aureus strain 13 chromosome, complete genome blastn 93686 316 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
17658534 17658534 PRJNA400171_S_NODE_3454_length_223_cov_2.891753_g3364_i0 PRJNA400171 3454 223 2.891753 6.44860919 Staphylococcus 1279 Bacteria Bacteria 412 7.88e-111   NTclustered gi|1176884116|gb|CP020463.1| 1282 g3364 i0 100 531.484304932735 223 0 100 0 1 223 748662 748440 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 118521 412 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
18932485 18932485 PRJNA400171_S_NODE_7895_length_162_cov_2.774436_g7805_i0 PRJNA400171 7895 162 2.774436 4.49458632 Staphylococcus 1279 Bacteria Bacteria 289 9.44e-74   NTclustered gi|2521585500|gb|CP127567.1| 1280 g7805 i0 98.765 542.246913580247 162 2 100 0 1 162 466308 466147 Staphylococcus aureus strain C888 chromosome, complete genome blastn 87844 289 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
22757933 22757933 PRJNA400171_S_NODE_6778_length_173_cov_2.701389_g6688_i0 PRJNA400171 6778 173 2.701389 4.67340297 Streptococcus 1301 Bacteria Bacteria 270 3.69e-68   NTclustered gi|1825984613|gb|CP050270.1| 1309 g6688 i0 94.828 416.635838150289 174 7 100 2 1 173 2616 2788 Streptococcus mutans strain S4 chromosome, complete genome blastn 72078 270 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mutans
22757934 22757934 PRJNA400171_S_NODE_7338_length_167_cov_3.094203_g7248_i0 PRJNA400171 7338 167 3.094203 5.16731901 Bacteria 2 Bacteria Bacteria 309 7.53e-80   NTclustered gi|379994767|gb|JQ661013.1| 1409 g7248 i0 100 101 167 0 100 0 1 167 197 31 Bacillus sp. strain g53_37F 16S ribosomal RNA gene, partial sequence blastn 16867 309 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. (in: firmicutes)

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