RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA527965" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA527965 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 0

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
9425153 9425153 PRJNA527965_S_NODE_468_length_485_cov_185.513333_g386_i0 PRJNA527965 468 485 185.513333 899.73966505 Trueperaceae bacterium 2026798 Bacteria Bacteria 496 1.82e-135   NTclustered gi|2621706202|emb|OY764543.1| 2026798 g386 i0 85.805 588.919587628866 472 61 96 6 1 468 2559641 2559172 MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1 blastn 285626 496 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
9425182 9425182 PRJNA527965_S_NODE_668_length_430_cov_10.746835_g586_i0 PRJNA527965 668 430 10.746835 46.2113905 Deinococcus actinosclerus 1768108 Bacteria Bacteria 795 0   NTclustered gi|972944657|gb|CP013910.1| 1768108 g586 i0 100 275.960465116279 430 0 100 0 1 430 74302 74731 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 118663 795 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
11317465 11317465 PRJNA527965_S_NODE_1289_length_334_cov_28.816054_g1206_i0 PRJNA527965 1289 334 28.816054 96.24562036 Deinococcus 1298 Bacteria Bacteria 577 4.199999999999999e-160   NTclustered gi|470483488|ref|NR_076595.1| 310783 g1206 i0 99.371 379.910179640719 318 2 95 0 1 318 2550 2233 Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence blastn 126890 577 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus deserti
19622863 19622863 PRJNA527965_S_NODE_176_length_699_cov_36.644578_g120_i0 PRJNA527965 176 699 36.644578 256.14560022 Deinococcus actinosclerus 1768108 Bacteria Bacteria 780 0   NTclustered gi|972944657|gb|CP013910.1| 1768108 g120 i0 89.274 182.296137339056 634 53 90 12 1 629 74232 73609 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 127425 780 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus

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