RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1204310 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1044945 1044945 PRJNA1204310_P_NODE_11741_length_514_cov_1.117914_g11444_i0 PRJNA1204310 11741 514 1.117914 5.74607796 Bacillales 1385 Bacteria Bacteria 950 0   NTclustered gi|1176884116|gb|CP020463.1| 1282 g11444 i0 100 534.025291828794 514 0 100 0 1 514 2278183 2277670 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 274489 950 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
2880412 2880412 PRJNA1204310_P_NODE_49363_length_258_cov_1.264865_g49066_i0 PRJNA1204310 49363 258 1.264865 3.2633517 Pediococcus ethanolidurans 319653 Bacteria Bacteria 165 2.89e-36   NTclustered gi|2739944708|emb|OZ061250.1| 319653 g49066 i0 81.91 65.9767441860465 199 33 77 3 42 239 1181735 1181539 Pediococcus ethanolidurans isolate Pediococcus ethanolidurans CIRM-BIA2669 genome assembly, chromosome: 1 blastn 17022 165 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Pediococcus Pediococcus ethanolidurans
4156579 4156579 PRJNA1204310_P_NODE_54804_length_249_cov_1.409091_g54507_i0 PRJNA1204310 54804 249 1.409091 3.50863659 Firmicutes bacterium ZOR0006 1339252 Bacteria Bacteria 453 5.29e-123   NTclustered gi|734593677|gb|KM585593.1| 1339252 g54507 i0 99.597 143.791164658635 248 1 99 0 2 249 1377 1130 Firmicutes bacterium ZOR0006 16S ribosomal RNA gene, partial sequence blastn 35804 453 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium ZOR0006
8697957 8697957 PRJNA1204310_P_NODE_33987_length_320_cov_1.578947_g33690_i0 PRJNA1204310 33987 320 1.578947 5.0526304 root 1 Root_unresolved Root_unresolved 592 1.4299999999999996e-164   NTclustered gi|1796975023|gb|CP033086.1| 1280 g33690 i0 100 46.91875 320 0 100 0 1 320 2427676 2427995 Staphylococcus aureus strain WH9628 chromosome blastn 15014 592 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
20171252 20171252 PRJNA1204310_P_NODE_29436_length_343_cov_0.748148_g29139_i0 PRJNA1204310 29436 343 0.748148 2.56614764 Streptococcus 1301 Bacteria Bacteria 60.2 1.94e-4   NTclustered gi|2170975497|dbj|AP025331.1| 1917441 g29139 i0 100 0.527696793002915 32 0 9 0 109 140 724806 724837 Streptococcus ruminantium GUT-183 DNA, complete genome blastn 181 60.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus ruminantium
22006265 22006265 PRJNA1204310_P_NODE_49318_length_258_cov_1.578378_g49021_i0 PRJNA1204310 49318 258 1.578378 4.07221524 Rossellomorea marisflavi 189381 Bacteria Bacteria 62.1 3.9e-5   NTclustered gi|2530477131|gb|CP128801.1| 189381 g49021 i0 97.222 0.375968992248062 36 1 14 0 15 50 1432300 1432265 Rossellomorea marisflavi strain SRCM125375 chromosome, complete genome blastn 97 62.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Rossellomorea Rossellomorea marisflavi
23281103 23281103 PRJNA1204310_P_NODE_26719_length_357_cov_1.573944_g26422_i0 PRJNA1204310 26719 357 1.573944 5.61898008 Pediococcus damnosus 51663 Bacteria Bacteria 198 4.1e-46   NTclustered gi|1015507319|gb|CP012271.1| 51663 g26422 i0 80 2.85714285714286 275 49 78 5 4 278 2061 1793 Pediococcus damnosus strain TMW 2.1532 plasmid pL21532-2, complete sequence blastn 1020 198 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Pediococcus Pediococcus damnosus

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