RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1175041" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1175041 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
1591112 1591112 PRJNA1175041_P_NODE_103802_length_243_cov_0.894118_g100934_i0 PRJNA1175041 103802 243 0.894118 2.17270674 Streptococcus pasteurianus 197614 Bacteria Bacteria 449 6.65e-122   NTclustered gi|2605139866|gb|CP136943.1| 197614 g100934 i0 100 22 243 0 100 0 1 243 831437 831195 Streptococcus pasteurianus strain WUSP082 chromosome, complete genome blastn 5346 449 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pasteurianus
2316390 2316390 PRJNA1175041_P_NODE_39102_length_553_cov_1.456250_g36248_i0 PRJNA1175041 39102 553 1.45625 8.0530625 Bacillus 1386 Bacteria Bacteria 1016 0   NTclustered gi|2798377728|gb|CP168764.1| 1392 g36248 i0 99.819 100 553 1 100 0 1 553 3916615 3917167 Bacillus anthracis strain Z03-J001 chromosome, complete genome blastn 55300 1016 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
6143960 6143960 PRJNA1175041_P_NODE_27345_length_781_cov_1.593220_g24659_i0 PRJNA1175041 27345 781 1.59322 12.4430482 Bacillus 1386 Bacteria Bacteria 1432 0   NTclustered gi|2257786247|gb|CP085402.1| 1392 g24659 i0 99.744 100.166453265045 781 2 100 0 1 781 3356875 3357655 Bacillus anthracis strain CMF9 chromosome, complete genome blastn 78230 1432 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
8694047 8694047 PRJNA1175041_P_NODE_50007_length_440_cov_1.408719_g47140_i0 PRJNA1175041 50007 440 1.408719 6.1983636 Bacillus 1386 Bacteria Bacteria 813 0   NTclustered gi|984728683|gb|CP014179.1| 1392 g47140 i0 100 100 440 0 100 0 1 440 3948299 3947860 Bacillus anthracis strain Stendal chromosome, complete genome blastn 44000 813 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
9244378 9244378 PRJNA1175041_P_NODE_104108_length_242_cov_1.408284_g101240_i0 PRJNA1175041 104108 242 1.408284 3.40804728 Lachnospiraceae bacterium JLR.KK009 3114295 Bacteria Bacteria 398 2.4299999999999994e-106   NTclustered gi|2692820420|gb|CP143549.1| 3114295 g101240 i0 96.281 1.61157024793388 242 9 100 0 1 242 390155 389914 Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome blastn 390 398 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium JLR.KK009
9969239 9969239 PRJNA1175041_P_NODE_70868_length_325_cov_1.448413_g68000_i0 PRJNA1175041 70868 325 1.448413 4.70734225 Bacillus 1386 Bacteria Bacteria 590 5.2299999999999986e-164   NTclustered gi|2257786247|gb|CP085402.1| 1392 g68000 i0 99.385 100 325 2 100 0 1 325 3971078 3971402 Bacillus anthracis strain CMF9 chromosome, complete genome blastn 32500 590 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
12519810 12519810 PRJNA1175041_P_NODE_96810_length_249_cov_0.863636_g93942_i0 PRJNA1175041 96810 249 0.863636 2.15045364 root 1 Root_unresolved Root_unresolved 399 6.989999999999999e-107   NTclustered gi|1796975023|gb|CP033086.1| 1280 g93942 i0 95.582 99.566265060241 249 11 100 0 1 249 2463444 2463692 Staphylococcus aureus strain WH9628 chromosome blastn 24792 399 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
15619271 15619271 PRJNA1175041_P_NODE_106713_length_240_cov_0.910180_g103845_i0 PRJNA1175041 106713 240 0.91018 2.184432 Streptococcus mitis 28037 Bacteria Bacteria 377 3.14e-100   NTclustered gi|2886508907|emb|OZ217344.1| 28037 g103845 i0 95 100 240 12 100 0 1 240 785652 785891 Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1 blastn 24000 377 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
16343619 16343619 PRJNA1175041_P_NODE_108173_length_239_cov_0.915663_g105305_i0 PRJNA1175041 108173 239 0.915663 2.18843457 Streptococcus 1301 Bacteria Bacteria 442 1.0899999999999994e-119   NTclustered gi|335369081|gb|CP002843.1| 760570 g105305 i0 100 12.7531380753138 239 0 100 0 1 239 1698443 1698681 Streptococcus parasanguinis ATCC 15912, complete genome blastn 3048 442 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus parasanguinis
17618900 17618900 PRJNA1175041_P_NODE_40814_length_531_cov_1.296943_g37952_i0 PRJNA1175041 40814 531 1.296943 6.88676733 Bacillus 1386 Bacteria Bacteria 754 0   NTclustered gi|2257786247|gb|CP085402.1| 1392 g37952 i0 100 100.566854990584 408 0 100 0 124 531 3356178 3356585 Bacillus anthracis strain CMF9 chromosome, complete genome blastn 53401 754 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
22718005 22718005 PRJNA1175041_P_NODE_103818_length_243_cov_0.894118_g100950_i0 PRJNA1175041 103818 243 0.894118 2.17270674 Clostridia 186801 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|2777750333|dbj|AP031452.1| 39491 g100950 i0 99.177 20.7325102880658 243 2 100 0 1 243 2575854 2575612 Agathobacter rectalis k41-0107-C12 DNA, complete genome blastn 5038 438 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Agathobacter Agathobacter rectalis

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