RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA896973" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA896973 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1244045 1244045 PRJNA896973_S_NODE_2221_length_266_cov_3.606218_g2207_i0 PRJNA896973 2221 266 3.606218 9.59253988 Deinococcus 1298 Bacteria Bacteria 302 2.1900000000000002e-77   NTclustered gi|2890656794|gb|CP177253.1| 367282 g2207 i0 98.256 42.0300751879699 172 3 82 0 1 172 13156 13327 Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP1, complete sequence blastn 11180 302 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
6348058 6348058 PRJNA896973_S_NODE_1665_length_301_cov_3.741228_g1651_i0 PRJNA896973 1665 301 3.741228 11.26109628 Deinococcus 1298 Bacteria Bacteria 545 1.0499999999999999e-150   NTclustered gi|1435319096|gb|CP031163.1| 980427 g1651 i0 99.336 52.6112956810631 301 2 100 0 1 301 177839 178139 Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence blastn 15836 545 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
12723560 12723560 PRJNA896973_P_NODE_29130_length_213_cov_9.492857_g29036_i0 PRJNA896973 29130 213 9.492857 20.21978541 root 1 Root_unresolved Root_unresolved 394 2.7e-105   NTclustered gi|2444916559|dbj|LC733524.2| 47478 g29036 i0 100 106.042253521127 213 0 100 0 1 213 1344 1132 Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence blastn 22587 394 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
16176052 16176052 PRJNA896973_P_NODE_28193_length_241_cov_0.916667_g28099_i0 PRJNA896973 28193 241 0.916667 2.20916747 Deinococcus actinosclerus 1768108 Bacteria Bacteria 372 1.47e-98   NTclustered gi|972944657|gb|CP013910.1| 1768108 g28099 i0 95.359 1.77178423236515 237 5 98 2 1 237 2130147 2130377 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 427 372 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
16546553 16546553 PRJNA896973_P_NODE_3933_length_516_cov_6.749436_g3839_i0 PRJNA896973 3933 516 6.749436 34.82708976 Deinococcus 1298 Bacteria Bacteria 939 0   NTclustered gi|730601855|gb|CP010028.1| 57497 g3839 i0 99.804 219.12984496124 511 1 99 0 1 511 70050 69540 Deinococcus swuensis strain DY59, complete genome blastn 113071 939 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
22549785 22549785 PRJNA896973_P_NODE_10838_length_333_cov_4.538462_g10744_i0 PRJNA896973 10838 333 4.538462 15.11307846 Deinococcus grandis 57498 Bacteria Bacteria 604 1.9199999999999991e-168   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g10744 i0 99.399 234.474474474474 333 2 100 0 1 333 73693 74025 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 78080 604 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
22921722 22921722 PRJNA896973_S_NODE_578_length_487_cov_4.615942_g564_i0 PRJNA896973 578 487 4.615942 22.47963754 Deinococcus 1298 Bacteria Bacteria 337 1.1699999999999996e-87   NTclustered gi|1435319096|gb|CP031163.1| 980427 g564 i0 92.116 30.7782340862423 241 15 49 4 1 239 585509 585747 Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence blastn 14989 337 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
23825346 23825346 PRJNA896973_P_NODE_22079_length_250_cov_2.384181_g21985_i0 PRJNA896973 22079 250 2.384181 5.9604525 Deinococcus grandis 57498 Bacteria Bacteria 440 4.1399999999999976e-119   NTclustered gi|1751874559|dbj|AP021851.1| 57498 g21985 i0 98.4 194.932 250 4 100 0 1 250 116811 116562 Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome blastn 48733 440 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);;