RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB66218 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
10335675 10335675 PRJEB66218_P_NODE_22749_length_806_cov_2.785235_g20595_i0 PRJEB66218 22749 806 2.785235 22.4489941 Pseudomonadati 3379134 Bacteria Bacteria 321 2.3299999999999997e-106   NR OGN65139.1 1797605 g20595 i0 62.7 9.01861042183623 268 97 99.8 2 804 1 34 298 OGN65139.1 MAG: transaldolase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9] diamond 7269 323 0.993808049535604 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9
17982959 17982959 PRJEB66218_P_NODE_148955_length_242_cov_1.790055_g146526_i0 PRJEB66218 148955 242 1.790055 4.3319331 Chlamydiota bacterium 2081524 Bacteria Bacteria 111 1.9400000000000003e-27   NR NDD59003.1 2081524 g146526 i0 72.2 3.95454545454545 79 21 97.9 1 4 240 141 218 NDD59003.1 2-aminoethylphosphonate--pyruvate transaminase [Chlamydiota bacterium] diamond 957 111 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
26812481 26812481 PRJEB66218_P_NODE_131421_length_260_cov_1.929648_g128992_i0 PRJEB66218 131421 260 1.929648 5.0170848 Waddliaceae bacterium 2026802 Bacteria Bacteria 70.1 4.21e-13   NR HEY4832334.1 2026802 g128992 i0 46.7 0.865384615384615 75 38 86.5 2 253 29 50 122 HEY4832334.1 uL14 family ribosomal protein [Waddliaceae bacterium] diamond 225 70.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Waddliaceae   Waddliaceae bacterium
27160171 27160171 PRJEB66218_P_NODE_196522_length_211_cov_1.733333_g194092_i0 PRJEB66218 196522 211 1.733333 3.65733263 Chlamydiales bacterium SCGC AB-751-O23 1871322 Bacteria Bacteria 64.7 4.35e-10   NR SCA58993.1 1871322 g194092 i0 57.7 0.739336492890995 52 22 73.9 0 164 9 1477 1528 SCA58993.1 hypothetical protein AB751O23_BT_00010, partial [Chlamydiales bacterium SCGC AB-751-O23] diamond 156 64.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium SCGC AB-751-O23
27350316 27350316 PRJEB66218_P_NODE_133843_length_257_cov_3.204082_g131414_i0 PRJEB66218 133843 257 3.204082 8.23449074 Chlamydiales bacterium 2047757 Bacteria Bacteria 86.7 2.83e-19   NR MCP5470420.1 2047757 g131414 i0 51.9 0.898832684824903 77 37 89.9 0 254 24 1 77 MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] diamond 231 86.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
29497228 29497228 PRJEB66218_P_NODE_8310_length_1552_cov_3.796781_g7072_i0 PRJEB66218 8310 1552 3.796781 58.92604112 Chlamydiota bacterium 2081524 Bacteria Bacteria 157 1.5499999999999996e-40   NR MES2273166.1 2081524 g7072 i0 37.5 1.0360824742268 269 132 51.6 8 932 132 18 252 MES2273166.1 DUF268 domain-containing protein [Chlamydiota bacterium] diamond 1608 157 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota 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);;