RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB673 · 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
6513018 6513018 PRJEB673_P_NODE_3826_length_507_cov_6.269068_g3496_i0 PRJEB673 3826 507 6.269068 31.78417476 Clostridium perfringens 1502 Bacteria Bacteria 52.8 0.05   NTclustered gi|2029167656|gb|CP073070.1| 1502 g3496 i0 100 0.165680473372781 28 0 6 0 386 413 1708194 1708167 Clostridium perfringens strain 19TSBNCP chromosome, complete genome blastn 84 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
6513060 6513060 PRJEB673_P_NODE_8606_length_255_cov_2.013636_g8257_i0 PRJEB673 8606 255 2.013636 5.1347718 uncultured Fusibacter sp. 291847 Bacteria Bacteria 154 6.17e-33   NTclustered gi|2907625746|emb|OZ223306.1| 291847 g8257 i0 96.739 425.070588235294 92 3 36 0 164 255 524010 523919 MAG: uncultured Fusibacter sp. isolate 578a3ba3-1f1f-47d2-b4ed-96899ed32e8b genome assembly, chromosome: 1 blastn 108393 154 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriales Family XII. Incertae Sedis Fusibacter uncultured Fusibacter sp.
8648438 8648438 PRJEB673_P_NODE_11947_length_157_cov_1.631148_g11598_i0 PRJEB673 11947 157 1.631148 2.56090236 Streptococcus 1301 Bacteria Bacteria 291 2.52e-74   NTclustered gi|2179901676|gb|CP046524.1| 1303 g11598 i0 100 328 157 0 100 0 1 157 18272 18116 Streptococcus oralis strain SOT chromosome, complete genome blastn 51496 291 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
13748702 13748702 PRJEB673_P_NODE_6691_length_335_cov_3.450000_g6342_i0 PRJEB673 6691 335 3.45 11.5575 Streptococcus 1301 Bacteria Bacteria 448 3.4499999999999995e-121   NTclustered gi|1140122741|gb|CP019562.1| 1303 g6342 i0 90.936 355.301492537313 342 18 100 11 1 335 1571581 1571246 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 119026 448 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
18846968 18846968 PRJEB673_P_NODE_12115_length_156_cov_1.264463_g11766_i0 PRJEB673 12115 156 1.264463 1.97256228 Streptococcus 1301 Bacteria Bacteria 279 5.41e-71   NTclustered gi|1140122741|gb|CP019562.1| 1303 g11766 i0 99.351 333.076923076923 154 1 99 0 3 156 1568869 1568716 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 51960 279 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
23947827 23947827 PRJEB673_P_NODE_9319_length_201_cov_2.271084_g8970_i0 PRJEB673 9319 201 2.271084 4.56487884 Streptococcus 1301 Bacteria Bacteria 355 1.19e-93   NTclustered gi|1948677368|gb|CP066059.1| 1303 g8970 i0 98.507 316.034825870647 201 3 100 0 1 201 902549 902349 Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome blastn 63523 355 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis

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