RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA608894" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA608894 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
4413152 4413152 PRJNA608894_P_NODE_4424_length_1473_cov_10.222143_g2531_i2 PRJNA608894 4424 1473 10.222143 150.57216639 Deinococcus grandis 57498 Bacteria Bacteria 2058 0   NTclustered gi|1751874559|dbj|AP021851.1| 57498 g2531 i2 92.011 323.082824168364 1477 101 99 12 4 1473 116907 115441 Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome blastn 475901 2058 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
5689478 5689478 PRJNA608894_P_NODE_54465_length_246_cov_2.190751_g53966_i0 PRJNA608894 54465 246 2.190751 5.38924746 Deinococcus aquaticus 328692 Bacteria Bacteria 204 5.799999999999998e-48   NTclustered gi|2444120906|gb|CP115165.1| 328692 g53966 i0 88.372 5.67479674796748 172 17 69 3 77 246 1060450 1060280 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 1396 204 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
13339734 13339734 PRJNA608894_P_NODE_47291_length_258_cov_1.691892_g46792_i0 PRJNA608894 47291 258 1.691892 4.36508136 Thermus sp. NEB1569 2918899 Bacteria Bacteria 477 3.2699999999999985e-130   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g46792 i0 100 32.406976744186 258 0 100 0 1 258 636875 637132 Thermus sp. NEB1569 chromosome, complete genome blastn 8361 477 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
13339777 13339777 PRJNA608894_P_NODE_49531_length_252_cov_1.195531_g49032_i0 PRJNA608894 49531 252 1.195531 3.01273812 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 438 1.5e-118   NTclustered gi|821341785|gb|CP011389.1| 1309411 g49032 i0 98.016 101.107142857143 252 5 100 0 1 252 1840352 1840603 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 25479 438 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
20987963 20987963 PRJNA608894_P_NODE_45777_length_263_cov_1.621053_g45278_i0 PRJNA608894 45777 263 1.621053 4.26336939 Deinococcus gobiensis 502394 Bacteria Bacteria 315 2.77e-81   NTclustered gi|379998737|gb|CP002191.1| 745776 g45278 i0 88.213 11.5893536121673 263 31 100 0 1 263 2287044 2287306 Deinococcus gobiensis I-0, complete genome blastn 3048 315 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis

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