RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA577580 · 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
1839532 1839532 PRJNA577580_P_NODE_4722_length_412_cov_2.463127_g4644_i0 PRJNA577580 4722 412 2.463127 10.14808324 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 534 3.22e-147   NTclustered gi|2874253811|emb|OY969795.1| 464461 g4644 i0 90.097 108.296116504854 414 37 99 4 1 410 657252 656839 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 44618 534 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
16440810 16440810 PRJNA577580_P_NODE_14153_length_250_cov_2.316384_g14075_i0 PRJNA577580 14153 250 2.316384 5.79096 Bacteria 2 Bacteria Bacteria 351 1.99e-92   NTclustered gi|2874253811|emb|OY969795.1| 464461 g14075 i0 93.033 187.908 244 12 97 3 9 250 654422 654662 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 46977 351 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
20966160 20966160 PRJNA577580_P_NODE_10257_length_286_cov_3.267606_g10179_i0 PRJNA577580 10257 286 3.267606 9.34535316 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 339 1.8099999999999997e-88   NTclustered gi|2874253811|emb|OY969795.1| 464461 g10179 i0 89.011 161.405594405594 273 30 100 0 13 285 2060075 2059803 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 46162 339 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
22241103 22241103 PRJNA577580_P_NODE_1218_length_812_cov_4.719892_g1151_i0 PRJNA577580 1218 812 4.719892 38.32552304 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 981 0   NTclustered gi|2874253811|emb|OY969795.1| 464461 g1151 i0 88.93 192.454433497537 804 78 98 11 1 796 654603 655403 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 156273 981 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);;