contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1145997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2840389 | 2840389 | PRJNA1145997_P_NODE_42323_length_253_cov_0.866667_g39704_i0 | PRJNA1145997 | 42323 | 253 | 0.866667 | 2.19266751 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 446 | 9.01e-121 | NTclustered | gi|2176096791|gb|CP090373.1| | 2904243 | g39704 | i0 | 98.419 | 6 | 253 | 4 | 100 | 0 | 1 | 253 | 68386 | 68638 | Halobaculum sp. CBA1158 plasmid pCBA1158-2, complete sequence | blastn | 1518 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 2840470 | 2840470 | PRJNA1145997_P_NODE_47223_length_245_cov_0.906977_g44604_i0 | PRJNA1145997 | 47223 | 245 | 0.906977 | 2.22209365 | Natronomonas gomsonensis | 1046043 | Archaea | Archaea | 176 | 1.26e-39 | NTclustered | gi|2273673090|gb|CP101323.1| | 1046043 | g44604 | i0 | 80.328 | 0.995918367346939 | 244 | 38 | 98 | 7 | 2 | 240 | 1766427 | 1766189 | Natronomonas gomsonensis strain KCTC 4088 chromosome, complete genome | blastn | 244 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas gomsonensis | |
| 10493269 | 10493269 | PRJNA1145997_P_NODE_43929_length_250_cov_0.881356_g41310_i0 | PRJNA1145997 | 43929 | 250 | 0.881356 | 2.20339 | Halobacterium wangiae | 2902623 | Archaea | Archaea | 412 | 9.02e-111 | NTclustered | gi|2168769890|gb|CP089588.1| | 2902623 | g41310 | i0 | 96.4 | 102.748 | 250 | 9 | 100 | 0 | 1 | 250 | 2184963 | 2185212 | Halobacterium wangiae strain Gai3-17 chromosome, complete genome | blastn | 25687 | 412 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium wangiae | |
| 13042922 | 13042922 | PRJNA1145997_P_NODE_22471_length_606_cov_4.065666_g19867_i0 | PRJNA1145997 | 22471 | 606 | 4.065666 | 24.63793596 | Haloplanus rubicundus | 1547898 | Archaea | Archaea | 54.7 | 0.017 | NTclustered | gi|1434708495|gb|CP031148.1| | 1547898 | g19867 | i0 | 84.483 | 0.191419141914191 | 58 | 5 | 9 | 3 | 265 | 319 | 1138687 | 1138743 | Haloplanus rubicundus strain CBA1112 chromosome, complete genome | blastn | 116 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus rubicundus | |
| 20691124 | 20691124 | PRJNA1145997_P_NODE_44177_length_250_cov_0.881356_g41558_i0 | PRJNA1145997 | 44177 | 250 | 0.881356 | 2.20339 | Haloarcula montana | 3111776 | Archaea | Archaea | 110 | 1.32e-19 | NTclustered | gi|2648521790|gb|CP142027.1| | 3111776 | g41558 | i0 | 89.655 | 0.564 | 87 | 8 | 34 | 1 | 132 | 217 | 796808 | 796722 | Haloarcula sp. GH36 chromosome, complete genome | blastn | 141 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula montana | |
| 21966412 | 21966412 | PRJNA1145997_P_NODE_41798_length_255_cov_1.714286_g39179_i0 | PRJNA1145997 | 41798 | 255 | 1.714286 | 4.3714293 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 311 | 3.46e-80 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g39179 | i0 | 88.627 | 4.29803921568627 | 255 | 29 | 100 | 0 | 1 | 255 | 2653239 | 2653493 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 1096 | 311 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 21966417 | 21966417 | PRJNA1145997_P_NODE_42098_length_253_cov_2.344444_g39479_i0 | PRJNA1145997 | 42098 | 253 | 2.344444 | 5.93144332 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 207 | 4.63e-49 | NTclustered | gi|1082264851|gb|CP016070.1| | 1873524 | g39479 | i0 | 81.569 | 12.0869565217391 | 255 | 43 | 100 | 4 | 1 | 253 | 1517460 | 1517712 | Halodesulfurarchaeum formicicum strain HTSR1 chromosome, complete genome | blastn | 3058 | 207 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 24515362 | 24515362 | PRJNA1145997_P_NODE_37140_length_288_cov_1.088372_g34521_i0 | PRJNA1145997 | 37140 | 288 | 1.088372 | 3.13451136 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 416 | 8.2e-112 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g34521 | i0 | 92.708 | 37.03125 | 288 | 21 | 100 | 0 | 1 | 288 | 2473471 | 2473758 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 10665 | 416 | 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);;