RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA293022 · 6 ✖

analysis 1

  • blastn · 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
1059793 1059793 PRJNA293022_P_NODE_69881_length_167_cov_2.610169_g69144_i0 PRJNA293022 69881 167 2.610169 4.35898223 Chlamydia 810 Bacteria Bacteria 224 2.81e-54   NTclustered gi|2160499992|gb|CP042720.1| 813 g69144 i0 91.463 196.02994011976 164 13 98 1 4 166 138339 138176 Chlamydia trachomatis strain TC0080-IGR-TC0081::TncL2/tetR-1645 chromosome, complete genome blastn 32737 226 0.991150442477876 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia trachomatis
1648059 1648059 PRJNA293022_P_NODE_44242_length_210_cov_0.950311_g43505_i0 PRJNA293022 44242 210 0.950311 1.9956531 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 257 3.64e-64   NTclustered gi|2874253811|emb|OY969795.1| 464461 g43505 i0 89.048 158.795238095238 210 20 99 3 2 210 654547 654340 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 33347 257 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
4200587 4200587 PRJNA293022_P_NODE_72864_length_166_cov_0.888889_g72127_i0 PRJNA293022 72864 166 0.888889 1.47555574 Candidatus Protochlamydia naegleriophila 389348 Bacteria Bacteria 198 1.69e-46   NTclustered gi|971146634|emb|LN879502.1| 389348 g72127 i0 89.241 140.096385542169 158 17 95 0 7 164 1251332 1251175 Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK blastn 23256 198 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia naegleriophila
20774712 20774712 PRJNA293022_P_NODE_31397_length_250_cov_1.422886_g30660_i0 PRJNA293022 31397 250 1.422886 3.557215 Simkania negevensis 83561 Bacteria Bacteria 346 9.269999999999999e-91   NTclustered gi|357575872|gb|HQ684730.1| 83561 g30660 i0 93.562 150.964 233 14 93 1 17 249 670 439 Simkania negevensis strain FH07_17_16 23S ribosomal RNA gene, partial sequence blastn 37741 346 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania negevensis
21461405 21461405 PRJNA293022_P_NODE_14857_length_371_cov_1.596273_g14120_i0 PRJNA293022 14857 371 1.596273 5.92217283 Candidatus Rhabdochlamydia 292833 Bacteria Bacteria 348 4.020000000000001e-91   NTclustered gi|2082223669|gb|CP075585.1| 225148 g14120 i0 84.196 319.913746630728 367 49 98 8 3 366 1019991 1019631 Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome blastn 118688 351 0.991452991452991 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae Candidatus Rhabdochlamydia Candidatus Rhabdochlamydia porcellionis
22049860 22049860 PRJNA293022_P_NODE_66618_length_170_cov_0.851240_g65881_i0 PRJNA293022 66618 170 0.85124 1.447108 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 272 9.999999999999999e-69   NTclustered gi|2874253811|emb|OY969795.1| 464461 g65881 i0 95.858 174.876470588235 169 6 99 1 3 170 2059217 2059385 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 29729 272 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae 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);;