RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA1103784" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1103784 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
212158 212158 PRJNA1103784_P_NODE_4141_length_279_cov_1.912621_g4086_i0 PRJNA1103784 4141 279 1.912621 5.33621259 Deinococcus yunweiensis 367282 Bacteria Bacteria 438 1.6899999999999996e-118   NTclustered gi|2890653062|gb|CP177252.1| 367282 g4086 i0 95.018 199.089605734767 281 10 100 3 1 279 2671401 2671679 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 55546 438 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
2295619 2295619 PRJNA1103784_P_NODE_3382_length_300_cov_1.563877_g3327_i0 PRJNA1103784 3382 300 1.563877 4.691631 Deinococcus 1298 Bacteria Bacteria 484 2.32e-132   NTclustered gi|470486828|ref|NR_076782.1| 502394 g3327 i0 95.973 183.486666666667 298 12 99 0 1 298 625 328 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 55046 484 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
2295640 2295640 PRJNA1103784_P_NODE_8102_length_228_cov_2.006452_g8047_i0 PRJNA1103784 8102 228 2.006452 4.57471056 Thermus 270 Bacteria Bacteria 411 2.909999999999999e-110   NTclustered gi|320149275|gb|CP001962.1| 743525 g8047 i0 99.123 43.5964912280702 228 2 100 0 1 228 2066250 2066023 Thermus scotoductus SA-01, complete genome blastn 9940 411 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
2762846 2762846 PRJNA1103784_P_NODE_4403_length_274_cov_1.462687_g4348_i0 PRJNA1103784 4403 274 1.462687 4.00776238 Thermus scotoductus 37636 Bacteria Bacteria 484 2.0899999999999994e-132   NTclustered gi|320149275|gb|CP001962.1| 743525 g4348 i0 98.54 3.67518248175182 274 4 100 0 1 274 446636 446909 Thermus scotoductus SA-01, complete genome blastn 1007 484 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
3570689 3570689 PRJNA1103784_P_NODE_1203_length_461_cov_4.201031_g1148_i0 PRJNA1103784 1203 461 4.201031 19.36675291 Deinococcus 1298 Bacteria Bacteria 791 0   NTclustered gi|470486828|ref|NR_076782.1| 502394 g1148 i0 97.614 372.986984815618 461 11 100 0 1 461 1433 973 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 171947 791 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
6590182 6590182 PRJNA1103784_P_NODE_2206_length_359_cov_1.339161_g2151_i0 PRJNA1103784 2206 359 1.339161 4.80758799 Thermus sp. NEB1569 2918899 Bacteria Bacteria 664 0   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g2151 i0 100 149.284122562674 359 0 100 0 1 359 410155 410513 Thermus sp. NEB1569 chromosome, complete genome blastn 53593 664 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
9139784 9139784 PRJNA1103784_P_NODE_7328_length_243_cov_0.905882_g7273_i0 PRJNA1103784 7328 243 0.905882 2.20129326 Thermus sp. NEB1569 2918899 Bacteria Bacteria 449 6.65e-122   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g7273 i0 100 70.9094650205761 243 0 100 0 1 243 1919807 1920049 Thermus sp. NEB1569 chromosome, complete genome blastn 17231 449 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
9948364 9948364 PRJNA1103784_P_NODE_5928_length_250_cov_0.870056_g5873_i0 PRJNA1103784 5928 250 0.870056 2.17514 Thermus 270 Bacteria Bacteria 302 2.04e-77   NTclustered gi|320149275|gb|CP001962.1| 743525 g5873 i0 88.538 31.012 253 23 100 6 1 250 939299 939548 Thermus scotoductus SA-01, complete genome blastn 7753 302 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
10415509 10415509 PRJNA1103784_P_NODE_2989_length_315_cov_1.776860_g2934_i0 PRJNA1103784 2989 315 1.77686 5.597109 Thermus sp. NEB1569 2918899 Bacteria Bacteria 577 3.9299999999999986e-160   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g2934 i0 99.683 43.2920634920635 315 1 100 0 1 315 1244775 1244461 Thermus sp. NEB1569 chromosome, complete genome blastn 13637 577 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
10415564 10415564 PRJNA1103784_P_NODE_5329_length_256_cov_1.633880_g5274_i0 PRJNA1103784 5329 256 1.63388 4.1827328 Thermus aquaticus 271 Bacteria Bacteria 457 4.22e-124   NTclustered gi|939575972|gb|CP010822.1| 498848 g5274 i0 98.828 19.91015625 256 3 100 0 1 256 812695 812950 Thermus aquaticus Y51MC23, complete genome blastn 5097 457 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
11690839 11690839 PRJNA1103784_P_NODE_4910_length_264_cov_2.340314_g4855_i0 PRJNA1103784 4910 264 2.340314 6.17842896 Thermus scotoductus 37636 Bacteria Bacteria 488 1.5499999999999999e-133   NTclustered gi|320149275|gb|CP001962.1| 743525 g4855 i0 100 40.8257575757576 264 0 100 0 1 264 897002 897265 Thermus scotoductus SA-01, complete genome blastn 10778 488 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
11690894 11690894 PRJNA1103784_P_NODE_8230_length_198_cov_4.320000_g8175_i0 PRJNA1103784 8230 198 4.32 8.5536 Thermus sp. NEB1569 2918899 Bacteria Bacteria 366 5.4e-97   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g8175 i0 100 45.989898989899 198 0 100 0 1 198 141564 141761 Thermus sp. NEB1569 chromosome, complete genome blastn 9106 366 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
13773525 13773525 PRJNA1103784_P_NODE_871_length_528_cov_2.325275_g816_i0 PRJNA1103784 871 528 2.325275 12.277452 Thermus 270 Bacteria Bacteria 961 0   NTclustered gi|1236765911|gb|MF359428.1| 275 g816 i0 99.62 101.808712121212 526 2 99 0 1 526 544 19 Thermus sp. strain InS-183 16S ribosomal RNA gene, partial sequence blastn 53755 968 0.992768595041322 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
17597884 17597884 PRJNA1103784_P_NODE_8134_length_226_cov_2.065359_g8079_i0 PRJNA1103784 8134 226 2.065359 4.66771134 Deinococcus 1298 Bacteria Bacteria 396 8.069999999999997e-106   NTclustered gi|730601855|gb|CP010028.1| 57497 g8079 i0 98.23 192.694690265487 226 4 100 0 1 226 71751 71526 Deinococcus swuensis strain DY59, complete genome blastn 43549 396 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
21422203 21422203 PRJNA1103784_P_NODE_7697_length_241_cov_1.994048_g7642_i0 PRJNA1103784 7697 241 1.994048 4.80565568 Thermus 270 Bacteria Bacteria 401 1.8699999999999993e-107   NTclustered gi|320149275|gb|CP001962.1| 743525 g7642 i0 96.68 44.298755186722 241 8 100 0 1 241 1857684 1857924 Thermus scotoductus SA-01, complete genome blastn 10676 401 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
21888983 21888983 PRJNA1103784_P_NODE_7858_length_241_cov_0.916667_g7803_i0 PRJNA1103784 7858 241 0.916667 2.20916747 Thermus brockianus 56956 Bacteria Bacteria 387 5.24e-103   NTclustered gi|2199615985|dbj|AP025593.1| 56956 g7803 i0 95.816 32.9377593360996 239 10 99 0 3 241 776362 776124 Thermus brockianus SNM4-1 DNA, complete genome blastn 7938 387 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus
24438050 24438050 PRJNA1103784_P_NODE_5380_length_255_cov_1.670330_g5325_i0 PRJNA1103784 5380 255 1.67033 4.2593415 Thermus sp. NEB1569 2918899 Bacteria Bacteria 472 1.5e-128   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g5325 i0 100 8.00392156862745 255 0 100 0 1 255 1235747 1235493 Thermus sp. NEB1569 chromosome, complete genome blastn 2041 472 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
25246545 25246545 PRJNA1103784_P_NODE_7580_length_242_cov_0.911243_g7525_i0 PRJNA1103784 7580 242 0.911243 2.20520806 Thermus 270 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|320149275|gb|CP001962.1| 743525 g7525 i0 100 51.2148760330578 242 0 100 0 1 242 585612 585853 Thermus scotoductus SA-01, complete genome blastn 12394 448 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus

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