RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA642647 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
1158576 1158576 PRJNA642647_P_NODE_6101_length_155_cov_0.813559_g6051_i0 PRJNA642647 6101 155 0.813559 1.26101645 Candidatus Protochlamydia 282132 Bacteria Bacteria 143 7.349999999999998e-30   NTclustered gi|1691252667|emb|BX908798.2| 264201 g6051 i0 83.893 158.490322580645 149 24 96 0 1 149 1249865 1250013 Candidatus Protochlamydia amoebophila UWE25 complete genome blastn 24566 143 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia amoebophila
4445683 4445683 PRJNA642647_P_NODE_4324_length_174_cov_2.182482_g4274_i0 PRJNA642647 4324 174 2.182482 3.79751868 uncultured Chlamydiales bacterium 174324 Bacteria Bacteria 228 2.2699999999999997e-55   NTclustered gi|880804004|gb|KT258829.1| 174324 g4274 i0 91.071 96.948275862069 168 15 97 0 7 174 81 248 Uncultured Chlamydiales bacterium clone CD47 16S ribosomal RNA gene, partial sequence blastn 16869 228 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     uncultured Chlamydiales bacterium
8811491 8811491 PRJNA642647_P_NODE_5947_length_156_cov_2.302521_g5897_i0 PRJNA642647 5947 156 2.302521 3.59193276 Parachlamydia 83551 Bacteria Bacteria 255 9.12e-64   NTclustered gi|470491594|ref|NR_077046.1| 83552 g5897 i0 96.732 196.532051282051 153 5 98 0 4 156 2308 2460 Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence blastn 30659 255 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Parachlamydia Parachlamydia acanthamoebae

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);;