RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA396510" 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

  • PRJNA396510 · 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
8731939 8731939 PRJNA396510_P_NODE_7907_length_211_cov_1.574074_g7838_i0 PRJNA396510 7907 211 1.574074 3.32129614 Streptococcus 1301 Bacteria Bacteria 390 3.459999999999999e-104   NTclustered gi|1403375826|emb|LS483375.1| 1302 g7838 i0 100 336 211 0 100 0 1 211 625278 625488 Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1 blastn 70896 390 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus gordonii
10615821 10615821 PRJNA396510_P_NODE_15769_length_162_cov_0.902655_g15700_i0 PRJNA396510 15769 162 0.902655 1.4623011 Staphylococcus hominis 1290 Bacteria Bacteria 300 4.36e-77   NTclustered gi|1714026535|gb|CP031277.1| 1290 g15700 i0 100 27.3827160493827 162 0 100 0 1 162 99897 99736 Staphylococcus hominis strain 19A chromosome, complete genome blastn 4436 300 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus hominis
11282373 11282373 PRJNA396510_P_NODE_5749_length_242_cov_1.595855_g5680_i0 PRJNA396510 5749 242 1.595855 3.8619691 Streptococcus 1301 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|1578096036|emb|LR216035.1| 1313 g5680 i0 100 336.892561983471 242 0 100 0 1 242 1835236 1834995 Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1 blastn 81528 448 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
11890736 11890736 PRJNA396510_P_NODE_16310_length_161_cov_0.910714_g16241_i0 PRJNA396510 16310 161 0.910714 1.46624954 Streptococcus oralis 1303 Bacteria Bacteria 254 3.42e-63   NTclustered gi|326682110|emb|FR720602.1| 927666 g16241 i0 95.57 24.3850931677019 158 7 98 0 4 161 1040699 1040542 Streptococcus oralis Uo5 complete genome sequence blastn 3926 254 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
15106883 15106883 PRJNA396510_P_NODE_2152_length_368_cov_1.479624_g2083_i0 PRJNA396510 2152 368 1.479624 5.44501632 Staphylococcus 1279 Bacteria Bacteria 658 0   NTclustered gi|93463980|gb|DQ472009.1| 1288 g2083 i0 98.913 485.013586956522 368 4 100 0 1 368 479 846 Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence blastn 178485 664 0.990963855421687 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus xylosus
16989354 16989354 PRJNA396510_P_NODE_13854_length_166_cov_0.871795_g13785_i0 PRJNA396510 13854 166 0.871795 1.4471797 Staphylococcus cohnii 29382 Bacteria Bacteria 298 1.62e-76   NTclustered gi|2624852950|gb|CP119997.1| 29382 g13785 i0 100 7.59036144578313 161 0 97 0 6 166 290118 289958 Staphylococcus cohnii strain Dog166 chromosome, complete genome blastn 1260 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus cohnii
20813540 20813540 PRJNA396510_P_NODE_15877_length_162_cov_0.902655_g15808_i0 PRJNA396510 15877 162 0.902655 1.4623011 Bacillus paralicheniformis 1648923 Bacteria Bacteria 294 2.03e-75   NTclustered gi|2006893320|dbj|AP023090.1| 1648923 g15808 i0 99.383 99.6481481481482 162 1 100 0 1 162 3044268 3044429 Bacillus paralicheniformis RSC-3 DNA, complete genome blastn 16143 294 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus paralicheniformis
22756115 22756115 PRJNA396510_P_NODE_16078_length_162_cov_0.902655_g16009_i0 PRJNA396510 16078 162 0.902655 1.4623011 Lactobacillus 1578 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2096299657|gb|CP083392.1| 47770 g16009 i0 100 584.759259259259 162 0 100 0 1 162 59085 59246 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 94731 300 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus

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