RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA335774" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA335774 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
5494373 5494373 PRJNA335774_P_NODE_47425_length_242_cov_0.911243_g47273_i0 PRJNA335774 47425 242 0.911243 2.20520806 Staphylococcus epidermidis 1282 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|2315803957|gb|CP106835.1| 1282 g47273 i0 100 7 242 0 100 0 1 242 34701 34460 Staphylococcus epidermidis strain AH6072 plasmid pAH6072_1, complete sequence blastn 1694 448 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
11869305 11869305 PRJNA335774_P_NODE_42910_length_247_cov_0.885057_g42758_i0 PRJNA335774 42910 247 0.885057 2.18609079 Streptococcus sp. Marseille-Q6470 2972784 Bacteria Bacteria 374 4.189999999999998e-99   NTclustered gi|2306632708|emb|OX336385.1| 2972784 g42758 i0 93.927 2.98785425101215 247 15 100 0 1 247 231626 231380 Streptococcus sp. Marseille-Q6470 genome assembly, chromosome: contig00001 blastn 738 374 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. Marseille-Q6470
12548207 12548207 PRJNA335774_P_NODE_38670_length_251_cov_1.713483_g38518_i0 PRJNA335774 38670 251 1.713483 4.30084233 Staphylococcus 1279 Bacteria Bacteria 464 2.47e-126   NTclustered gi|1176884116|gb|CP020463.1| 1282 g38518 i0 100 534.764940239044 251 0 100 0 1 251 748740 748490 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 134226 464 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
13143720 13143720 PRJNA335774_P_NODE_20191_length_341_cov_1.149254_g20039_i0 PRJNA335774 20191 341 1.149254 3.91895614 Natroniella sp. ANB-PHB2 3384444 Bacteria Bacteria 54.7 0.009   NTclustered gi|2869714905|gb|CP175562.1| 3384444 g20039 i0 100 0.0850439882697947 29 0 9 0 52 80 1966718 1966746 Natroniella sp. ANB-PHB2 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halobacteroidaceae Natroniella Natroniella sp. ANB-PHB2
17647194 17647194 PRJNA335774_P_NODE_25274_length_310_cov_1.658228_g25122_i0 PRJNA335774 25274 310 1.658228 5.1405068 Clostridium 1485 Bacteria Bacteria 54.7 0.008   NTclustered gi|2425298477|gb|CP114763.1| 1492 g25122 i0 100 1.96451612903226 29 0 9 0 128 156 3511064 3511036 Clostridium butyricum strain LV1 chromosome 1, complete sequence blastn 609 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
22067189 22067189 PRJNA335774_P_NODE_4498_length_642_cov_1.246046_g4355_i0 PRJNA335774 4498 642 1.246046 7.99961532 Clostridium sp. MB05 3376682 Bacteria Bacteria 58.4 0.001   NTclustered gi|2882621205|gb|CP174370.1| 3376682 g4355 i0 100 0.0482866043613707 31 0 5 0 191 221 463333 463363 Clostridium sp. MB05 chromosome, complete genome blastn 31 58.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. MB05

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