RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB14664", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 7 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJEB14664 · 7 ✖

analysis 1

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
19146803 19146803 PRJEB14664_P_NODE_7436_length_295_cov_2.861538_g7306_i0 PRJEB14664 7436 295 2.861538 8.4415371 Simkania sp. 34094 Bacteria Bacteria 168 2.68e-51   NR MCB1084350.1 34094 g7306 i0 81.1 1.93220338983051 95 18 96.6 0 9 293 1 95 MCB1084350.1 MC/SLC25 family protein [Simkania sp.] diamond 570 168 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
27279666 27279666 PRJEB14664_P_NODE_8223_length_277_cov_1.487603_g8093_i0 PRJEB14664 8223 277 1.487603 4.12066031 Pseudomonadati 3379134 Bacteria Bacteria 161 2.39e-44   NR MBN4067489.1 83561 g8093 i0 78.3 21.9314079422383 92 20 99.6 0 1 276 151 242 MBN4067489.1 phosphoenolpyruvate carboxykinase (GTP) [Simkania negevensis] diamond 6075 161 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania negevensis
27538722 27538722 PRJEB14664_P_NODE_784_length_1023_cov_3.206478_g718_i0 PRJEB14664 784 1023 3.206478 32.80226994 Simkania sp. 34094 Bacteria Bacteria 258 1.98e-81   NR MCB1084310.1 34094 g718 i0 75.3 0.498533724340176 170 42 49.9 0 757 248 1 170 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 510 258 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
28580668 28580668 PRJEB14664_P_NODE_3367_length_488_cov_3.150110_g3243_i0 PRJEB14664 3367 488 3.15011 15.3725368 Chlamydiales bacterium 2047757 Bacteria Bacteria 273 1.66e-91   NR MCP5470421.1 2047757 g3243 i0 82.9 0.971311475409836 158 27 97.1 0 483 10 1 158 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 474 273 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
29622059 29622059 PRJEB14664_P_NODE_5490_length_358_cov_2.495356_g5360_i0 PRJEB14664 5490 358 2.495356 8.93337448 Chlamydiales bacterium 2047757 Bacteria Bacteria 188 6.59e-59   NR MCP5470420.1 2047757 g5360 i0 83.2 0.99720670391061506 119 18 99.7 1 357 1 4 120 MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium] diamond 357 188 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
32436138 32436138 PRJEB14664_P_NODE_13459_length_196_cov_1.987578_g13329_i0 PRJEB14664 13459 196 1.987578 3.89565288 Chlamydiales bacterium 2047757 Bacteria Bacteria 109 1.04e-28   NR MCP5470421.1 2047757 g13329 i0 81.3 0.979591836734694 64 12 98 0 194 3 58 121 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 192 109 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
32814289 32814289 PRJEB14664_P_NODE_11540_length_219_cov_1.521739_g11410_i0 PRJEB14664 11540 219 1.521739 3.33260841 Chlamydiales bacterium 2047757 Bacteria Bacteria 86.3 2.45e-19   NR MCP5470421.1 2047757 g11410 i0 52.8 3.89041095890411 72 34 98.6 0 217 2 48 119 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 852 86.3 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales 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);;