RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJEB2333", tax_phylum = "Bacillota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 9 ✖

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB2333 · 9 ✖

analysis 1

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
4813964 4813964 PRJEB2333_P_NODE_2904_length_460_cov_2.900709_g2132_i0 PRJEB2333 2904 460 2.900709 13.3432614 Bacillati 1783272 Bacteria Bacteria 337 1.1e-87   NTclustered gi|1176884116|gb|CP020463.1| 1282 g2132 i0 100 366.980434782609 182 0 73 0 279 460 748736 748917 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 168811 337 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
8639262 8639262 PRJEB2333_P_NODE_3687_length_219_cov_11.181319_g2910_i0 PRJEB2333 3687 219 11.181319 24.48708861 Streptococcus 1301 Bacteria Bacteria 405 1.29e-108   NTclustered gi|1140122741|gb|CP019562.1| 1303 g2910 i0 100 106 219 0 100 0 1 219 1573074 1572856 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 23214 405 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
8639264 8639264 PRJEB2333_P_NODE_3847_length_199_cov_3.228395_g3070_i0 PRJEB2333 3847 199 3.228395 6.42450605 Planococcus 1372 Bacteria Bacteria 340 3.2899999999999996e-89   NTclustered gi|1799096099|gb|CP047673.1| 2233542 g3070 i0 97.487 534 199 5 100 0 1 199 139701 139503 Planococcus halotolerans strain Y50 chromosome, complete genome blastn 106266 340 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus halotolerans
13739606 13739606 PRJEB2333_P_NODE_3451_length_340_cov_6.217822_g2674_i0 PRJEB2333 3451 340 6.217822 21.1405948 Streptococcus 1301 Bacteria Bacteria 623 5.429999999999999e-174   NTclustered gi|2182940279|gb|OM368578.1| 1313 g2674 i0 99.706 147.202941176471 340 1 100 0 1 340 349 10 Streptococcus pneumoniae strain FC6532 16S ribosomal RNA gene, partial sequence blastn 50049 628 0.99203821656051006 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
17564017 17564017 PRJEB2333_P_NODE_2834_length_473_cov_4.784404_g2062_i0 PRJEB2333 2834 473 4.784404 22.63023092 Streptococcus 1301 Bacteria Bacteria 863 0   NTclustered gi|1140122741|gb|CP019562.1| 1303 g2062 i0 99.577 345.07822410148 473 2 100 0 1 473 1571585 1571113 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 163222 863 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
18837958 18837958 PRJEB2333_P_NODE_3695_length_218_cov_5.552486_g2918_i0 PRJEB2333 3695 218 5.552486 12.10441948 Bacillales 1385 Bacteria Bacteria 403 4.62e-108   NTclustered gi|2556673542|gb|OR367734.1| 1282 g2918 i0 100 110.009174311927 218 0 100 0 1 218 298 515 Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence blastn 23982 403 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
20112669 20112669 PRJEB2333_P_NODE_2336_length_687_cov_4.549231_g1581_i0 PRJEB2333 2336 687 4.549231 31.25321697 Streptococcus 1301 Bacteria Bacteria 1232 0   NTclustered gi|1140122741|gb|CP019562.1| 1303 g1581 i0 98.984 366.193595342067 689 5 100 2 1 687 1570541 1569853 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 251575 1238 0.995153473344103 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
20112705 20112705 PRJEB2333_P_NODE_4096_length_180_cov_2.916084_g3319_i0 PRJEB2333 4096 180 2.916084 5.2489512 Staphylococcus 1279 Bacteria Bacteria 333 4.87e-87   NTclustered gi|1487186653|gb|MF678869.1| 29380 g3319 i0 100 470.022222222222 180 0 100 0 1 180 2395 2574 Staphylococcus caprae strain DSM 20608 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 84604 333 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus caprae
23938526 23938526 PRJEB2333_P_NODE_4819_length_152_cov_1.626087_g4042_i0 PRJEB2333 4819 152 1.626087 2.47165224 Geobacillus 129337 Bacteria Bacteria 281 1.46e-71   NTclustered gi|1205983|gb|U33536.1|BSU33536 1422 g4042 i0 100 10 152 0 100 0 1 152 1508 1659 Bacillus stearothermophilus DNA polymerase I (polA) gene, complete cds blastn 1520 281 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus stearothermophilus

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