contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA949785" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2208463 | 2208463 | PRJNA949785_P_NODE_16782_length_247_cov_0.885057_g16585_i0 | PRJNA949785 | 16782 | 247 | 0.885057 | 2.18609079 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 255 | 1.59e-63 | NTclustered | gi|1861358827|gb|CP054585.1| | 1853699 | g16585 | i0 | 88.073 | 148.603238866397 | 218 | 22 | 87 | 4 | 3 | 217 | 1358646 | 1358430 | Halorubrum sp. CBA1229 chromosome, complete genome | blastn | 36705 | 255 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 | |
| 8586152 | 8586152 | PRJNA949785_P_NODE_16967_length_247_cov_0.885057_g16770_i0 | PRJNA949785 | 16967 | 247 | 0.885057 | 2.18609079 | Halobacterium litoreum | 2039234 | Archaea | Archaea | 122 | 1.68e-23 | NTclustered | gi|2168234898|gb|CP089466.1| | 2039234 | g16770 | i0 | 92.045 | 22.1376518218623 | 88 | 5 | 35 | 2 | 9 | 95 | 1479722 | 1479636 | Halobacterium litoreum strain ZS-54-S2 chromosome, complete genome | blastn | 5468 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium litoreum | |
| 8586172 | 8586172 | PRJNA949785_P_NODE_18547_length_242_cov_0.911243_g18350_i0 | PRJNA949785 | 18547 | 242 | 0.911243 | 2.20520806 | Halopenitus persicus | 1048396 | Archaea | Archaea | 156 | 1.6200000000000002e-33 | NTclustered | gi|1040460692|dbj|AP017558.1| | 1048396 | g18350 | i0 | 86.62 | 5.05371900826446 | 142 | 18 | 59 | 1 | 4 | 145 | 1050071 | 1050211 | Halopenitus persicus DNA, complete genome, strain: CBA1233 | blastn | 1223 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus persicus | |
| 9861193 | 9861193 | PRJNA949785_P_NODE_16328_length_249_cov_0.875000_g16131_i0 | PRJNA949785 | 16328 | 249 | 0.875 | 2.17875 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 163 | 9.980000000000001e-36 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g16131 | i0 | 93.578 | 11.140562248996 | 109 | 7 | 44 | 0 | 1 | 109 | 227207 | 227099 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 2774 | 163 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 13686855 | 13686855 | PRJNA949785_P_NODE_17871_length_244_cov_0.900585_g17674_i0 | PRJNA949785 | 17871 | 244 | 0.900585 | 2.1974274 | Haloarcula montana | 3111776 | Archaea | Archaea | 368 | 1.92e-97 | NTclustered | gi|2648521790|gb|CP142027.1| | 3111776 | g17674 | i0 | 93.852 | 10.9016393442623 | 244 | 15 | 100 | 0 | 1 | 244 | 980773 | 980530 | Haloarcula sp. GH36 chromosome, complete genome | blastn | 2660 | 368 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula montana | |
| 14960998 | 14960998 | PRJNA949785_P_NODE_16152_length_249_cov_0.875000_g15955_i0 | PRJNA949785 | 16152 | 249 | 0.875 | 2.17875 | Halobellus inordinatus | 1126236 | Archaea | Archaea | 411 | 3.2299999999999996e-110 | NTclustered | gi|2279714123|gb|CP101825.1| | 1126236 | g15955 | i0 | 96.386 | 4.28915662650602 | 249 | 9 | 100 | 0 | 1 | 249 | 1749796 | 1749548 | Halobellus inordinatus strain DSM 26177 chromosome, complete genome | blastn | 1068 | 411 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus inordinatus | |
| 17511307 | 17511307 | PRJNA949785_P_NODE_13394_length_276_cov_1.384236_g13197_i0 | PRJNA949785 | 13394 | 276 | 1.384236 | 3.82049136 | Haloferax sp. S1W | 3377110 | Archaea | Archaea | 182 | 3.1e-41 | NTclustered | gi|2845113133|gb|CP172596.1| | 3377110 | g13197 | i0 | 79.078 | 1.96739130434783 | 282 | 45 | 99 | 10 | 2 | 276 | 165833 | 166107 | Haloferax sp. S1W plasmid pHFX1, complete sequence | blastn | 543 | 182 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. S1W | |
| 18784909 | 18784909 | PRJNA949785_P_NODE_15155_length_254_cov_2.209945_g14958_i0 | PRJNA949785 | 15155 | 254 | 2.209945 | 5.6132603 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 259 | 1.27e-64 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g14958 | i0 | 85.156 | 8.9251968503937 | 256 | 34 | 100 | 4 | 1 | 254 | 1548344 | 1548597 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 2267 | 259 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 18784915 | 18784915 | PRJNA949785_P_NODE_15675_length_251_cov_0.865169_g15478_i0 | PRJNA949785 | 15675 | 251 | 0.865169 | 2.17157419 | Halarchaeum sp. CBA1220 | 1853682 | Archaea | Archaea | 152 | 2.18e-32 | NTclustered | gi|1864269003|gb|CP054707.1| | 1853682 | g15478 | i0 | 79.717 | 0.844621513944223 | 212 | 41 | 84 | 2 | 1 | 211 | 1354870 | 1354660 | Halarchaeum sp. CBA1220 chromosome, complete genome | blastn | 212 | 152 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halarchaeum | Halarchaeum sp. CBA1220 | |
| 18784924 | 18784924 | PRJNA949785_P_NODE_16295_length_249_cov_0.875000_g16098_i0 | PRJNA949785 | 16295 | 249 | 0.875 | 2.17875 | Haloferax volcanii | 2246 | Archaea | Archaea | 172 | 1.66e-38 | NTclustered | gi|291369412|gb|CP001955.1| | 309800 | g16098 | i0 | 94.595 | 1.22088353413655 | 111 | 6 | 45 | 0 | 134 | 244 | 452519 | 452629 | Haloferax volcanii DS2 plasmid pHV4, complete sequence | blastn | 304 | 172 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 21335268 | 21335268 | PRJNA949785_P_NODE_16837_length_247_cov_0.885057_g16640_i0 | PRJNA949785 | 16837 | 247 | 0.885057 | 2.18609079 | Natrinema thermotolerans | 121872 | Archaea | Archaea | 322 | 1.54e-83 | NTclustered | gi|1621090060|gb|CP031304.1| | 121872 | g16640 | i0 | 90.871 | 28.7611336032389 | 241 | 21 | 97 | 1 | 8 | 247 | 7105 | 6865 | Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence | blastn | 7104 | 322 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans |
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);;