contig_metadata
10 rows where bioproject = "PRJNA560932", tax_phylum = "Candidatus Woesearchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15847701 | 15847701 | PRJNA560932_P_NODE_61093_length_245_cov_0.895349_g60737_i0 | PRJNA560932 | 61093 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 110 | 7.39e-26 | NR | MBR9700236.1 | 2026803 | g60737 | i0 | 67.1 | 8.03265306122449 | 82 | 21 | 99.2 | 2 | 2 | 244 | 188 | 264 | MBR9700236.1 methionine--tRNA ligase [Candidatus Woesearchaeota archaeon] | diamond | 1968 | 110 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 26618164 | 26618164 | PRJNA560932_P_NODE_60961_length_245_cov_0.895349_g60605_i0 | PRJNA560932 | 60961 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 115 | 3.0899999999999998e-28 | NR | MFT4303816.1 | 2026803 | g60605 | i0 | 63 | 3.95510204081633 | 81 | 30 | 99.2 | 0 | 245 | 3 | 308 | 388 | MFT4303816.1 deoxyribodipyrimidine photo-lyase [Candidatus Woesearchaeota archaeon] | diamond | 969 | 115 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 28626662 | 28626662 | PRJNA560932_P_NODE_17287_length_423_cov_1.100000_g16931_i0 | PRJNA560932 | 17287 | 423 | 1.1 | 4.653 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 56.6 | 1.66e-6 | NR | RJQ22560.1 | 2026803 | g16931 | i0 | 37.9 | 1.73049645390071 | 66 | 37 | 44 | 1 | 263 | 78 | 32 | 97 | RJQ22560.1 MAG: hypothetical protein C4580_00730 [Candidatus Woesearchaeota archaeon] | diamond | 732 | 56.6 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 30300618 | 30300618 | PRJNA560932_P_NODE_252_length_2138_cov_3.168039_g201_i0 | PRJNA560932 | 252 | 2138 | 3.168039 | 67.73267382 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 54.3 | 0.0025 | NR | MCB9370421.1 | 2026803 | g201 | i0 | 32.1 | 0.188026192703461 | 134 | 80 | 17.7 | 3 | 470 | 847 | 707 | 837 | MCB9370421.1 ATP-dependent helicase [Candidatus Woesearchaeota archaeon] | diamond | 402 | 54.3 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 30503809 | 30503809 | PRJNA560932_P_NODE_8753_length_588_cov_1.481553_g8400_i0 | PRJNA560932 | 8753 | 588 | 1.481553 | 8.71153164 | Nanobdellati | 1783276 | Archaea | Archaea | 283 | 4.52e-93 | NR | MEK9774389.1 | 2026803 | g8400 | i0 | 73.2 | 1.94897959183673 | 190 | 51 | 96.9 | 0 | 581 | 12 | 93 | 282 | MEK9774389.1 IMP dehydrogenase [Candidatus Woesearchaeota archaeon] | diamond | 1146 | 284 | 0.996478873239437 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31311241 | 31311241 | PRJNA560932_P_NODE_36875_length_299_cov_1.619469_g36519_i0 | PRJNA560932 | 36875 | 299 | 1.619469 | 4.84221231 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 44.7 | 0.0156 | NR | MBW2989423.1 | 2026803 | g36519 | i0 | 43.1 | 0.722408026755853 | 72 | 26 | 61.2 | 3 | 294 | 112 | 538 | 605 | MBW2989423.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 216 | 44.7 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31515360 | 31515360 | PRJNA560932_P_NODE_17296_length_423_cov_0.865714_g16940_i0 | PRJNA560932 | 17296 | 423 | 0.865714 | 3.66197022 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 4.99e-10 | NR | MDP7116136.1 | 2026803 | g16940 | i0 | 37.3 | 3.66666666666667 | 134 | 72 | 92.2 | 5 | 392 | 3 | 30 | 155 | MDP7116136.1 MIP family channel protein [Candidatus Woesearchaeota archaeon] | diamond | 1551 | 66.6 | 0.993993993993994 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32038892 | 32038892 | PRJNA560932_P_NODE_19678_length_397_cov_1.305556_g19322_i0 | PRJNA560932 | 19678 | 397 | 1.305556 | 5.18305732 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 48.5 | 0.00195 | NR | MBI2664469.1 | 2026803 | g19322 | i0 | 37.8 | 0.740554156171285 | 98 | 52 | 70.3 | 3 | 29 | 307 | 640 | 733 | MBI2664469.1 fibronectin type III domain-containing protein [Candidatus Woesearchaeota archaeon] | diamond | 294 | 48.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32070517 | 32070517 | PRJNA560932_P_NODE_32818_length_316_cov_1.818930_g32462_i0 | PRJNA560932 | 32818 | 316 | 1.81893 | 5.7478188 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 48.1 | 0.00115 | NR | MCB9370421.1 | 2026803 | g32462 | i0 | 34 | 1.00632911392405 | 106 | 64 | 97.8 | 2 | 312 | 4 | 730 | 832 | MCB9370421.1 ATP-dependent helicase [Candidatus Woesearchaeota archaeon] | diamond | 318 | 48.1 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32369502 | 32369502 | PRJNA560932_P_NODE_26559_length_347_cov_1.364964_g26203_i0 | PRJNA560932 | 26559 | 347 | 1.364964 | 4.73642508 | root | 1 | Root_unresolved | Root_unresolved | 93.6 | 1.24e-21 | NR | MBL7054619.1 | 2026803 | g26203 | i0 | 52.9 | 2.19596541786744 | 85 | 38 | 71.8 | 2 | 1 | 249 | 9 | 93 | MBL7054619.1 ribose 5-phosphate isomerase B [Candidatus Woesearchaeota archaeon] | diamond | 762 | 94.4 | 0.991525423728813 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota 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);;