RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1088503" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA1088503 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
4845581 4845581 PRJNA1088503_P_NODE_5784_length_329_cov_93.493333_g5412_i0 PRJNA1088503 5784 329 93.493333 307.59306557 root 1 Root_unresolved Root_unresolved 501 2.56e-137   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g5412 i0 99.635 53.0151975683891 274 1 91 0 28 301 1449 1176 Thermus aquaticus DNA polymerase (PolI) gene blastn 17442 501 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
7395281 7395281 PRJNA1088503_P_NODE_10386_length_181_cov_1.710526_g10014_i0 PRJNA1088503 10386 181 1.710526 3.09605206 Bacteria 2 Bacteria Bacteria 307 2.97e-79   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g10014 i0 100 5.50276243093923 166 0 92 0 16 181 681 516 Thermus aquaticus DNA polymerase (PolI) gene blastn 996 307 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
24420379 24420379 PRJNA1088503_P_NODE_5500_length_343_cov_30031.585987_g5128_i0 PRJNA1088503 5500 343 30031.585987 103008.33993541 Thermus aquaticus 271 Bacteria Bacteria 555 2.0299999999999995e-153   NTclustered gi|507890|dbj|D32013.1|TTHDNAP 271 g5128 i0 99.671 28.8600583090379 304 0 89 1 10 313 2766 2464 Thermus aquaticus gene for DNA polymerase, complete cds blastn 9899 555 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus

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