RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA454154 · 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
3644452 3644452 PRJNA454154_S_NODE_463_length_173_cov_6.691176_g460_i0 PRJNA454154 463 173 6.691176 11.57573448 Paraclostridium 1849822 Bacteria Bacteria 320 3.61e-83   NTclustered gi|2091226359|gb|CP079737.1| 1490 g460 i0 100 916.219653179191 173 0 100 0 1 173 12670 12498 Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome blastn 158506 320 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium bifermentans
4268999 4268999 PRJNA454154_S_NODE_424_length_179_cov_1.028169_g421_i0 PRJNA454154 424 179 1.0281690000000001 1.84042251 Streptococcus sanguinis 1305 Bacteria Bacteria 320 3.76e-83   NTclustered gi|1539215237|emb|LR134002.1| 1305 g421 i0 98.889 336.424581005587 180 1 100 1 1 179 430556 430377 Streptococcus sanguinis strain NCTC10904 genome assembly, chromosome: 1 blastn 60220 320 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sanguinis
6819646 6819646 PRJNA454154_S_NODE_566_length_160_cov_2.772358_g563_i0 PRJNA454154 566 160 2.772358 4.4357728 Paraclostridium sordellii 1505 Bacteria Bacteria 202 1.2499999999999998e-47   NTclustered gi|2695206951|gb|CP124285.1| 1505 g563 i0 91.333 598.19375 150 10 93 3 4 151 3001361 3001509 Paraclostridium sordellii strain C128 chromosome, complete genome blastn 95711 202 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium sordellii
7471389 7471389 PRJNA454154_S_NODE_386_length_184_cov_2.829932_g383_i0 PRJNA454154 386 184 2.829932 5.20707488 Clostridia 186801 Bacteria Bacteria 86.1 1.55e-12   NTclustered gi|1899225395|gb|MT967859.1| 59620 g383 i0 93.22 4.78260869565217 59 3 32 1 22 80 1903 1960 Uncultured Clostridium sp. clone asv_358_2372 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 880 86.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
13195565 13195565 PRJNA454154_S_NODE_51_length_357_cov_13.212500_g48_i0 PRJNA454154 51 357 13.2125 47.168625 Turicibacter sp. TJ11 2806443 Bacteria Bacteria 394 4.87e-105   NTclustered gi|2179881633|gb|CP069349.1| 2806443 g48 i0 88.854 473.719887955182 323 33 90 3 35 356 3906 3586 Turicibacter sp. TJ11 chromosome, complete genome blastn 169118 394 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Turicibacteraceae Turicibacter Turicibacter sp. TJ11
17019258 17019258 PRJNA454154_S_NODE_194_length_232_cov_2.646154_g191_i0 PRJNA454154 194 232 2.646154 6.13907728 Staphylococcus epidermidis 1282 Bacteria Bacteria 377 3.01e-100   NTclustered gi|2505679996|gb|CP118820.1| 1282 g191 i0 97.297 509.461206896552 222 6 96 0 1 222 2419972 2419751 Staphylococcus epidermidis strain 7057 chromosome, complete genome blastn 118195 377 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
18293621 18293621 PRJNA454154_S_NODE_295_length_197_cov_8.900000_g292_i0 PRJNA454154 295 197 8.9 17.533 Paenibacillus elgii 189691 Bacteria Bacteria 75 3.64e-9   NTclustered gi|2482133391|gb|CP121215.1| 189691 g292 i0 79.487 24.8274111675127 117 14 57 9 3 115 191589 191699 Paenibacillus elgii strain L146 chromosome, complete genome blastn 4891 75 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus elgii

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