RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068513 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
1013639 1013639 PRJNA1068513_S_NODE_6801_length_350_cov_1.783394_g6755_i0 PRJNA1068513 6801 350 1.783394 6.241879 Clostridium 1485 Bacteria Bacteria 52.8 0.033   NTclustered gi|2385532608|gb|CP086246.1| 2843318 g6755 i0 100 0.24 28 0 8 0 173 200 2436613 2436640 Clostridium sp. CF011 chromosome, complete genome blastn 84 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CF011
2288886 2288886 PRJNA1068513_S_NODE_6602_length_355_cov_8.248227_g6556_i0 PRJNA1068513 6602 355 8.248227 29.28120585 Blautia 572511 Bacteria Bacteria 52.8 0.034   NTclustered gi|2884834701|gb|CP176621.1| 1532 g6556 i0 100 0.552112676056338 28 0 8 0 100 127 1870490 1870463 Blautia coccoides strain RS-04 chromosome, complete genome blastn 196 52.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia coccoides
6116803 6116803 PRJNA1068513_S_NODE_7145_length_341_cov_2.764925_g7099_i0 PRJNA1068513 7145 341 2.764925 9.42839425 root 1 Root_unresolved Root_unresolved 54.7 0.009   NTclustered gi|2702638792|gb|CP148048.1| 33033 g7099 i0 100 0.859237536656892 29 0 9 0 152 180 1540077 1540105 Parvimonas micra strain JM503A chromosome, complete genome blastn 293 54.7 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Parvimonas Parvimonas micra
9941752 9941752 PRJNA1068513_S_NODE_11328_length_262_cov_4.571429_g11282_i0 PRJNA1068513 11328 262 4.571429 11.97714398 root 1 Root_unresolved Root_unresolved 56.5 0.002   NTclustered gi|1878067685|dbj|LC566215.1| 1352 g11282 i0 96.97 12.0572519083969 33 1 13 0 13 45 98 130 Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence blastn 3159 56.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
11660555 11660555 PRJNA1068513_S_NODE_8370_length_313_cov_2.008333_g8324_i0 PRJNA1068513 8370 313 2.008333 6.28608229 Clostridium beijerinckii 1520 Bacteria Bacteria 52.8 0.029   NTclustered gi|2324517193|gb|CP107022.1| 1520 g8324 i0 94.286 0.335463258785943 35 1 11 1 197 230 3529705 3529739 Clostridium beijerinckii strain CloBei18h chromosome, complete genome blastn 105 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium beijerinckii
14210540 14210540 PRJNA1068513_S_NODE_2512_length_529_cov_5.885965_g2469_i0 PRJNA1068513 2512 529 5.885965 31.13675485 Bacillus sp. Y1 352858 Bacteria Bacteria 54.7 0.014   NTclustered gi|1480120062|gb|CP030028.1| 352858 g2469 i0 100 0.054820415879017 29 0 5 0 352 380 3456154 3456126 Bacillus sp. Y1 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. Y1
14210577 14210577 PRJNA1068513_S_NODE_5552_length_386_cov_1.923323_g5506_i0 PRJNA1068513 5552 386 1.923323 7.42402678 Clostridium intestinale 36845 Bacteria Bacteria 52.8 0.037   NTclustered gi|2651387689|gb|CP121166.1| 36845 g5506 i0 100 0.0725388601036269 28 0 7 0 30 57 1563141 1563114 Clostridium intestinale strain PC17 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium intestinale
15041312 15041312 PRJNA1068513_S_NODE_5592_length_384_cov_3.758842_g5546_i0 PRJNA1068513 5592 384 3.758842 14.43395328 Agathobacter 1766253 Bacteria Bacteria 54.7 0.01   NTclustered gi|2202783703|gb|CP092643.1| 39491 g5546 i0 100 0.309895833333333 29 0 8 0 7 35 552712 552740 Agathobacter rectalis strain VPI 0990 chromosome, complete genome blastn 119 54.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Agathobacter Agathobacter rectalis
17591402 17591402 PRJNA1068513_S_NODE_12894_length_246_cov_1.092486_g12848_i0 PRJNA1068513 12894 246 1.092486 2.68751556 Clostridium 1485 Bacteria Bacteria 54.7 0.006   NTclustered gi|2031304926|gb|CP073653.1| 1520 g12848 i0 100 1.0609756097561 29 0 12 0 211 239 5633305 5633277 Clostridium beijerinckii strain DSM 791 chromosome, complete genome blastn 261 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium beijerinckii

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