RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1264536 · 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
2329326 2329326 PRJNA1264536_P_NODE_4702_length_250_cov_0.881356_g4628_i0 PRJNA1264536 4702 250 0.881356 2.20339 Faecalibacterium 216851 Bacteria Bacteria 462 8.83e-126   NTclustered gi|2094528058|gb|CP065382.1| 853 g4628 i0 100 39.052 250 0 100 0 1 250 1955882 1956131 Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome blastn 9763 462 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalibacterium Faecalibacterium prausnitzii
4191037 4191037 PRJNA1264536_P_NODE_4884_length_248_cov_0.891429_g4810_i0 PRJNA1264536 4884 248 0.891429 2.21074392 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 459 1.13e-124   NTclustered gi|2318943546|gb|CP107201.1| 2485925 g4810 i0 100 1.98790322580645 248 0 100 0 1 248 302940 302693 MAG: Oscillospiraceae bacterium isolate KR001_HAM_0045 chromosome, complete genome blastn 493 459 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
8706810 8706810 PRJNA1264536_P_NODE_3747_length_282_cov_0.856459_g3673_i0 PRJNA1264536 3747 282 0.856459 2.41521438 Faecalibacterium 216851 Bacteria Bacteria 394 3.75e-105   NTclustered gi|2094528058|gb|CP065382.1| 853 g3673 i0 100 245.560283687943 213 0 79 0 70 282 355362 355150 Faecalibacterium prausnitzii strain Fp944 chromosome, complete genome blastn 69248 394 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalibacterium Faecalibacterium prausnitzii
9292070 9292070 PRJNA1264536_P_NODE_4608_length_251_cov_0.876404_g4534_i0 PRJNA1264536 4608 251 0.876404 2.19977404 Clostridium manihotivorum 2320868 Bacteria Bacteria 52.8 0.023   NTclustered gi|1554469089|gb|CP025746.1| 2320868 g4534 i0 100 0.111553784860558 28 0 11 0 24 51 1835404 1835431 Clostridium manihotivorum strain CT4 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium manihotivorum
10568040 10568040 PRJNA1264536_P_NODE_5429_length_243_cov_0.917647_g5355_i0 PRJNA1264536 5429 243 0.917647 2.22988221 Faecalitalea cylindroides 39483 Bacteria Bacteria 444 3.09e-120   NTclustered gi|295098739|emb|FP929041.1| 717960 g5355 i0 99.588 13.6913580246914 243 1 100 0 1 243 917485 917727 Eubacterium cylindroides T2-87 draft genome blastn 3327 444 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Faecalitalea Faecalitalea cylindroides
18215663 18215663 PRJNA1264536_P_NODE_5235_length_245_cov_0.860465_g5161_i0 PRJNA1264536 5235 245 0.860465 2.10813925 Bacillus sp. FJAT-42376 2014076 Bacteria Bacteria 52.8 0.022   NTclustered gi|1519589463|gb|CP033906.1| 2014076 g5161 i0 100 0.114285714285714 28 0 11 0 34 61 1125341 1125368 Bacillus sp. FJAT-42376 chromosome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. FJAT-42376
22040595 22040595 PRJNA1264536_P_NODE_5378_length_243_cov_0.917647_g5304_i0 PRJNA1264536 5378 243 0.917647 2.22988221 Blautia wexlerae 418240 Bacteria Bacteria 444 3.09e-120   NTclustered gi|2921375364|gb|CP136550.1| 1121115 g5304 i0 99.588 5.86008230452675 243 1 100 0 1 243 3974127 3974369 Blautia wexlerae DSM 19850 chromosome, complete genome blastn 1424 444 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia wexlerae

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