contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA951412" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4763183 | 4763183 | PRJNA951412_P_NODE_5044_length_250_cov_0.875706_g4959_i0 | PRJNA951412 | 5044 | 250 | 0.875706 | 2.189265 | Haloplanus salinarum | 1912324 | Archaea | Archaea | 346 | 9.269999999999999e-91 | NTclustered | gi|2279709463|gb|CP101823.1| | 1912324 | g4959 | i0 | 91.935 | 93.644 | 248 | 19 | 99 | 1 | 1 | 247 | 1547138 | 1547385 | Haloplanus salinarum strain JCM 31424 chromosome, complete genome | blastn | 23411 | 346 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus salinarum | |
| 7312791 | 7312791 | PRJNA951412_P_NODE_3566_length_264_cov_1.408377_g3481_i0 | PRJNA951412 | 3566 | 264 | 1.408377 | 3.71811528 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 294 | 3.63e-75 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g3481 | i0 | 86.973 | 8.70454545454546 | 261 | 34 | 99 | 0 | 4 | 264 | 2895815 | 2895555 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 2298 | 294 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 7312801 | 7312801 | PRJNA951412_P_NODE_4006_length_253_cov_1.533333_g3921_i0 | PRJNA951412 | 4006 | 253 | 1.533333 | 3.87933249 | Natronomonas halophila | 2747817 | Archaea | Archaea | 180 | 1.01e-40 | NTclustered | gi|1865516082|gb|CP058334.1| | 2747817 | g3921 | i0 | 79.608 | 14.897233201581 | 255 | 48 | 100 | 4 | 1 | 253 | 2797444 | 2797696 | Natronomonas halophila strain C90 chromosome, complete genome | blastn | 3769 | 180 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas halophila | |
| 8587796 | 8587796 | PRJNA951412_P_NODE_5687_length_248_cov_0.885714_g5602_i0 | PRJNA951412 | 5687 | 248 | 0.885714 | 2.19657072 | Haloplanus aerogenes | 660522 | Archaea | Archaea | 342 | 1.1899999999999999e-89 | NTclustered | gi|1526250537|gb|CP034145.1| | 660522 | g5602 | i0 | 91.532 | 70.625 | 248 | 21 | 100 | 0 | 1 | 248 | 2352911 | 2353158 | Haloplanus aerogenes strain JCM 16430 chromosome, complete genome | blastn | 17515 | 342 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus aerogenes | |
| 8587821 | 8587821 | PRJNA951412_P_NODE_7407_length_243_cov_0.917647_g7322_i0 | PRJNA951412 | 7407 | 243 | 0.917647 | 2.22988221 | Salinibaculum rarum | 3058903 | Archaea | Archaea | 202 | 2.0599999999999995e-47 | NTclustered | gi|2548167091|gb|CP129992.1| | 3058903 | g7322 | i0 | 82.833 | 0.958847736625514 | 233 | 32 | 93 | 7 | 15 | 241 | 732332 | 732102 | Salinibaculum rarum strain KK48 chromosome, complete genome | blastn | 233 | 202 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum rarum | |
| 9862800 | 9862800 | PRJNA951412_P_NODE_3528_length_265_cov_1.307292_g3443_i0 | PRJNA951412 | 3528 | 265 | 1.307292 | 3.4643238 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 307 | 4.68e-79 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g3443 | i0 | 87.594 | 10.4566037735849 | 266 | 31 | 100 | 2 | 1 | 265 | 819485 | 819749 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 2771 | 307 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 13688462 | 13688462 | PRJNA951412_P_NODE_4531_length_251_cov_0.876404_g4446_i0 | PRJNA951412 | 4531 | 251 | 0.876404 | 2.19977404 | Halarchaeum sp. CBA1220 | 1853682 | Archaea | Archaea | 82.4 | 2.9e-11 | NTclustered | gi|1864271697|gb|CP054709.1| | 1853682 | g4446 | i0 | 84.524 | 0.334661354581673 | 84 | 11 | 33 | 2 | 169 | 251 | 286514 | 286432 | Halarchaeum sp. CBA1220 plasmid pCBA1220-02, complete sequence | blastn | 84 | 82.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halarchaeum | Halarchaeum sp. CBA1220 | |
| 14962650 | 14962650 | PRJNA951412_P_NODE_3612_length_263_cov_1.352632_g3527_i0 | PRJNA951412 | 3612 | 263 | 1.352632 | 3.5574221600000002 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 228 | 3.719999999999999e-55 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g3527 | i0 | 86.047 | 0.817490494296578 | 215 | 26 | 81 | 3 | 51 | 263 | 158116 | 157904 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 215 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 14962672 | 14962672 | PRJNA951412_P_NODE_5092_length_250_cov_0.870056_g5007_i0 | PRJNA951412 | 5092 | 250 | 0.870056 | 2.17514 | Halorussus aquaticus | 2953748 | Archaea | Archaea | 440 | 4.1399999999999976e-119 | NTclustered | gi|2269702785|gb|CP100403.1| | 2953748 | g5007 | i0 | 98.4 | 2 | 250 | 4 | 100 | 0 | 1 | 250 | 95064 | 95313 | Halorussus aquaticus strain XZYJ18 plasmid unnamed2, complete sequence | blastn | 500 | 440 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus aquaticus | |
| 14962693 | 14962693 | PRJNA951412_P_NODE_6632_length_245_cov_0.906977_g6547_i0 | PRJNA951412 | 6632 | 245 | 0.906977 | 2.22209365 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 104 | 6.02e-18 | NTclustered | gi|933677909|gb|CP011564.1| | 1604004 | g6547 | i0 | 79.861 | 1.17551020408163 | 144 | 28 | 58 | 1 | 1 | 143 | 1795675 | 1795532 | Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome | blastn | 288 | 104 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 16237649 | 16237649 | PRJNA951412_P_NODE_5273_length_249_cov_0.886364_g5188_i0 | PRJNA951412 | 5273 | 249 | 0.886364 | 2.20704636 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 350 | 7.14e-92 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g5188 | i0 | 91.968 | 83.2610441767068 | 249 | 20 | 100 | 0 | 1 | 249 | 1222066 | 1221818 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 20732 | 350 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 16237663 | 16237663 | PRJNA951412_P_NODE_6473_length_246_cov_0.890173_g6388_i0 | PRJNA951412 | 6473 | 246 | 0.890173 | 2.18982558 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 108 | 4.68e-19 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g6388 | i0 | 83.478 | 4.41056910569106 | 115 | 19 | 47 | 0 | 132 | 246 | 2832294 | 2832180 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 1085 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 22611879 | 22611879 | PRJNA951412_P_NODE_8018_length_242_cov_0.899408_g7933_i0 | PRJNA951412 | 8018 | 242 | 0.899408 | 2.17656736 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 80.5 | 1e-10 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g7933 | i0 | 92.727 | 2.74380165289256 | 55 | 4 | 23 | 0 | 186 | 240 | 2576608 | 2576662 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 664 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis |
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);;