RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1074407" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074407 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1463081 1463081 PRJNA1074407_P_NODE_124582_length_275_cov_1.460396_g120744_i0 PRJNA1074407 124582 275 1.460396 4.016089 Ruminiclostridium papyrosolvens 29362 Bacteria Bacteria 424 4.6499999999999996e-114   NTclustered gi|2463005755|gb|CP119677.1| 588581 g120744 i0 95.472 786.894545454545 265 12 96 0 1 265 508753 509017 Ruminiclostridium papyrosolvens DSM 2782 chromosome, complete genome blastn 216396 424 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminiclostridium Ruminiclostridium papyrosolvens
3566953 3566953 PRJNA1074407_P_NODE_125763_length_272_cov_1.286432_g121925_i0 PRJNA1074407 125763 272 1.286432 3.49909504 Clostridium 1485 Bacteria Bacteria 52.8 0.025   NTclustered gi|848258874|gb|CP011803.1| 536227 g121925 i0 96.774 0.216911764705882 31 1 11 0 47 77 259893 259923 Clostridium carboxidivorans P7, complete genome blastn 59 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium carboxidivorans
6119444 6119444 PRJNA1074407_P_NODE_104245_length_334_cov_1.164751_g100407_i0 PRJNA1074407 104245 334 1.164751 3.89026834 Bacillati 1783272 Bacteria Bacteria 617 2.48e-172   NTclustered gi|2175030136|gb|CP071992.1| 1282 g100407 i0 100 527.883233532934 334 0 100 0 1 334 789367 789034 Staphylococcus epidermidis strain CBPA-ST-11003 chromosome, complete genome blastn 176313 617 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
6119653 6119653 PRJNA1074407_P_NODE_75705_length_456_cov_1.425587_g71870_i0 PRJNA1074407 75705 456 1.425587 6.50067672 Streptococcus 1301 Bacteria Bacteria 843 0   NTclustered gi|1612126230|gb|CP028415.1| 28037 g71870 i0 100 325 456 0 100 0 1 456 245558 245103 Streptococcus mitis strain SK637 chromosome, complete genome blastn 148200 843 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
10392211 10392211 PRJNA1074407_P_NODE_148309_length_225_cov_2.375000_g144471_i0 PRJNA1074407 148309 225 2.375 5.34375 Bacillus cereus 1396 Bacteria Bacteria 405 1.33e-108   NTclustered gi|1783154430|gb|CP040340.1| 1396 g144471 i0 99.111 101 225 2 100 0 1 225 4949262 4949038 Bacillus cereus strain DLOU-Tangshan chromosome, complete genome blastn 22725 405 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
11667176 11667176 PRJNA1074407_P_NODE_124770_length_275_cov_1.034653_g120932_i0 PRJNA1074407 124770 275 1.034653 2.84529575 Lactococcus petauri 1940789 Bacteria Bacteria 54.7 0.007   NTclustered gi|2257541798|gb|CP086595.1| 1940789 g120932 i0 100 0.105454545454545 29 0 11 0 116 144 794808 794780 Lactococcus petauri strain LG26 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactococcus Lactococcus petauri
17594134 17594134 PRJNA1074407_P_NODE_145994_length_240_cov_0.910180_g142156_i0 PRJNA1074407 145994 240 0.91018 2.184432 Leuconostoc 1243 Bacteria Bacteria 438 1.4199999999999995e-118   NTclustered gi|2410894178|gb|CP113947.1| 33968 g142156 i0 99.583 338.004166666667 240 1 100 0 1 240 21028 20789 Leuconostoc pseudomesenteroides strain L64 chromosome, complete genome blastn 81121 438 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Leuconostoc Leuconostoc pseudomesenteroides
17594253 17594253 PRJNA1074407_P_NODE_71754_length_479_cov_2.467980_g67921_i0 PRJNA1074407 71754 479 2.46798 11.8216242 Streptococcus 1301 Bacteria Bacteria 845 0   NTclustered gi|1247204361|gb|CP023507.1| 1303 g67921 i0 98.542 335.112734864301 480 3 100 2 1 479 26780 26304 Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome blastn 160519 850 0.994117647058824 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis

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