RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA773625" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773625 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2482556 2482556 PRJNA773625_P_NODE_10262_length_163_cov_0.912281_g10247_i0 PRJNA773625 10262 163 0.912281 1.48701803 Erysipelotrichales 526525 Bacteria Bacteria 302 1.22e-77   NTclustered gi|2777632677|dbj|AP031432.1| 1982626 g10247 i0 100 14.7668711656442 163 0 100 0 1 163 2553175 2553013 Faecalibacillus intestinalis i32-0019-2J8 DNA, complete genome blastn 2407 302 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Faecalibacillus Faecalibacillus intestinalis
12686761 12686761 PRJNA773625_P_NODE_8850_length_166_cov_0.888889_g8835_i0 PRJNA773625 8850 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 307 2.69e-79   NTclustered gi|1796975023|gb|CP033086.1| 1280 g8835 i0 100 99.8915662650602 166 0 100 0 1 166 2420644 2420809 Staphylococcus aureus strain WH9628 chromosome blastn 16582 307 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
18601162 18601162 PRJNA773625_P_NODE_9375_length_165_cov_0.896552_g9360_i0 PRJNA773625 9375 165 0.896552 1.4793108 Staphylococcus cohnii 29382 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1373834432|emb|LT963440.1| 29382 g9360 i0 100 46.460606060606104 165 0 100 0 1 165 821894 822058 Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I blastn 7666 305 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus cohnii
19058878 19058878 PRJNA773625_P_NODE_1355_length_338_cov_1.072664_g1341_i0 PRJNA773625 1355 338 1.072664 3.62560432 root 1 Root_unresolved Root_unresolved 619 6.969999999999999e-173   NTclustered gi|1796975023|gb|CP033086.1| 1280 g1341 i0 99.704 42.9852071005917 338 1 100 0 1 338 2426826 2426489 Staphylococcus aureus strain WH9628 chromosome blastn 14529 619 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
19058881 19058881 PRJNA773625_P_NODE_8695_length_166_cov_0.888889_g8680_i0 PRJNA773625 8695 166 0.888889 1.47555574 Streptococcus 1301 Bacteria Bacteria 307 2.69e-79   NTclustered gi|2886512733|emb|OZ217346.1| 28037 g8680 i0 100 100 166 0 100 0 1 166 2035574 2035739 Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1 blastn 16600 307 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
19876054 19876054 PRJNA773625_P_NODE_7396_length_169_cov_0.866667_g7381_i0 PRJNA773625 7396 169 0.866667 1.46466723 Gemella haemolysans 1379 Bacteria Bacteria 279 5.95e-71   NTclustered gi|1829987927|gb|CP050965.1| 1379 g7381 i0 96.45 1 169 6 100 0 1 169 868634 868802 Gemella haemolysans strain FDAARGOS_740 chromosome blastn 169 279 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
21151855 21151855 PRJNA773625_P_NODE_4217_length_210_cov_1.515528_g4202_i0 PRJNA773625 4217 210 1.515528 3.1826088 Peptoniphilus genitalis 3036303 Bacteria Bacteria 307 3.5600000000000005e-79   NTclustered gi|2246887130|gb|CP097885.1| 3036303 g4202 i0 93.333 521.309523809524 210 11 100 3 1 210 291223 291017 Peptoniphilus genitalis strain SAHP1 chromosome, complete genome blastn 109475 307 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus genitalis

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