contig_metadata
15 rows where bioproject = "PRJNA1132896" and tax_phylum = "Rhodothermota"
This data as json, CSV (advanced)
| 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 | |
| 27228281 | 27228281 | PRJNA1132896_P_NODE_9303_length_244_cov_0.900585_g9212_i0 | PRJNA1132896 | 9303 | 244 | 0.900585 | 2.1974274 | Salinibacter ruber | 146919 | Bacteria | Bacteria | 72 | 2.74e-14 | NR | WP_259122985.1 | 146919 | g9212 | i0 | 77.5 | 0.491803278688525 | 40 | 9 | 49.2 | 0 | 2 | 121 | 55 | 94 | WP_259122985.1 hypothetical protein, partial [Salinibacter ruber] | diamond | 120 | 72 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinibacter | Salinibacter ruber | |
| 27544319 | 27544319 | PRJNA1132896_P_NODE_8404_length_246_cov_1.416185_g8313_i0 | PRJNA1132896 | 8404 | 246 | 1.416185 | 3.4838151 | Salinibacter sp. | 2065818 | Bacteria | Bacteria | 63.5 | 1.78e-9 | NR | WP_375801212.1 | 2065818 | g8313 | i0 | 51.7 | 1.57317073170732 | 58 | 28 | 70.7 | 0 | 177 | 4 | 178 | 235 | WP_375801212.1 IS1096 element passenger TnpR family protein [Salinibacter sp.] | diamond | 387 | 63.5 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinibacter | Salinibacter sp. | |
| 28744114 | 28744114 | PRJNA1132896_P_NODE_2907_length_327_cov_0.893701_g2816_i0 | PRJNA1132896 | 2907 | 327 | 0.893701 | 2.92240227 | Salinivenus sp. | 1885341 | Bacteria | Bacteria | 62.4 | 2.25e-9 | NR | MEF8939632.1 | 1885341 | g2816 | i0 | 44.9 | 0.63302752293578 | 69 | 38 | 63.3 | 0 | 209 | 3 | 36 | 104 | MEF8939632.1 hypothetical protein [Salinivenus sp.] | diamond | 207 | 62.4 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinivenus | Salinivenus sp. | |
| 32030303 | 32030303 | PRJNA1132896_P_NODE_8798_length_245_cov_0.895349_g8707_i0 | PRJNA1132896 | 8798 | 245 | 0.895349 | 2.19360505 | Salinivenus sp. | 1885341 | Bacteria | Bacteria | 48.5 | 9.66e-5 | NR | MFP4117240.1 | 1885341 | g8707 | i0 | 32.5 | 0.979591836734694 | 80 | 45 | 98 | 2 | 240 | 1 | 8 | 78 | MFP4117240.1 hypothetical protein [Salinivenus sp.] | diamond | 240 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinivenus | Salinivenus sp. | |
| 32093429 | 32093429 | PRJNA1132896_P_NODE_10338_length_241_cov_0.916667_g10247_i0 | PRJNA1132896 | 10338 | 241 | 0.916667 | 2.20916747 | Salinibacter ruber | 146919 | Bacteria | Bacteria | 164 | 1.7799999999999998e-47 | NR | WP_259171181.1 | 146919 | g10247 | i0 | 100 | 1.99170124481328 | 80 | 0 | 99.6 | 0 | 240 | 1 | 135 | 214 | WP_259171181.1 hypothetical protein, partial [Salinibacter ruber] | diamond | 480 | 164 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinibacter | Salinibacter ruber | |
| 32156925 | 32156925 | PRJNA1132896_P_NODE_8898_length_245_cov_0.895349_g8807_i0 | PRJNA1132896 | 8898 | 245 | 0.895349 | 2.19360505 | Salinibacter ruber | 146919 | Bacteria | Bacteria | 96.3 | 7.06e-22 | NR | WP_259219626.1 | 146919 | g8807 | i0 | 54.3 | 0.991836734693878 | 81 | 36 | 99.2 | 1 | 1 | 243 | 179 | 258 | WP_259219626.1 hypothetical protein [Salinibacter ruber] | diamond | 243 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinibacter | Salinibacter ruber | |
| 32725552 | 32725552 | PRJNA1132896_P_NODE_9940_length_242_cov_0.911243_g9849_i0 | PRJNA1132896 | 9940 | 242 | 0.911243 | 2.20520806 | Salinibacter ruber | 146919 | Bacteria | Bacteria | 169 | 1e-46 | NR | WP_272502953.1 | 146919 | g9849 | i0 | 98.8 | 1.98347107438017 | 80 | 1 | 99.2 | 0 | 1 | 240 | 186 | 265 | WP_272502953.1 hypothetical protein [Salinibacter ruber] | diamond | 480 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salinibacteraceae | Salinibacter | Salinibacter ruber |
Advanced export
JSON shape: default, array, newline-delimited
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);;