RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA242641" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA242641 · 12 ✖

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
3607155 3607155 PRJNA242641_S_NODE_663_length_284_cov_5.145098_g635_i0 PRJNA242641 663 284 5.145098 14.61207832 Rummeliibacillus 648802 Bacteria Bacteria 486 6.069999999999999e-133   NTclustered gi|2563036164|gb|CP132291.1| 101070 g635 i0 97.535 1027.31338028169 284 7 100 0 1 284 3141764 3142047 Rummeliibacillus pycnus strain X33 chromosome, complete genome blastn 291757 486 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Rummeliibacillus Rummeliibacillus pycnus
4194529 4194529 PRJNA242641_S_NODE_1664_length_179_cov_3.406667_g1636_i0 PRJNA242641 1664 179 3.406667 6.09793393 root 1 Root_unresolved Root_unresolved 84.7 1e-19   NR MBO8630984.1 1280 g1636 i0 79.7 6.90502793296089 59 12 98.9 0 179 3 17 75 MBO8630984.1 hypothetical protein [Staphylococcus aureus] diamond 1236 85.5 0.990643274853801 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
6745107 6745107 PRJNA242641_S_NODE_766_length_263_cov_3.034188_g738_i0 PRJNA242641 766 263 3.034188 7.97991444 Rummeliibacillus pycnus 101070 Bacteria Bacteria 388 1.61e-103   NTclustered gi|2563036164|gb|CP132291.1| 101070 g738 i0 94.444 957.498098859316 252 14 97 0 1 252 1653587 1653838 Rummeliibacillus pycnus strain X33 chromosome, complete genome blastn 251822 388 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Rummeliibacillus Rummeliibacillus pycnus
8020840 8020840 PRJNA242641_S_NODE_307_length_416_cov_3.731266_g279_i0 PRJNA242641 307 416 3.731266 15.52206656 Rummeliibacillus pycnus 101070 Bacteria Bacteria 725 0   NTclustered gi|2563036164|gb|CP132291.1| 101070 g279 i0 98.077 1062.70913461538 416 8 100 0 1 416 1654002 1653587 Rummeliibacillus pycnus strain X33 chromosome, complete genome blastn 442087 725 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Rummeliibacillus Rummeliibacillus pycnus
9984757 9984757 PRJNA242641_S_NODE_1388_length_197_cov_4.946429_g1360_i0 PRJNA242641 1388 197 4.946429 9.74446513 Bacillales 1385 Bacteria Bacteria 303 4.27e-78   NTclustered gi|2313057121|gb|CP094729.1| 1282 g1360 i0 95.789 539.472081218274 190 4 96 4 1 189 778417 778231 Staphylococcus epidermidis strain IVB6210 chromosome, complete genome blastn 106276 303 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
9984758 9984758 PRJNA242641_S_NODE_1988_length_165_cov_6.852941_g1960_i0 PRJNA242641 1988 165 6.852941 11.30735265 Bacillati 1783272 Bacteria Bacteria 294 2.08e-75   NTclustered gi|1176884116|gb|CP020463.1| 1282 g1960 i0 98.788 501.666666666667 165 2 100 0 1 165 748936 748772 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 82775 294 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
11259874 11259874 PRJNA242641_S_NODE_1629_length_181_cov_6.940789_g1601_i0 PRJNA242641 1629 181 6.940789 12.56282809 Staphylococcus 1279 Bacteria Bacteria 329 6.340000000000001e-86   NTclustered gi|2318610287|gb|OP663211.1| 1280 g1601 i0 99.448 100 181 1 100 0 1 181 527 707 Staphylococcus aureus strain HA MRSA_3 16S ribosomal RNA gene, partial sequence blastn 18100 329 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
12535258 12535258 PRJNA242641_S_NODE_2330_length_153_cov_7.185484_g2302_i0 PRJNA242641 2330 153 7.185484 10.99379052 Staphylococcus 1279 Bacteria Bacteria 283 4.0799999999999995e-72   NTclustered gi|2588959008|gb|OR636873.1| 1280 g2302 i0 100 235.790849673203 153 0 100 0 1 153 1214 1366 Staphylococcus aureus strain SRV05 16S ribosomal RNA gene, partial sequence blastn 36076 283 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
14396481 14396481 PRJNA242641_S_NODE_772_length_262_cov_6.330472_g744_i0 PRJNA242641 772 262 6.330472 16.58583664 Staphylococcus epidermidis 1282 Bacteria Bacteria 435 2.0300000000000003e-117   NTclustered gi|2179631034|gb|CP090928.1| 1282 g744 i0 96.565 116.965648854962 262 9 100 0 1 262 874 613 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 30645 435 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
15084235 15084235 PRJNA242641_S_NODE_1552_length_185_cov_5.064103_g1524_i0 PRJNA242641 1552 185 5.064103 9.36859055 Bacillati 1783272 Bacteria Bacteria 342 8.369999999999999e-90   NTclustered gi|1176884116|gb|CP020463.1| 1282 g1524 i0 100 499.108108108108 185 0 100 0 1 185 749092 748908 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 92335 342 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
22733457 22733457 PRJNA242641_S_NODE_2358_length_152_cov_9.959350_g2330_i0 PRJNA242641 2358 152 9.95935 15.138212 Bacillales 1385 Bacteria Bacteria 281 1.46e-71   NTclustered gi|2556673542|gb|OR367734.1| 1282 g2330 i0 100 101.013157894737 152 0 100 0 1 152 517 366 Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence blastn 15354 281 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
25282767 25282767 PRJNA242641_S_NODE_280_length_436_cov_6.604423_g252_i0 PRJNA242641 280 436 6.604423 28.79528428 Staphylococcus 1279 Bacteria Bacteria 800 0   NTclustered gi|1176884116|gb|CP020463.1| 1282 g252 i0 99.771 501.05504587156 436 1 100 0 1 436 2278364 2277929 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 218460 800 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);;