RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA379145 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
8726765 8726765 PRJNA379145_P_NODE_69927_length_160_cov_1.165354_g67773_i0 PRJNA379145 69927 160 1.165354 1.8645664 Pseudomonadati 3379134 Bacteria Bacteria 246 5.67e-61   NTclustered gi|2082223669|gb|CP075585.1| 225148 g67773 i0 94.41 115.24375 161 8 100 1 1 160 1018206 1018046 Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome blastn 18439 246 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Rhabdochlamydiaceae Candidatus Rhabdochlamydia Candidatus Rhabdochlamydia porcellionis
9329017 9329017 PRJNA379145_P_NODE_46208_length_256_cov_1.735426_g44055_i0 PRJNA379145 46208 256 1.735426 4.44269056 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 318 2.0799999999999998e-82   NTclustered gi|2874253811|emb|OY969795.1| 464461 g44055 i0 89.272 102.2890625 261 18 99 9 1 254 655135 655392 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 26186 318 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
20802554 20802554 PRJNA379145_P_NODE_66177_length_169_cov_1.691176_g64023_i0 PRJNA379145 66177 169 1.691176 2.85808744 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 172 1.04e-38   NTclustered gi|2874253811|emb|OY969795.1| 464461 g64023 i0 87.417 164.650887573964 151 17 89 2 20 169 655039 654890 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 27826 172 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
23353043 23353043 PRJNA379145_P_NODE_57939_length_197_cov_1.378049_g55785_i0 PRJNA379145 57939 197 1.378049 2.71475653 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 52.8 0.017   NTclustered gi|2874253811|emb|OY969795.1| 464461 g55785 i0 100 0.142131979695431 28 0 14 0 81 108 1011251 1011278 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 28 52.8 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);;