contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838689 | 838689 | PRJNA849822_P_NODE_38821_length_247_cov_0.896552_g38647_i0 | PRJNA849822 | 38821 | 247 | 0.896552 | 2.21448344 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 124 | 2.72e-31 | NR | WP_181691158.1 | 2750669 | g38647 | i0 | 86.7 | 1.0080971659919 | 83 | 10 | 99.6 | 1 | 246 | 1 | 212 | 294 | WP_181691158.1 NAD(P)/FAD-dependent oxidoreductase [Natronomonas sp. LN261] | diamond | 249 | 124 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 14866601 | 14866601 | PRJNA849822_P_NODE_25692_length_287_cov_1.158879_g25518_i0 | PRJNA849822 | 25692 | 287 | 1.158879 | 3.32598273 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 176 | 1.4899999999999999e-53 | NR | MDZ7850767.1 | 1980530 | g25518 | i0 | 87.4 | 2.97909407665505 | 95 | 12 | 99.3 | 0 | 1 | 285 | 8 | 102 | MDZ7850767.1 metal-dependent hydrolase [Halodesulfurarchaeum sp.] | diamond | 855 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 16141439 | 16141439 | PRJNA849822_P_NODE_38173_length_248_cov_0.891429_g37999_i0 | PRJNA849822 | 38173 | 248 | 0.891429 | 2.21074392 | Halanaeroarchaeum | 1656823 | Archaea | Archaea | 143 | 7.84e-42 | NR | MFB6131941.1 | 1963275 | g37999 | i0 | 79.3 | 1.97177419354839 | 82 | 17 | 99.2 | 0 | 247 | 2 | 9 | 90 | MFB6131941.1 peptide-methionine (R)-S-oxide reductase MsrB [Halanaeroarchaeum sp.] | diamond | 489 | 144 | 0.993055555555556 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 27023309 | 27023309 | PRJNA849822_P_NODE_39102_length_247_cov_0.873563_g38928_i0 | PRJNA849822 | 39102 | 247 | 0.873563 | 2.15770061 | Halorussus salinisoli | 2558242 | Archaea | Archaea | 95.9 | 4.28e-21 | NR | WP_170977260.1 | 2558242 | g38928 | i0 | 57.1 | 1.02024291497976 | 84 | 33 | 98.4 | 1 | 245 | 3 | 136 | 219 | WP_170977260.1 ABC transporter permease [Halorussus salinisoli] | diamond | 252 | 95.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus salinisoli | |
| 27063196 | 27063196 | PRJNA849822_P_NODE_41242_length_244_cov_0.912281_g41068_i0 | PRJNA849822 | 41242 | 244 | 0.912281 | 2.22596564 | Halonotius | 869896 | Archaea | Archaea | 103 | 6.9e-25 | NR | WP_120085182.1 | 268735 | g41068 | i0 | 89.1 | 1.40163934426229 | 55 | 6 | 67.6 | 0 | 244 | 80 | 207 | 261 | WP_120085182.1 helix-turn-helix transcriptional regulator [Halonotius pteroides] | diamond | 342 | 104 | 0.990384615384615 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius pteroides | |
| 27687138 | 27687138 | PRJNA849822_P_NODE_35504_length_251_cov_0.876404_g35330_i0 | PRJNA849822 | 35504 | 251 | 0.876404 | 2.19977404 | Halolamina sp. CBA123 | 1940283 | Archaea | Archaea | 57.4 | 2.57e-7 | NR | WP_079233932.1 | 1853690 | g35330 | i0 | 42.6 | 2.27091633466135 | 61 | 35 | 72.9 | 0 | 69 | 251 | 25 | 85 | WP_079233932.1 hypothetical protein [Halolamina sp. CBA1230] | diamond | 570 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. CBA1230 | |
| 27727044 | 27727044 | PRJNA849822_P_NODE_40924_length_244_cov_1.637427_g40750_i0 | PRJNA849822 | 40924 | 244 | 1.637427 | 3.99532188 | Natronomonas | 63743 | Archaea | Archaea | 90.5 | 3.81e-20 | NR | WP_410323127.1 | 2184060 | g40750 | i0 | 71.4 | 2.75409836065574 | 56 | 16 | 68.9 | 0 | 170 | 3 | 86 | 141 | WP_410323127.1 metallophosphoesterase family protein [Natronomonas sp.] | diamond | 672 | 90.9 | 0.995599559955996 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. | |
| 27781615 | 27781615 | PRJNA849822_P_NODE_36044_length_250_cov_0.881356_g35870_i0 | PRJNA849822 | 36044 | 250 | 0.881356 | 2.20339 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 113 | 1.66e-29 | NR | WP_332321273.1 | 1980530 | g35870 | i0 | 78.3 | 0.996 | 83 | 17 | 98.4 | 1 | 2 | 247 | 59 | 141 | WP_332321273.1 magnesium transporter [Halodesulfurarchaeum sp.] | diamond | 249 | 113 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 28065669 | 28065669 | PRJNA849822_P_NODE_41645_length_244_cov_0.912281_g41471_i0 | PRJNA849822 | 41645 | 244 | 0.912281 | 2.22596564 | Halopenitus sp. H-Gu1 | 3242697 | Archaea | Archaea | 55.8 | 8.73e-7 | NR | WP_373674197.1 | 3242697 | g41471 | i0 | 38.8 | 0.983606557377049 | 80 | 48 | 98.4 | 1 | 1 | 240 | 293 | 371 | WP_373674197.1 DNA N-6-adenine-methyltransferase [Halopenitus sp. H-Gu1] | diamond | 240 | 55.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. H-Gu1 | |
| 28673877 | 28673877 | PRJNA849822_P_NODE_37707_length_248_cov_0.891429_g37533_i0 | PRJNA849822 | 37707 | 248 | 0.891429 | 2.21074392 | Halobacteriales | 2235 | Archaea | Archaea | 99.8 | 3.56e-22 | NR | WP_020445970.1 | 1333523 | g37533 | i0 | 63.4 | 3.96774193548387 | 82 | 30 | 99.2 | 0 | 1 | 246 | 806 | 887 | WP_020445970.1 bacterio-opsin activator domain-containing protein [Salinarchaeum sp. Harcht-Bsk1] | diamond | 984 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. Harcht-Bsk1 | |
| 29202461 | 29202461 | PRJNA849822_P_NODE_42589_length_243_cov_0.888235_g42415_i0 | PRJNA849822 | 42589 | 243 | 0.888235 | 2.15841105 | Halopelagius fulvigenes | 1198324 | Archaea | Archaea | 85.1 | 3.37e-17 | NR | MFC6823486.1 | 1198324 | g42415 | i0 | 54.9 | 1.75308641975309 | 71 | 32 | 87.7 | 0 | 27 | 239 | 153 | 223 | MFC6823486.1 hypothetical protein [Halopelagius fulvigenes] | diamond | 426 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopelagius | Halopelagius fulvigenes | |
| 29486241 | 29486241 | PRJNA849822_P_NODE_29670_length_268_cov_1.589744_g29496_i0 | PRJNA849822 | 29670 | 268 | 1.589744 | 4.26051392 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 43.5 | 0.0263 | NR | MBE0524066.1 | 2250255 | g29496 | i0 | 36.5 | 0.582089552238806 | 52 | 30 | 54.9 | 1 | 21 | 167 | 29 | 80 | MBE0524066.1 acetate--CoA ligase [Methanosarcinales archaeon] | diamond | 156 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30348068 | 30348068 | PRJNA849822_P_NODE_36192_length_250_cov_0.881356_g36018_i0 | PRJNA849822 | 36192 | 250 | 0.881356 | 2.20339 | root | 1 | Root_unresolved | Root_unresolved | 79.3 | 5.21e-15 | NR | WP_321507665.1 | 1005933 | g36018 | i0 | 50.6 | 7.38 | 77 | 38 | 92.4 | 0 | 247 | 17 | 50 | 126 | WP_321507665.1 carboxylesterase family protein [uncultured Methanoregula sp.] | diamond | 1845 | 79.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 30465994 | 30465994 | PRJNA849822_P_NODE_43273_length_242_cov_0.923077_g43099_i0 | PRJNA849822 | 43273 | 242 | 0.923077 | 2.23384634 | Salinibaculum | 2732368 | Archaea | Archaea | 99.8 | 3.45e-23 | NR | WP_338902719.1 | 2732368 | g43099 | i0 | 82.4 | 0.632231404958678 | 51 | 9 | 63.2 | 0 | 154 | 2 | 13 | 63 | WP_338902719.1 MULTISPECIES: CPBP family intramembrane glutamic endopeptidase [Salinibaculum] | diamond | 153 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | ||
| 30631766 | 30631766 | PRJNA849822_P_NODE_31493_length_260_cov_1.668449_g31319_i0 | PRJNA849822 | 31493 | 260 | 1.668449 | 4.3379674 | Halobacteriales | 2235 | Archaea | Archaea | 145 | 6.42e-40 | NR | WP_130501661.1 | 392421 | g31319 | i0 | 89.5 | 2.97692307692308 | 86 | 9 | 99.2 | 0 | 259 | 2 | 3 | 88 | WP_130501661.1 carbon-phosphorus lyase complex subunit PhnI [Natrinema hispanicum] | diamond | 774 | 146 | 0.993150684931507 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema hispanicum | |
| 30726654 | 30726654 | PRJNA849822_P_NODE_36934_length_249_cov_0.886364_g36760_i0 | PRJNA849822 | 36934 | 249 | 0.886364 | 2.20704636 | Stenosarchaea group | 2290931 | Archaea | Archaea | 105 | 2.91e-24 | NR | WP_151139219.1 | 2251 | g36760 | i0 | 53.7 | 12.8072289156626 | 82 | 38 | 98.8 | 0 | 247 | 2 | 271 | 352 | WP_151139219.1 MULTISPECIES: proline--tRNA ligase [Haloferax] | diamond | 3189 | 106 | 0.990566037735849 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | ||
| 30971348 | 30971348 | PRJNA849822_P_NODE_36014_length_250_cov_0.881356_g35840_i0 | PRJNA849822 | 36014 | 250 | 0.881356 | 2.20339 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 85.1 | 4.98e-17 | NR | WP_332321943.1 | 1980530 | g35840 | i0 | 81.1 | 1.272 | 53 | 10 | 63.6 | 0 | 160 | 2 | 1 | 53 | WP_332321943.1 molybdopterin biosynthesis protein [Halodesulfurarchaeum sp.] | diamond | 318 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 31002906 | 31002906 | PRJNA849822_P_NODE_43274_length_242_cov_0.923077_g43100_i0 | PRJNA849822 | 43274 | 242 | 0.923077 | 2.23384634 | Halosimplex pelagicum | 869886 | Archaea | Archaea | 154 | 2.62e-43 | NR | WP_179922744.1 | 869886 | g43100 | i0 | 87.7 | 1.00413223140496 | 81 | 9 | 99.2 | 1 | 1 | 240 | 311 | 391 | WP_179922744.1 hypothetical protein [Halosimplex pelagicum] | diamond | 243 | 154 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex pelagicum | |
| 31034720 | 31034720 | PRJNA849822_P_NODE_36895_length_249_cov_0.886364_g36721_i0 | PRJNA849822 | 36895 | 249 | 0.886364 | 2.20704636 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 99.4 | 5.42e-25 | NR | WP_332321027.1 | 1980530 | g36721 | i0 | 61.5 | 0.939759036144578 | 78 | 30 | 94 | 0 | 15 | 248 | 1 | 78 | WP_332321027.1 DUF2249 domain-containing protein [Halodesulfurarchaeum sp.] | diamond | 234 | 99.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 31223805 | 31223805 | PRJNA849822_P_NODE_34335_length_252_cov_0.871508_g34161_i0 | PRJNA849822 | 34335 | 252 | 0.871508 | 2.19620016 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 135 | 3.4499999999999995e-37 | NR | MDZ7850046.1 | 1980530 | g34161 | i0 | 84.3 | 1.97619047619048 | 83 | 13 | 98.8 | 0 | 3 | 251 | 26 | 108 | MDZ7850046.1 protein translocase subunit SecF [Halodesulfurarchaeum sp.] | diamond | 498 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 31255606 | 31255606 | PRJNA849822_P_NODE_22155_length_308_cov_1.119149_g21981_i0 | PRJNA849822 | 22155 | 308 | 1.119149 | 3.44697892 | Halobellus rarus | 1126237 | Archaea | Archaea | 72.4 | 2.82e-12 | NR | WP_256421895.1 | 1126237 | g21981 | i0 | 33 | 7.41233766233766 | 100 | 67 | 97.4 | 0 | 302 | 3 | 320 | 419 | WP_256421895.1 cytochrome P450 [Halobellus rarus] | diamond | 2283 | 72.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus rarus | |
| 32489584 | 32489584 | PRJNA849822_P_NODE_26339_length_284_cov_1.099526_g26165_i0 | PRJNA849822 | 26339 | 284 | 1.099526 | 3.12265384 | Halorubrum halophilum | 413816 | Archaea | Archaea | 59.7 | 3.89e-8 | NR | WP_226929219.1 | 413816 | g26165 | i0 | 65.2 | 0.485915492957746 | 46 | 16 | 48.6 | 0 | 1 | 138 | 205 | 250 | WP_226929219.1 hypothetical protein [Halorubrum halophilum] | diamond | 138 | 59.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum halophilum | |
| 32836037 | 32836037 | PRJNA849822_P_NODE_3720_length_835_cov_4.738845_g3561_i0 | PRJNA849822 | 3720 | 835 | 4.738845 | 39.56935575 | Halorientalis persicus | 1367881 | Archaea | Archaea | 48.5 | 0.0147 | NR | WP_092658304.1 | 1367881 | g3561 | i0 | 28.4 | 0.481437125748503 | 134 | 91 | 46.3 | 2 | 420 | 34 | 70 | 203 | WP_092658304.1 DUF4397 domain-containing protein [Halorientalis persicus] | diamond | 402 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis persicus | |
| 32898950 | 32898950 | PRJNA849822_P_NODE_33260_length_253_cov_1.488889_g33086_i0 | PRJNA849822 | 33260 | 253 | 1.488889 | 3.76688917 | Natrinema hispanicum | 392421 | Archaea | Archaea | 72 | 1.75e-12 | NR | WP_223174756.1 | 392421 | g33086 | i0 | 52.3 | 0.770750988142292 | 65 | 31 | 77.1 | 0 | 253 | 59 | 26 | 90 | WP_223174756.1 tyrosine-type recombinase/integrase [Natrinema hispanicum] | diamond | 195 | 72 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema hispanicum |
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);;