contig_metadata
17 rows where bioproject = "PRJNA841653" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830832 | 830832 | PRJNA841653_P_NODE_53161_length_246_cov_0.890173_g52487_i0 | PRJNA841653 | 53161 | 246 | 0.890173 | 2.18982558 | Halorubrum hochsteinianum | 2949307 | Archaea | Archaea | 100 | 7.82e-17 | NTclustered | gi|2251941869|gb|CP098415.1| | 2949307 | g52487 | i0 | 89.744 | 0.317073170731707 | 78 | 8 | 32 | 0 | 169 | 246 | 1853616 | 1853539 | Halorubrum hochsteinianum strain 1-13-28 chromosome, complete genome | blastn | 78 | 100 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum hochsteinianum | |
| 4658909 | 4658909 | PRJNA841653_P_NODE_35144_length_277_cov_1.411765_g34470_i0 | PRJNA841653 | 35144 | 277 | 1.411765 | 3.91058905 | Halorubrum salinarum | 2739057 | Archaea | Archaea | 119 | 2.48e-22 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g34470 | i0 | 81.818 | 0.516245487364621 | 143 | 24 | 51 | 2 | 113 | 254 | 2261089 | 2261230 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 143 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 19957115 | 19957115 | PRJNA841653_P_NODE_43996_length_251_cov_0.865169_g43322_i0 | PRJNA841653 | 43996 | 251 | 0.865169 | 2.17157419 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 198 | 2.76e-46 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g43322 | i0 | 81.59 | 0.952191235059761 | 239 | 44 | 95 | 0 | 5 | 243 | 584731 | 584969 | Methanobrevibacter sp. YE315, complete genome | blastn | 239 | 198 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 22507626 | 22507626 | PRJNA841653_P_NODE_50878_length_247_cov_0.885057_g50204_i0 | PRJNA841653 | 50878 | 247 | 0.885057 | 2.18609079 | Halovalidus salilacus | 3075124 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2581323319|gb|CP134700.1| | 3075124 | g50204 | i0 | 96.875 | 5.38866396761134 | 32 | 0 | 13 | 1 | 139 | 169 | 896898 | 896867 | Halovalidus salilacus strain CCL63 chromosome, complete genome | blastn | 1331 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovalidus | Halovalidus salilacus | |
| 25056320 | 25056320 | PRJNA841653_P_NODE_19160_length_373_cov_1.016667_g18488_i0 | PRJNA841653 | 19160 | 373 | 1.016667 | 3.79216791 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 508 | 1.75e-139 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g18488 | i0 | 91.803 | 95.1447721179625 | 366 | 28 | 98 | 2 | 9 | 373 | 3146930 | 3147294 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 35489 | 508 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 27149055 | 27149055 | PRJNA841653_P_NODE_24542_length_329_cov_1.496094_g23868_i0 | PRJNA841653 | 24542 | 329 | 1.496094 | 4.92214926 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 43.9 | 0.00407 | NR | MCI0559232.1 | 1971748 | g23868 | i0 | 46 | 0.455927051671733 | 50 | 26 | 45.6 | 1 | 93 | 242 | 22 | 70 | MCI0559232.1 hypothetical protein [Nitrososphaera sp.] | diamond | 150 | 43.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 28349553 | 28349553 | PRJNA841653_P_NODE_49246_length_248_cov_0.880000_g48572_i0 | PRJNA841653 | 49246 | 248 | 0.88 | 2.1824 | Natronococcus sp. | 35747 | Archaea | Archaea | 42.7 | 0.0193 | NR | WP_416283822.1 | 35747 | g48572 | i0 | 53.5 | 0.520161290322581 | 43 | 19 | 50.8 | 1 | 248 | 123 | 96 | 138 | WP_416283822.1 helix-turn-helix domain-containing protein [Natronococcus sp.] | diamond | 129 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus sp. | |
| 30465737 | 30465737 | PRJNA841653_P_NODE_46593_length_249_cov_1.335227_g45919_i0 | PRJNA841653 | 46593 | 249 | 1.335227 | 3.32471523 | Candidatus Heimdallarchaeota archaeon | 2026747 | Archaea | Archaea | 46.6 | 0.00168 | NR | UCG04066.1 | 2026747 | g45919 | i0 | 33.3 | 0.975903614457831 | 81 | 45 | 90.4 | 4 | 19 | 243 | 56 | 133 | UCG04066.1 MAG: GTP-binding protein [Candidatus Heimdallarchaeota archaeon] | diamond | 243 | 46.6 | 1 | Archaea | Promethearchaeati | Candidatus Heimdallarchaeota | Candidatus Heimdallarchaeota archaeon | ||||||
| 30654893 | 30654893 | PRJNA841653_P_NODE_64073_length_225_cov_17.598684_g63399_i0 | PRJNA841653 | 64073 | 225 | 17.598684 | 39.597039 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 116 | 4.359999999999999e-32 | NR | MCA9460427.1 | 2026764 | g63399 | i0 | 86.3 | 0.973333333333333 | 73 | 10 | 97.3 | 0 | 221 | 3 | 3 | 75 | MCA9460427.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 219 | 116 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31002641 | 31002641 | PRJNA841653_P_NODE_53934_length_245_cov_0.895349_g53260_i0 | PRJNA841653 | 53934 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 63.2 | 2.48e-9 | NR | MDP2438677.1 | 1906665 | g53260 | i0 | 42.3 | 0.869387755102041 | 71 | 41 | 86.9 | 0 | 244 | 32 | 863 | 933 | MDP2438677.1 RasGEF domain-containing protein [archaeon] | diamond | 213 | 63.2 | 1 | Archaea | archaeon | ||||||||
| 31223563 | 31223563 | PRJNA841653_P_NODE_56415_length_244_cov_0.900585_g55741_i0 | PRJNA841653 | 56415 | 244 | 0.900585 | 2.1974274 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 126 | 4.9099999999999996e-32 | NR | MDA7464148.1 | 1915863 | g55741 | i0 | 75.9 | 0.971311475409836 | 79 | 19 | 97.1 | 0 | 2 | 238 | 132 | 210 | MDA7464148.1 hypothetical protein [Candidatus Poseidonia alphae] | diamond | 237 | 126 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 31382024 | 31382024 | PRJNA841653_P_NODE_58716_length_243_cov_0.905882_g58042_i0 | PRJNA841653 | 58716 | 243 | 0.905882 | 2.20129326 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 82 | 1.28e-16 | NR | MFI5405227.1 | 2268197 | g58042 | i0 | 53.4 | 0.716049382716049 | 58 | 27 | 71.6 | 0 | 41 | 214 | 5 | 62 | MFI5405227.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 174 | 82 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 31476973 | 31476973 | PRJNA841653_P_NODE_62376_length_241_cov_0.916667_g61702_i0 | PRJNA841653 | 62376 | 241 | 0.916667 | 2.20916747 | archaeon | 1906665 | Archaea | Archaea | 59.3 | 5.46e-8 | NR | RYH18455.1 | 1906665 | g61702 | i0 | 42.3 | 0.883817427385892 | 71 | 41 | 88.4 | 0 | 214 | 2 | 913 | 983 | RYH18455.1 MAG: hypothetical protein EON65_27185, partial [archaeon] | diamond | 213 | 59.3 | 1 | Archaea | archaeon | ||||||||
| 32204406 | 32204406 | PRJNA841653_P_NODE_14558_length_431_cov_1.899441_g13887_i0 | PRJNA841653 | 14558 | 431 | 1.899441 | 8.18659071 | Halobacteriota archaeon | 3100168 | Archaea | Archaea | 55.8 | 7.81e-6 | NR | MDY6957599.1 | 3100168 | g13887 | i0 | 37.9 | 0.605568445475638 | 87 | 42 | 59.2 | 2 | 171 | 425 | 1046 | 1122 | MDY6957599.1 hypothetical protein [Halobacteriota archaeon] | diamond | 261 | 55.8 | 1 | Archaea | Methanobacteriati | Halobacteriota | Halobacteriota archaeon | ||||||
| 32299679 | 32299679 | PRJNA841653_P_NODE_55419_length_244_cov_1.701754_g54745_i0 | PRJNA841653 | 55419 | 244 | 1.701754 | 4.15227976 | Methanocaldococcus villosus | 667126 | Archaea | Archaea | 55.5 | 2.89e-7 | NR | WP_004592618.1 | 667126 | g54745 | i0 | 42.5 | 3.9344262295082 | 80 | 28 | 98.4 | 2 | 2 | 241 | 69 | 130 | WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus] | diamond | 960 | 55.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus villosus | |
| 32552754 | 32552754 | PRJNA841653_P_NODE_54539_length_245_cov_0.895349_g53865_i0 | PRJNA841653 | 54539 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 41.6 | 0.0143 | NR | RYG59128.1 | 1906665 | g53865 | i0 | 50 | 0.391836734693878 | 32 | 16 | 39.2 | 0 | 8 | 103 | 26 | 57 | RYG59128.1 MAG: hypothetical protein EON64_20550 [archaeon] | diamond | 96 | 41.6 | 1 | Archaea | archaeon | ||||||||
| 32898705 | 32898705 | PRJNA841653_P_NODE_48700_length_248_cov_0.880000_g48026_i0 | PRJNA841653 | 48700 | 248 | 0.88 | 2.1824 | archaeon | 1906665 | Archaea | Archaea | 144 | 9.58e-39 | NR | RYG65736.1 | 1906665 | g48026 | i0 | 82.5 | 0.967741935483871 | 80 | 14 | 96.8 | 0 | 242 | 3 | 320 | 399 | RYG65736.1 MAG: hypothetical protein EON64_11310, partial [archaeon] | diamond | 240 | 144 | 1 | Archaea | archaeon |
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);;