RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA657343" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA657343 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
3173778 3173778 PRJNA657343_P_NODE_21303_length_202_cov_7.496732_g21279_i0 PRJNA657343 21303 202 7.496732 15.14339864 Deinococcus actinosclerus 1768108 Bacteria Bacteria 294 2.65e-75   NTclustered gi|972944657|gb|CP013910.1| 1768108 g21279 i0 93.846 198.20297029703 195 12 97 0 4 198 74230 74036 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 40037 294 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
4451695 4451695 PRJNA657343_S_NODE_22384_length_190_cov_4.198582_g22359_i0 PRJNA657343 22384 190 4.198582 7.9773058 Deinococcus peraridilitoris 432329 Bacteria Bacteria 167 5.589999999999999e-37   NTclustered gi|429128598|gb|CP003382.1| 937777 g22359 i0 82.915 65.6526315789474 199 20 99 10 2 190 1140573 1140379 Deinococcus peraridilitoris DSM 19664, complete genome blastn 12474 167 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
5727302 5727302 PRJNA657343_S_NODE_23825_length_184_cov_2.074074_g23800_i0 PRJNA657343 23825 184 2.074074 3.81629616 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 315 1.81e-81   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g23800 i0 97.802 222.25 182 4 99 0 3 184 56684 56503 Deinococcus sp. AB2017081 chromosome, complete genome blastn 40894 315 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
18476400 18476400 PRJNA657343_S_NODE_29275_length_164_cov_5.391304_g29250_i0 PRJNA657343 29275 164 5.391304 8.84173856 Deinococcus grandis 57498 Bacteria Bacteria 289 9.59e-74   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g29250 i0 98.773 100.408536585366 163 1 99 1 2 164 20464 20303 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 16467 289 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
19750853 19750853 PRJNA657343_S_NODE_25016_length_179_cov_2.007692_g24991_i0 PRJNA657343 25016 179 2.007692 3.59376868 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 331 1.74e-86   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g24991 i0 100 161.005586592179 179 0 100 0 1 179 58244 58066 Deinococcus sp. AB2017081 chromosome, complete genome blastn 28820 331 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
25386835 25386835 PRJNA657343_P_NODE_14560_length_233_cov_4.021739_g14536_i0 PRJNA657343 14560 233 4.021739 9.37065187 Deinococcus 1298 Bacteria Bacteria 265 2.4599999999999996e-66   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g14536 i0 99.315 275.18025751073 146 1 64 0 82 227 3060990 3061135 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 64117 265 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
25386890 25386890 PRJNA657343_S_NODE_16020_length_226_cov_3.333333_g15995_i0 PRJNA657343 16020 226 3.333333 7.53333258 Deinococcus 1298 Bacteria Bacteria 416 6.189999999999998e-112   NTclustered gi|1192789104|gb|KY744731.1| 47478 g15995 i0 100 101.548672566372 225 0 99 0 1 225 414 190 Deinococcus sp. strain 16B18A 16S ribosomal RNA gene, partial sequence blastn 22950 416 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.

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