RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA358490", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA358490 · 3 ✖

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
12551762 12551762 PRJNA358490_P_NODE_6630_length_507_cov_4.814103_g6301_i0 PRJNA358490 6630 507 4.814103 24.40750221 Bacteriovorax 146784 Bacteria Bacteria 761 0   NTclustered gi|1700689994|gb|CP030035.1| 960 g6301 i0 94.877 286.595660749507 488 23 96 2 1 487 1660841 1660355 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 145304 761 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
18250675 18250675 PRJNA358490_P_NODE_2515_length_902_cov_4.589803_g2346_i0 PRJNA358490 2515 902 4.589803 41.40002306 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 494 2.2599999999999995e-165   NR HXH30334.1 2081706 g2346 i0 79.9 2.89356984478936 288 58 95.8 0 17 880 686 973 HXH30334.1 protein ndvB [Bacteriovoracaceae bacterium] diamond 2610 494 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
20800439 20800439 PRJNA358490_P_NODE_12357_length_239_cov_1.430000_g12013_i0 PRJNA358490 12357 239 1.43 3.4177 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 274 4.21e-69   NTclustered gi|2893356065|emb|OZ220488.1| 2053517 g12013 i0 88.312 18.1380753138075 231 23 96 4 3 231 729970 730198 MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1 blastn 4335 274 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium

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