RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB9859", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJEB9859 · 6 ✖

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
13752430 13752430 PRJEB9859_P_NODE_1271_length_367_cov_3.192308_g1237_i0 PRJEB9859 1271 367 3.192308 11.71577036 Myxococcaceae bacterium 2484252 Bacteria Bacteria 123 1.5999999999999999e-31   NR HLL04251.1 2484252 g1237 i0 46.2 0.97275204359673 119 64 97.3 0 358 2 16 134 HLL04251.1 hypothetical protein [Myxococcaceae bacterium] diamond 357 123 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
18850712 18850712 PRJEB9859_P_NODE_4875_length_246_cov_1.023041_g4840_i0 PRJEB9859 4875 246 1.023041 2.51668086 Pseudomonadati 3379134 Bacteria Bacteria 69.4 2.21e-7   NTclustered gi|827418478|gb|CP011509.1| 48 g4840 i0 97.5 15.0528455284553 40 1 16 0 207 246 11828489 11828450 Archangium gephyra strain DSM 2261, complete genome blastn 3703 69.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
26686038 26686038 PRJEB9859_P_NODE_3121_length_278_cov_1.642570_g3086_i0 PRJEB9859 3121 278 1.64257 4.5663446 Myxococcaceae bacterium 2484252 Bacteria Bacteria 100 2.38e-22   NR HLL04250.1 2484252 g3086 i0 52.6 0.841726618705036 78 37 84.2 0 273 40 168 245 HLL04250.1 metallophosphoesterase [Myxococcaceae bacterium] diamond 234 100 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
27160499 27160499 PRJEB9859_P_NODE_4422_length_249_cov_1.918182_g4387_i0 PRJEB9859 4422 249 1.918182 4.77627318 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 53.1 4.12e-6   NR MBP42859.1 2026735 g4387 i0 56 1.78313253012048 50 22 60.2 0 208 59 24 73 MBP42859.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 444 53.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29939758 29939758 PRJEB9859_P_NODE_551_length_462_cov_3.011547_g524_i0 PRJEB9859 551 462 3.011547 13.91334714 Myxococcaceae bacterium 2484252 Bacteria Bacteria 112 1.33e-26   NR HLL04251.1 2484252 g524 i0 39 0.883116883116883 136 83 88.3 0 410 3 132 267 HLL04251.1 hypothetical protein [Myxococcaceae bacterium] diamond 408 112 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
32184116 32184116 PRJEB9859_P_NODE_3258_length_274_cov_1.400000_g3223_i0 PRJEB9859 3258 274 1.4 3.836 Myxococcaceae bacterium 2484252 Bacteria Bacteria 79.3 6.9e-15   NR HLL04250.1 2484252 g3223 i0 66.7 0.525547445255474 48 16 52.6 0 194 51 1 48 HLL04250.1 metallophosphoesterase [Myxococcaceae bacterium] diamond 144 79.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae 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);;