RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA448207 · 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
1713728 1713728 PRJNA448207_P_NODE_32282_length_242_cov_0.911243_g32119_i0 PRJNA448207 32282 242 0.911243 2.20520806 Finegoldia magna 1260 Bacteria Bacteria 436 5.1499999999999985e-118   NTclustered gi|2127667581|gb|CP085957.1| 1260 g32119 i0 99.174 33.702479338843 242 2 100 0 1 242 659585 659826 Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome blastn 8156 436 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Finegoldia Finegoldia magna
2367696 2367696 PRJNA448207_P_NODE_22522_length_270_cov_1.329949_g22359_i0 PRJNA448207 22522 270 1.329949 3.5908623 root 1 Root_unresolved Root_unresolved 494 3.4199999999999996e-135   NTclustered gi|1937010051|gb|CP065046.1| 1249 g22359 i0 99.63 121.003703703704 270 1 100 0 1 270 469790 470059 Weissella paramesenteroides strain STCH-BD1 chromosome blastn 32671 494 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella paramesenteroides
5542554 5542554 PRJNA448207_P_NODE_27385_length_249_cov_0.875000_g27222_i0 PRJNA448207 27385 249 0.875 2.17875 Staphylococcus epidermidis 1282 Bacteria Bacteria 460 3.16e-125   NTclustered gi|1214725545|gb|CP022247.1| 1282 g27222 i0 100 100 249 0 100 0 1 249 2344333 2344581 Staphylococcus epidermidis strain AMT chromosome, complete genome blastn 24900 460 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
8745294 8745294 PRJNA448207_P_NODE_26367_length_250_cov_0.870056_g26204_i0 PRJNA448207 26367 250 0.870056 2.17514 Staphylococcus 1279 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1848626851|gb|CP054017.1| 1292 g26204 i0 100 99.956 250 0 100 0 1 250 519912 520161 Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome blastn 24989 462 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
9366694 9366694 PRJNA448207_P_NODE_26348_length_250_cov_0.870056_g26185_i0 PRJNA448207 26348 250 0.870056 2.17514 Staphylococcus cohnii 29382 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1373834432|emb|LT963440.1| 29382 g26185 i0 100 4 250 0 100 0 1 250 165277 165028 Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I blastn 1000 462 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus cohnii
12571200 12571200 PRJNA448207_P_NODE_26550_length_250_cov_0.870056_g26387_i0 PRJNA448207 26550 250 0.870056 2.17514 Exiguobacterium 33986 Bacteria Bacteria 451 1.91e-122   NTclustered gi|1735050952|gb|CP030931.1| 41170 g26387 i0 99.2 790.356 250 2 100 0 1 250 13466 13217 Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome blastn 197589 451 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium acetylicum
13845986 13845986 PRJNA448207_P_NODE_7131_length_455_cov_1.573298_g6969_i0 PRJNA448207 7131 455 1.573298 7.1585059 Staphylococcus 1279 Bacteria Bacteria 830 0   NTclustered gi|1176884116|gb|CP020463.1| 1282 g6969 i0 99.56 542.07032967033 455 2 100 0 1 455 2277818 2278272 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 246642 830 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
21494172 21494172 PRJNA448207_P_NODE_28937_length_247_cov_0.885057_g28774_i0 PRJNA448207 28937 247 0.885057 2.18609079 Staphylococcus 1279 Bacteria Bacteria 457 4.05e-124   NTclustered gi|1848617844|gb|CP053957.1| 29388 g28774 i0 100 49.5101214574899 247 0 100 0 1 247 1755095 1755341 Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome blastn 12229 457 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
23391076 23391076 PRJNA448207_P_NODE_32839_length_241_cov_1.952381_g32676_i0 PRJNA448207 32839 241 1.952381 4.70523821 Gemella haemolysans 1379 Bacteria Bacteria 429 8.58e-116   NTclustered gi|1540173839|emb|LR134484.1| 1379 g32676 i0 98.755 347.98755186722 241 3 100 0 1 241 9541 9781 Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1 blastn 83865 429 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans

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