RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB81171 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
2689378 2689378 PRJEB81171_P_NODE_10123_length_237_cov_3.310976_g9996_i0 PRJEB81171 10123 237 3.310976 7.84701312 Gemmatirosa sp. 2510638 Bacteria Bacteria 117 1.59e-30   NR HEY0780241.1 2510638 g9996 i0 91.4 1.48101265822785 58 5 73.4 0 64 237 13 70 HEY0780241.1 DUF72 domain-containing protein [Gemmatirosa sp.] diamond 351 117 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa sp.
26970849 26970849 PRJEB81171_P_NODE_3062_length_376_cov_4.617162_g2935_i0 PRJEB81171 3062 376 4.617162 17.36052912 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 97.4 5.980000000000001e-21   NR HEU5042096.1 2448054 g2935 i0 73.8 0.638297872340426 80 18 63 2 27 263 310 387 HEU5042096.1 HD domain-containing protein [Gemmatimonadales bacterium] diamond 240 97.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29529087 29529087 PRJEB81171_P_NODE_4250_length_322_cov_1.574297_g4123_i0 PRJEB81171 4250 322 1.574297 5.06923634 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 133 5.969999999999999e-37   NR MDH3455568.1 2026742 g4123 i0 59.8 0.996894409937888 107 43 99.7 0 2 322 25 131 MDH3455568.1 hypoxanthine phosphoribosyltransferase [Gemmatimonadota bacterium] diamond 321 133 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29718157 29718157 PRJEB81171_P_NODE_7590_length_253_cov_1.950000_g7463_i0 PRJEB81171 7590 253 1.95 4.9335 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 105 4.92e-24   NR MDP1858278.1 2026741 g7463 i0 66.3 0.984189723320158 83 28 98.4 0 250 2 488 570 MDP1858278.1 protein kinase [Gemmatimonadaceae bacterium] diamond 249 105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;