RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB1404", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Bdellovibrionota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB1404 · 4 ✖

analysis 1

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
3536316 3536316 PRJEB1404_P_NODE_183_length_521_cov_31.916327_g166_i0 PRJEB1404 183 521 31.916327 166.28406367 Bacteriovorax 146784 Bacteria Bacteria 555 3.19e-153   NTclustered gi|1700689994|gb|CP030035.1| 960 g166 i0 86.408 70.4740882917466 515 60 98 10 11 520 1660852 1660343 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 36717 555 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
9913885 9913885 PRJEB1404_S_NODE_4128_length_160_cov_3.600000_g4108_i0 PRJEB1404 4128 160 3.6 5.76 Bacteriovorax 146784 Bacteria Bacteria 228 2.0499999999999995e-55   NTclustered gi|1700689994|gb|CP030035.1| 960 g4108 i0 96.377 14.2625 138 5 90 0 23 160 1661647 1661510 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 2282 228 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
19146601 19146601 PRJEB1404_P_NODE_856_length_341_cov_3.358065_g832_i0 PRJEB1404 856 341 3.358065 11.45100165 Bacteriovorax stolpii 960 Bacteria Bacteria 571 1.9999999999999993e-158   NTclustered gi|1700689994|gb|CP030035.1| 960 g832 i0 97.05 216.642228739003 339 10 99 0 3 341 1661307 1661645 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 73875 571 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
21387842 21387842 PRJEB1404_S_NODE_57_length_531_cov_59.296371_g40_i0 PRJEB1404 57 531 59.296371 314.86373001 Bacteriovorax 146784 Bacteria Bacteria 505 3.33e-138   NTclustered gi|1700689994|gb|CP030035.1| 960 g40 i0 86.229 142.779661016949 472 57 88 8 14 481 1660343 1660810 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 75816 505 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii

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