contig_metadata
22 rows where bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3736700 | 3736700 | PRJNA703759_P_NODE_38723_length_250_cov_0.881356_g38247_i0 | PRJNA703759 | 38723 | 250 | 0.881356 | 2.20339 | Haladaptatus | 367188 | Archaea | Archaea | 108 | 4.76e-19 | NTclustered | gi|2471356508|gb|CP120470.1| | 3032580 | g38247 | i0 | 82.927 | 1.916 | 123 | 18 | 49 | 1 | 1 | 123 | 292142 | 292023 | Haladaptatus sp. DYSN1 chromosome, complete genome | blastn | 479 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYSN1 | |
| 4512388 | 4512388 | PRJNA703759_P_NODE_26584_length_279_cov_1.058252_g26108_i0 | PRJNA703759 | 26584 | 279 | 1.058252 | 2.95252308 | Methanococcus maripaludis | 39152 | Archaea | Archaea | 58.4 | 5.52e-4 | NTclustered | gi|1342459100|gb|CP026606.1| | 39152 | g26108 | i0 | 94.737 | 0.136200716845878 | 38 | 1 | 14 | 1 | 101 | 138 | 324531 | 324495 | Methanococcus maripaludis strain DSM 2067 chromosome, complete genome | blastn | 38 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 19036724 | 19036724 | PRJNA703759_P_NODE_35875_length_252_cov_0.871508_g35399_i0 | PRJNA703759 | 35875 | 252 | 0.871508 | 2.19620016 | Haladaptatus | 367188 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2471356512|gb|CP120472.1| | 3032580 | g35399 | i0 | 100 | 0.333333333333333 | 28 | 0 | 11 | 0 | 215 | 242 | 499684 | 499711 | Haladaptatus sp. DYSN1 plasmid unnamed2, complete sequence | blastn | 84 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYSN1 | |
| 19811503 | 19811503 | PRJNA703759_P_NODE_39976_length_249_cov_0.886364_g39500_i0 | PRJNA703759 | 39976 | 249 | 0.886364 | 2.20704636 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g39500 | i0 | 96.875 | 0.1285140562249 | 32 | 0 | 12 | 1 | 2 | 32 | 2173963 | 2173994 | Halalkalicoccus jeotgali B3, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 22361456 | 22361456 | PRJNA703759_P_NODE_24178_length_288_cov_1.418605_g23702_i0 | PRJNA703759 | 24178 | 288 | 1.418605 | 4.0855824 | Methanobacterium sp. ACI-7 | 3240853 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|2904246484|gb|CP166866.1| | 3240853 | g23702 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 181 | 208 | 1982143 | 1982170 | Methanobacterium sp. ACI-7 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ACI-7 | |
| 22361850 | 22361850 | PRJNA703759_P_NODE_40878_length_249_cov_0.886364_g40402_i0 | PRJNA703759 | 40878 | 249 | 0.886364 | 2.20704636 | Haloplanus sp. GX21 | 3127120 | Archaea | Archaea | 263 | 9.56e-66 | NTclustered | gi|2700851762|gb|CP147874.1| | 3127120 | g40402 | i0 | 90.547 | 3.49397590361446 | 201 | 16 | 80 | 3 | 52 | 249 | 650801 | 650601 | Haloplanus sp. GX21 chromosome, complete genome | blastn | 870 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GX21 | |
| 23637131 | 23637131 | PRJNA703759_P_NODE_24979_length_285_cov_1.396226_g24503_i0 | PRJNA703759 | 24979 | 285 | 1.396226 | 3.9792441 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 222 | 1.9e-53 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g24503 | i0 | 80.836 | 1.00701754385965 | 287 | 51 | 100 | 4 | 1 | 285 | 1842812 | 1843096 | Halalkalicoccus jeotgali B3, complete genome | blastn | 287 | 222 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 24910694 | 24910694 | PRJNA703759_P_NODE_29700_length_268_cov_1.225641_g29224_i0 | PRJNA703759 | 29700 | 268 | 1.225641 | 3.28471788 | uncultured Methanomassiliicoccales archaeon | 1235852 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2874253643|emb|OY968769.1| | 1235852 | g29224 | i0 | 100 | 0.104477611940299 | 28 | 0 | 10 | 0 | 211 | 238 | 2523827 | 2523800 | MAG: uncultured Methanomassiliicoccales archaeon isolate MFD00905.bin.2.112 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | uncultured Methanomassiliicoccales archaeon | ||||
| 27304183 | 27304183 | PRJNA703759_P_NODE_33943_length_254_cov_1.292818_g33467_i0 | PRJNA703759 | 33943 | 254 | 1.292818 | 3.28375772 | Natrinema pallidum | 69527 | Archaea | Archaea | 40 | 0.0358 | NR | WP_152422535.1 | 69527 | g33467 | i0 | 65.2 | 0.271653543307087 | 23 | 8 | 27.2 | 0 | 186 | 254 | 6 | 28 | WP_152422535.1 hypothetical protein [Natrinema pallidum] | diamond | 69 | 40 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema pallidum | |
| 27367594 | 27367594 | PRJNA703759_P_NODE_18343_length_321_cov_1.129032_g17867_i0 | PRJNA703759 | 18343 | 321 | 1.129032 | 3.62419272 | archaeon | 1906665 | Archaea | Archaea | 69.7 | 3.18e-11 | NR | MDP2436471.1 | 1906665 | g17867 | i0 | 33 | 1.01869158878505 | 109 | 66 | 98.1 | 2 | 317 | 3 | 522 | 627 | MDP2436471.1 hypothetical protein [archaeon] | diamond | 327 | 69.7 | 1 | Archaea | archaeon | ||||||||
| 27588426 | 27588426 | PRJNA703759_P_NODE_32244_length_259_cov_1.645161_g31768_i0 | PRJNA703759 | 32244 | 259 | 1.645161 | 4.26096699 | Haladaptatus sp. DYF46 | 2886041 | Archaea | Archaea | 43.5 | 0.0225 | NR | WP_303646666.1 | 2886041 | g31768 | i0 | 64.7 | 0.393822393822394 | 34 | 11 | 39.4 | 1 | 248 | 147 | 317 | 349 | WP_303646666.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [Haladaptatus sp. DYF46] | diamond | 102 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. DYF46 | |
| 28693622 | 28693622 | PRJNA703759_P_NODE_40527_length_249_cov_0.886364_g40051_i0 | PRJNA703759 | 40527 | 249 | 0.886364 | 2.20704636 | Halobacterium sp. KA-4 | 2896367 | Archaea | Archaea | 54.7 | 8.49e-8 | NR | WP_230888317.1 | 2896367 | g40051 | i0 | 82.4 | 0.409638554216867 | 34 | 6 | 41 | 0 | 103 | 2 | 1 | 34 | WP_230888317.1 hypothetical protein [Halobacterium sp. KA-4] | diamond | 102 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. KA-4 | |
| 28882744 | 28882744 | PRJNA703759_P_NODE_33568_length_255_cov_1.538462_g33092_i0 | PRJNA703759 | 33568 | 255 | 1.538462 | 3.9230781 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 106 | 6.810000000000001e-27 | NR | MBI1935991.1 | 2026803 | g33092 | i0 | 61.9 | 1.97647058823529 | 84 | 31 | 98.8 | 1 | 253 | 2 | 67 | 149 | MBI1935991.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 504 | 106 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 29009530 | 29009530 | PRJNA703759_P_NODE_20108_length_309_cov_1.593220_g19632_i0 | PRJNA703759 | 20108 | 309 | 1.59322 | 4.9230498 | Halorientalis marina | 2931976 | Archaea | Archaea | 43.5 | 0.0409 | NR | WP_246986624.1 | 2931976 | g19632 | i0 | 29.8 | 1.00970873786408 | 104 | 63 | 96.1 | 4 | 3 | 299 | 78 | 176 | WP_246986624.1 cytochrome P450 [Halorientalis marina] | diamond | 312 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis marina | |
| 29135671 | 29135671 | PRJNA703759_P_NODE_22129_length_297_cov_2.522321_g21653_i0 | PRJNA703759 | 22129 | 297 | 2.522321 | 7.49129337 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 72 | 1.17e-12 | NR | MFM8658386.1 | 2507556 | g21653 | i0 | 72 | 0.505050505050505 | 50 | 9 | 50.5 | 1 | 296 | 147 | 201 | 245 | MFM8658386.1 FAD:protein FMN transferase [Candidatus Nitrosotenuis sp.] | diamond | 150 | 72 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 29399111 | 29399111 | PRJNA703759_P_NODE_51229_length_242_cov_0.923077_g50753_i0 | PRJNA703759 | 51229 | 242 | 0.923077 | 2.23384634 | Halobacteriales | 2235 | Archaea | Archaea | 84 | 1.14e-16 | NR | WP_276410133.1 | 2237 | g50753 | i0 | 50.6 | 24.4710743801653 | 81 | 37 | 96.7 | 1 | 7 | 240 | 550 | 630 | WP_276410133.1 MULTISPECIES: DUF2309 domain-containing protein [Haloarcula] | diamond | 5922 | 84.7 | 0.991735537190083 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | ||
| 29893459 | 29893459 | PRJNA703759_P_NODE_46531_length_245_cov_0.906977_g46055_i0 | PRJNA703759 | 46531 | 245 | 0.906977 | 2.22209365 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 138 | 1.55e-36 | NR | MFC1754282.1 | 2056631 | g46055 | i0 | 75.3 | 1.98367346938776 | 81 | 20 | 99.2 | 0 | 243 | 1 | 393 | 473 | MFC1754282.1 sugar transferase [Thermoproteota archaeon] | diamond | 486 | 138 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30746295 | 30746295 | PRJNA703759_P_NODE_19134_length_315_cov_1.512397_g18658_i0 | PRJNA703759 | 19134 | 315 | 1.512397 | 4.76405055 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 163 | 6.62e-48 | NR | MFM8658386.1 | 2507556 | g18658 | i0 | 76.9 | 0.990476190476191 | 104 | 24 | 99 | 0 | 313 | 2 | 16 | 119 | MFM8658386.1 FAD:protein FMN transferase [Candidatus Nitrosotenuis sp.] | diamond | 312 | 163 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 32074356 | 32074356 | PRJNA703759_P_NODE_39038_length_250_cov_0.881356_g38562_i0 | PRJNA703759 | 39038 | 250 | 0.881356 | 2.20339 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 163 | 7.639999999999999e-47 | NR | HSB56699.1 | 2202732 | g38562 | i0 | 90.4 | 1.992 | 83 | 8 | 99.6 | 0 | 1 | 249 | 135 | 217 | HSB56699.1 aminotransferase class V-fold PLP-dependent enzyme [Nitrosopumilaceae archaeon] | diamond | 498 | 163 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 32422418 | 32422418 | PRJNA703759_P_NODE_51619_length_241_cov_2.011905_g51143_i0 | PRJNA703759 | 51619 | 241 | 2.011905 | 4.84869105 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 45.8 | 0.00293 | NR | MBU0527245.1 | 2250274 | g51143 | i0 | 61.3 | 0.385892116182573 | 31 | 12 | 38.6 | 0 | 235 | 143 | 389 | 419 | MBU0527245.1 transposase [Candidatus Micrarchaeota archaeon] | diamond | 93 | 45.8 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32549178 | 32549178 | PRJNA703759_P_NODE_26199_length_280_cov_1.507246_g25723_i0 | PRJNA703759 | 26199 | 280 | 1.507246 | 4.2202888 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 147 | 7.47e-39 | NR | TLX94279.1 | 2026795 | g25723 | i0 | 72.8 | 0.985714285714286 | 92 | 25 | 98.6 | 0 | 1 | 276 | 526 | 617 | TLX94279.1 MAG: DDE-type integrase/transposase/recombinase, partial [Nitrososphaerota archaeon] | diamond | 276 | 147 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32832418 | 32832418 | PRJNA703759_P_NODE_38940_length_250_cov_0.881356_g38464_i0 | PRJNA703759 | 38940 | 250 | 0.881356 | 2.20339 | archaeon | 1906665 | Archaea | Archaea | 65.1 | 4.48e-11 | NR | MFH1585237.1 | 1906665 | g38464 | i0 | 42.9 | 1.008 | 84 | 40 | 98.4 | 4 | 248 | 3 | 19 | 96 | MFH1585237.1 DNA N-6-adenine-methyltransferase [archaeon] | diamond | 252 | 65.1 | 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);;