RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA752278 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2004485 2004485 PRJNA752278_P_NODE_93842_length_245_cov_0.895349_g93639_i0 PRJNA752278 93842 245 0.895349 2.19360505 Peredibacter starrii 28202 Bacteria Bacteria 195 3.47e-45   NTclustered gi|2631252187|gb|CP139487.1| 28202 g93639 i0 86.441 0.722448979591837 177 24 72 0 1 177 3294298 3294122 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 177 195 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
5830676 5830676 PRJNA752278_P_NODE_20285_length_353_cov_2.857143_g20082_i0 PRJNA752278 20285 353 2.857143 10.08571479 Peredibacter starrii 28202 Bacteria Bacteria 479 1.2899999999999996e-130   NTclustered gi|2631252187|gb|CP139487.1| 28202 g20082 i0 91.268 142.940509915014 355 26 100 5 1 353 510709 511060 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 50458 479 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
8381579 8381579 PRJNA752278_P_NODE_85667_length_248_cov_0.880000_g85464_i0 PRJNA752278 85667 248 0.88 2.1824 Peredibacter starrii 28202 Bacteria Bacteria 248 2.67e-61   NTclustered gi|2631252187|gb|CP139487.1| 28202 g85464 i0 84.861 74.4556451612903 251 32 100 6 1 248 512141 512388 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 18465 248 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
19052444 19052444 PRJNA752278_P_NODE_215_length_1803_cov_5.808671_g157_i0 PRJNA752278 215 1803 5.808671 104.73033813 Peredibacter 263370 Bacteria Bacteria 3038 0   NTclustered gi|2631252187|gb|CP139487.1| 28202 g157 i0 97.114 185.66444814198601 1802 50 99 2 2 1803 512552 510753 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 334753 3038 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
24954752 24954752 PRJNA752278_P_NODE_80960_length_250_cov_0.870056_g80757_i0 PRJNA752278 80960 250 0.870056 2.17514 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 278 3.43e-70   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g80757 i0 86.957 40.228 253 25 99 7 2 250 909495 909743 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 10057 278 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198

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