RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1192965" 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

  • PRJNA1192965 · 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
4870465 4870465 PRJNA1192965_P_NODE_4424_length_245_cov_0.895349_g4405_i0 PRJNA1192965 4424 245 0.895349 2.19360505 Lactobacillus 1578 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2096299657|gb|CP083392.1| 47770 g4405 i0 100 426.040816326531 245 0 100 0 1 245 90557 90801 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 104380 453 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
6145220 6145220 PRJNA1192965_P_NODE_3345_length_251_cov_0.865169_g3326_i0 PRJNA1192965 3345 251 0.865169 2.17157419 Staphylococcus 1279 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2482395019|gb|CP094927.1| 1280 g3326 i0 100 100 251 0 100 0 1 251 307609 307359 Staphylococcus aureus strain 13 chromosome, complete genome blastn 25100 464 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
8695387 8695387 PRJNA1192965_P_NODE_1087_length_377_cov_1.523026_g1068_i0 PRJNA1192965 1087 377 1.523026 5.74180802 Staphylococcus 1279 Bacteria Bacteria 680 0   NTclustered gi|2451579829|gb|CP118060.1| 1283 g1068 i0 99.204 466.262599469496 377 3 100 0 1 377 855976 855600 Staphylococcus haemolyticus strain VSI35 chromosome, complete genome blastn 175781 680 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
18172127 18172127 PRJNA1192965_P_NODE_4415_length_245_cov_0.895349_g4396_i0 PRJNA1192965 4415 245 0.895349 2.19360505 Finegoldia magna 1260 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2127667581|gb|CP085957.1| 1260 g4396 i0 100 648.955102040816 245 0 100 0 1 245 162671 162427 Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome blastn 158994 453 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Finegoldia Finegoldia magna
19446537 19446537 PRJNA1192965_P_NODE_2716_length_269_cov_1.719388_g2697_i0 PRJNA1192965 2716 269 1.719388 4.62515372 Staphylococcus warneri 1292 Bacteria Bacteria 488 1.5799999999999998e-133   NTclustered gi|1714036495|gb|CP031269.1| 1292 g2697 i0 99.625 474.323420074349 267 1 99 0 1 267 2316137 2315871 Staphylococcus warneri strain 16A chromosome, complete genome blastn 127593 488 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
22719223 22719223 PRJNA1192965_P_NODE_1898_length_306_cov_2.244635_g1879_i0 PRJNA1192965 1898 306 2.244635 6.8685831 Bacillales 1385 Bacteria Bacteria 566 8.239999999999998e-157   NTclustered gi|1176884116|gb|CP020463.1| 1282 g1879 i0 100 533.915032679739 306 0 100 0 1 306 750199 749894 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 163378 566 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis

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