RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA782551 · 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
9692007 9692007 PRJNA782551_P_NODE_13208_length_269_cov_1.566327_g13086_i0 PRJNA782551 13208 269 1.566327 4.21341963 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 414 2.73e-111   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g13086 i0 94.424 163.189591078067 269 15 100 0 1 269 543461 543193 Deinococcus sp. NW-56 chromosome, complete genome blastn 43898 414 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
13517541 13517541 PRJNA782551_P_NODE_25051_length_241_cov_0.916667_g24929_i0 PRJNA782551 25051 241 0.916667 2.20916747 Deinococcus sp. VB343 3385567 Bacteria Bacteria 435 1.84e-117   NTclustered gi|2905214251|gb|CP179946.1| 3385567 g24929 i0 99.17 2 241 2 100 0 1 241 361952 362192 Deinococcus sp. VB343 chromosome 2, complete sequence blastn 482 435 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
19890519 19890519 PRJNA782551_P_NODE_20636_length_246_cov_0.890173_g20514_i0 PRJNA782551 20636 246 0.890173 2.18982558 Deinococcus grandis 57498 Bacteria Bacteria 420 5.29e-113   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g20514 i0 97.551 25.109756097561 245 6 99 0 2 246 1747305 1747061 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 6177 420 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
21614815 21614815 PRJNA782551_P_NODE_7657_length_338_cov_0.879245_g7535_i0 PRJNA782551 7657 338 0.879245 2.9718481 Deinococcus 1298 Bacteria Bacteria 569 7.119999999999998e-158   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g7535 i0 98.75 202.056213017751 320 4 98 0 19 338 424023 423704 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 68295 569 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
24990129 24990129 PRJNA782551_P_NODE_18260_length_248_cov_1.348571_g18138_i0 PRJNA782551 18260 248 1.348571 3.34445608 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 292 1.21e-74   NTclustered gi|1435316362|gb|CP031158.1| 980427 g18138 i0 98.204 44.8064516129032 167 3 67 0 1 167 196504 196338 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 11112 292 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis

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