RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1136957 · 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
1032009 1032009 PRJNA1136957_S_NODE_11361_length_254_cov_1.415385_g11264_i0 PRJNA1136957 11361 254 1.415385 3.5950779 Streptococcus 1301 Bacteria Bacteria 464 2.4999999999999994e-126   NTclustered gi|2563200286|dbj|AP028603.1| 1313 g11264 i0 99.606 339 254 1 100 0 1 254 18537 18284 Streptococcus pneumoniae Pne2 DNA, complete genome blastn 86106 464 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
2835280 2835280 PRJNA1136957_S_NODE_5623_length_339_cov_1.728571_g5526_i0 PRJNA1136957 5623 339 1.728571 5.85985569 Bacillus manliponensis 574376 Bacteria Bacteria 60.2 1.91e-4   NTclustered gi|2785673827|gb|CP165965.1| 574376 g5526 i0 97.143 6.80530973451327 35 1 10 0 56 90 2808510 2808476 Bacillus manliponensis strain jeju3-1 chromosome, complete genome blastn 2307 60.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus manliponensis
7409947 7409947 PRJNA1136957_S_NODE_926_length_586_cov_15.631879_g843_i0 PRJNA1136957 926 586 15.631879 91.60281094 Clostridioides 1870884 Bacteria Bacteria 58.4 0.001   NTclustered gi|2319031117|gb|CP107108.1| 1496 g843 i0 97.059 5.29863481228669 34 1 6 0 55 88 3418885 3418918 Clostridioides difficile strain R_phiCD75-3 chromosome, complete genome blastn 3105 58.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
12510739 12510739 PRJNA1136957_S_NODE_12330_length_245_cov_1.725806_g12233_i0 PRJNA1136957 12330 245 1.725806 4.2282247 Streptococcus 1301 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1140122741|gb|CP019562.1| 1303 g12233 i0 100 353.277551020408 245 0 100 0 1 245 1571225 1571469 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 86553 453 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
13038276 13038276 PRJNA1136957_S_NODE_13531_length_234_cov_63.160000_g13434_i0 PRJNA1136957 13531 234 63.16 147.7944 Romboutsia ilealis 1115758 Bacteria Bacteria 54.7 0.006   NTclustered gi|1172272411|emb|LN555523.1| 1115758 g13434 i0 100 0.123931623931624 29 0 12 0 165 193 1274284 1274312 Romboutsia ilealis strain CRIB genome assembly, chromosome: chr1 blastn 29 54.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia ilealis
13785387 13785387 PRJNA1136957_S_NODE_8571_length_288_cov_0.986900_g8474_i0 PRJNA1136957 8571 288 0.9869 2.842272 root 1 Root_unresolved Root_unresolved 505 1.7e-138   NTclustered gi|2283119276|gb|CP071933.1| 1390 g8474 i0 98.264 103.493055555556 288 5 100 0 1 288 1212 925 Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence blastn 29806 510 0.990196078431373 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus amyloliquefaciens
15059695 15059695 PRJNA1136957_S_NODE_18192_length_204_cov_1.489655_g18095_i0 PRJNA1136957 18192 204 1.489655 3.0388962 Granulicatella 117563 Bacteria Bacteria 366 5.599999999999998e-97   NTclustered gi|2315116068|gb|CP106751.1| 46124 g18095 i0 99.02 473.779411764706 204 2 100 0 1 204 13687 13890 Granulicatella adiacens strain KHUD_009 chromosome, complete genome blastn 96651 366 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Granulicatella Granulicatella adiacens
21961325 21961325 PRJNA1136957_S_NODE_13758_length_233_cov_1.051724_g13661_i0 PRJNA1136957 13758 233 1.051724 2.45051692 Ligilactobacillus aviarius 1606 Bacteria Bacteria 431 2.2899999999999996e-116   NTclustered gi|2729058697|emb|OZ006997.1| 1606 g13661 i0 100 575.296137339056 233 0 100 0 1 233 318192 318424 MAG: Ligilactobacillus aviarius isolate pooled_s2189.ctg002983c_hifiasm_circ MAG genome assembly, chromosome: 1 blastn 134044 431 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Ligilactobacillus Ligilactobacillus aviarius
25258318 25258318 PRJNA1136957_S_NODE_13900_length_232_cov_1.005780_g13803_i0 PRJNA1136957 13900 232 1.00578 2.3334096 Bacillati 1783272 Bacteria Bacteria 412 8.26e-111   NTclustered gi|2179631034|gb|CP090928.1| 1282 g13803 i0 98.707 117.086206896552 232 3 100 0 1 232 738 507 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 27164 412 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis

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