RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1132896" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1132896 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
1558182 1558182 PRJNA1132896_P_NODE_10202_length_241_cov_0.916667_g10111_i0 PRJNA1132896 10202 241 0.916667 2.20916747 Salinibacter ruber 146919 Bacteria Bacteria 429 8.58e-116   NTclustered gi|1473073669|gb|CP030357.1| 146919 g10111 i0 98.755 10 241 3 100 0 1 241 634039 634279 Salinibacter ruber strain SP38 chromosome, complete genome blastn 2410 429 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
3582292 3582292 PRJNA1132896_P_NODE_7883_length_248_cov_0.880000_g7792_i0 PRJNA1132896 7883 248 0.88 2.1824 Salinibacter 146918 Bacteria Bacteria 267 7.36e-67   NTclustered gi|1473073681|gb|CP030369.1| 146919 g7792 i0 86.345 2.00806451612903 249 28 99 3 2 247 297547 297792 Salinibacter ruber strain RM158 chromosome, complete genome blastn 498 267 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
4859832 4859832 PRJNA1132896_P_NODE_9344_length_244_cov_0.888889_g9253_i0 PRJNA1132896 9344 244 0.888889 2.16888916 Salinibacter 146918 Bacteria Bacteria 435 1.87e-117   NTclustered gi|1419235469|gb|CP030716.1| 146919 g9253 i0 98.77 9.99180327868852 244 3 100 0 1 244 2010933 2011176 Salinibacter ruber strain P13 chromosome, complete genome blastn 2438 435 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
9211639 9211639 PRJNA1132896_P_NODE_5688_length_265_cov_1.109375_g5597_i0 PRJNA1132896 5688 265 1.109375 2.93984375 Salinibacter ruber 146919 Bacteria Bacteria 484 2.0199999999999998e-132   NTclustered gi|1473073673|gb|CP030361.1| 146919 g5597 i0 99.623 10.4075471698113 265 1 100 0 1 265 3355957 3356221 Salinibacter ruber strain SP73 chromosome, complete genome blastn 2758 484 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
15059476 15059476 PRJNA1132896_P_NODE_6092_length_259_cov_1.940860_g6001_i0 PRJNA1132896 6092 259 1.94086 5.0268274 Salinibacter 146918 Bacteria Bacteria 462 9.2e-126   NTclustered gi|1419235469|gb|CP030716.1| 146919 g6001 i0 98.842 13.8725868725869 259 3 100 0 1 259 2284252 2284510 Salinibacter ruber strain P13 chromosome, complete genome blastn 3593 462 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
18135438 18135438 PRJNA1132896_P_NODE_8975_length_245_cov_0.872093_g8884_i0 PRJNA1132896 8975 245 0.872093 2.13662785 Salinibacter ruber 146919 Bacteria Bacteria 431 2.4299999999999996e-116   NTclustered gi|1241298903|gb|CP020719.1| 146919 g8884 i0 98.367 9.97142857142857 245 4 100 0 1 245 1696922 1696678 Salinibacter ruber strain ST67 genome blastn 2443 431 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
21960400 21960400 PRJNA1132896_P_NODE_3878_length_290_cov_2.050691_g3787_i0 PRJNA1132896 3878 290 2.050691 5.9470039 Salinibacter ruber 146919 Bacteria Bacteria 377 3.8999999999999993e-100   NTclustered gi|1473073668|gb|CP030356.1| 146919 g3787 i0 90.278 9.93793103448276 288 28 99 0 3 290 2881810 2881523 Salinibacter ruber strain P18 chromosome, complete genome blastn 2882 377 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
25258077 25258077 PRJNA1132896_P_NODE_4360_length_284_cov_1.246445_g4269_i0 PRJNA1132896 4360 284 1.246445 3.5399038 Salinibacter 146918 Bacteria Bacteria 503 6.02e-138   NTclustered gi|1473073681|gb|CP030369.1| 146919 g4269 i0 98.932 9.90492957746479 281 3 99 0 4 284 510492 510212 Salinibacter ruber strain RM158 chromosome, complete genome blastn 2813 508 0.990157480314961 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber

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