RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1067443 · 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
1456055 1456055 PRJNA1067443_P_NODE_15122_length_256_cov_1.912568_g15104_i0 PRJNA1067443 15122 256 1.912568 4.89617408 Deinococcus aquaticus 328692 Bacteria Bacteria 342 1.2299999999999997e-89   NTclustered gi|2444120906|gb|CP115165.1| 328692 g15104 i0 90.769 19.71484375 260 19 100 5 1 256 916853 916595 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 5047 342 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
2731847 2731847 PRJNA1067443_P_NODE_123_length_1043_cov_12.976289_g114_i0 PRJNA1067443 123 1043 12.976289 135.34269427 Thermus sp. NEB1569 2918899 Bacteria Bacteria 1604 0   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g114 i0 98.994 44.9664429530201 895 9 100 0 149 1043 500011 499117 Thermus sp. NEB1569 chromosome, complete genome blastn 46900 1604 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
8666588 8666588 PRJNA1067443_P_NODE_11327_length_277_cov_1.813725_g11309_i0 PRJNA1067443 11327 277 1.813725 5.02401825 Deinococcus 1298 Bacteria Bacteria 379 1.03e-100   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g11309 i0 91.606 3.5884476534296 274 23 100 0 1 274 128715 128988 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 994 379 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
12935481 12935481 PRJNA1067443_P_NODE_8831_length_294_cov_8.063348_g8813_i0 PRJNA1067443 8831 294 8.063348 23.70624312 Deinococcus geothermalis 68909 Bacteria Bacteria 492 1.36e-134   NTclustered gi|94554390|gb|CP000359.1| 319795 g8813 i0 98.909 0.935374149659864 275 3 94 0 20 294 2129760 2129486 Deinococcus geothermalis DSM 11300, complete genome blastn 275 492 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
15484180 15484180 PRJNA1067443_P_NODE_18413_length_248_cov_0.880000_g18395_i0 PRJNA1067443 18413 248 0.88 2.1824 Deinococcus aetherius 200252 Bacteria Bacteria 300 7.26e-77   NTclustered gi|2281894955|dbj|AP026560.1| 200252 g18395 i0 91.743 4.08064516129032 218 15 88 1 31 248 1345694 1345480 Deinococcus aetherius ST0316 DNA, complete genome blastn 1012 300 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
21415414 21415414 PRJNA1067443_P_NODE_14917_length_257_cov_2.059783_g14899_i0 PRJNA1067443 14917 257 2.059783 5.29364231 Thermus 270 Bacteria Bacteria 320 5.8e-83   NTclustered gi|2701837056|dbj|AP031332.1| 274 g14899 i0 89.105 12 257 28 100 0 1 257 695477 695221 Thermus thermophilus TF27 DNA, complete genome blastn 3084 320 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
21858327 21858327 PRJNA1067443_P_NODE_21258_length_243_cov_0.905882_g21240_i0 PRJNA1067443 21258 243 0.905882 2.20129326 Deinococcus aetherius 200252 Bacteria Bacteria 359 1.15e-94   NTclustered gi|2281894955|dbj|AP026560.1| 200252 g21240 i0 93.388 82.6707818930041 242 16 99 0 2 243 2371366 2371607 Deinococcus aetherius ST0316 DNA, complete genome blastn 20089 359 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius

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