RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA682078" 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

  • PRJNA682078 · 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
26638892 26638892 PRJNA682078_P_NODE_244021_length_248_cov_0.880000_g242244_i0 PRJNA682078 244021 248 0.88 2.1824 Parachlamydiaceae bacterium 2052176 Bacteria Bacteria 60.1 2.74e-8   NR MEI8365171.1 2052176 g242244 i0 60 0.544354838709677 45 16 52 1 119 247 11 55 MEI8365171.1 hypothetical protein [Parachlamydiaceae bacterium] diamond 135 60.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   Parachlamydiaceae bacterium
27335101 27335101 PRJNA682078_P_NODE_226003_length_251_cov_0.865169_g224226_i0 PRJNA682078 226003 251 0.865169 2.17157419 Chlamydiales bacterium 2047757 Bacteria Bacteria 71.6 2.62e-12   NR MFI5343006.1 2047757 g224226 i0 42.2 0.99203187250996006 83 47 98 1 1 246 242 324 MFI5343006.1 hypothetical protein [Chlamydiales bacterium] diamond 249 71.6 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
27650883 27650883 PRJNA682078_P_NODE_251664_length_247_cov_0.885057_g249887_i0 PRJNA682078 251664 247 0.885057 2.18609079 Chlamydiota bacterium 2081524 Bacteria Bacteria 54.7 2.51e-6   NR MCC6128156.1 2081524 g249887 i0 40 1.5668016194332 65 39 78.9 0 4 198 1131 1195 MCC6128156.1 hypothetical protein [Chlamydiota bacterium] diamond 387 54.7 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
30777252 30777252 PRJNA682078_P_NODE_231194_length_250_cov_0.870056_g229417_i0 PRJNA682078 231194 250 0.870056 2.17514 Candidatus Protochlamydia naegleriophila 389348 Bacteria Bacteria 112 9.44e-27   NR WP_059061894.1 389348 g229417 i0 62.5 0.96 80 29 94.8 1 249 13 290 369 WP_059061894.1 transcription-repair coupling factor [Candidatus Protochlamydia naegleriophila] diamond 240 112 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia naegleriophila
31472704 31472704 PRJNA682078_P_NODE_199056_length_263_cov_2.300000_g197279_i0 PRJNA682078 199056 263 2.3 6.049 Parachlamydiaceae bacterium 2052176 Bacteria Bacteria 58.2 3.3e-8   NR HEV8051030.1 2052176 g197279 i0 67.6 0.422053231939163 37 12 42.2 0 153 263 3 39 HEV8051030.1 hypothetical protein [Parachlamydiaceae bacterium] diamond 111 58.2 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   Parachlamydiaceae bacterium
32232040 32232040 PRJNA682078_P_NODE_165618_length_283_cov_1.857143_g163841_i0 PRJNA682078 165618 283 1.857143 5.25571469 Chlamydiota bacterium 2081524 Bacteria Bacteria 54.3 5.17e-6   NR MEM1283013.1 2081524 g163841 i0 28.6 3.8904593639576 98 63 99.6 2 1 282 143 237 MEM1283013.1 6-hydroxymethylpterin diphosphokinase MptE-like protein [Chlamydiota bacterium] diamond 1101 54.3 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);;