RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA785164 · 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
7145252 7145252 PRJNA785164_P_NODE_63246_length_234_cov_2.310559_g62781_i0 PRJNA785164 63246 234 2.310559 5.40670806 Deinococcus radiopugnans 57497 Bacteria Bacteria 427 2.9799999999999993e-115   NTclustered gi|730601855|gb|CP010028.1| 57497 g62781 i0 99.573 169.128205128205 234 1 100 0 1 234 69339 69106 Deinococcus swuensis strain DY59, complete genome blastn 39576 427 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
17344269 17344269 PRJNA785164_P_NODE_32854_length_317_cov_2.245902_g32389_i0 PRJNA785164 32854 317 2.245902 7.11950934 Deinococcus sp. AJ005 2652443 Bacteria Bacteria 580 3.0599999999999993e-161   NTclustered gi|1761809830|gb|CP044990.1| 2652443 g32389 i0 99.685 243.094637223975 317 1 100 0 1 317 201358 201674 Deinococcus sp. AJ005 chromosome, complete genome blastn 77061 580 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AJ005
21615749 21615749 PRJNA785164_P_NODE_43957_length_272_cov_1.105528_g43492_i0 PRJNA785164 43957 272 1.105528 3.00703616 Deinococcus 1298 Bacteria Bacteria 459 1.2599999999999999e-124   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g43492 i0 97.059 221.268382352941 272 8 100 0 1 272 73253 72982 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 60185 459 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis

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