contig_metadata
12 rows where bioproject = "PRJNA557436" and tax_clade = "Candidatus Pacearchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27868382 | 27868382 | PRJNA557436_S_NODE_3105_length_220_cov_2.400000_g3057_i0 | PRJNA557436 | 3105 | 220 | 2.4 | 5.28 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 47 | 9.11e-4 | NR | MBS3066591.1 | 2026773 | g3057 | i0 | 39.6 | 0.722727272727273 | 53 | 32 | 72.3 | 0 | 160 | 2 | 931 | 983 | MBS3066591.1 ribonuclease H-like domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 159 | 47 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28089466 | 28089466 | PRJNA557436_S_NODE_9185_length_152_cov_1.068376_g9137_i0 | PRJNA557436 | 9185 | 152 | 1.068376 | 1.62393152 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 64.7 | 3.32e-12 | NR | MCK9568580.1 | 2026773 | g9137 | i0 | 61.5 | 0.769736842105263 | 39 | 15 | 77 | 0 | 150 | 34 | 28 | 66 | MCK9568580.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 117 | 64.7 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28121110 | 28121110 | PRJNA557436_S_NODE_5805_length_175_cov_1.142857_g5757_i0 | PRJNA557436 | 5805 | 175 | 1.142857 | 1.99999975 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 70.1 | 2.21e-13 | NR | MAH50418.1 | 2026773 | g5757 | i0 | 60.3 | 0.994285714285714 | 58 | 23 | 99.4 | 0 | 175 | 2 | 37 | 94 | MAH50418.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 174 | 70.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28973758 | 28973758 | PRJNA557436_S_NODE_8508_length_155_cov_1.058333_g8460_i0 | PRJNA557436 | 8508 | 155 | 1.058333 | 1.64041615 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 69.3 | 3.26e-12 | NR | MCK5604707.1 | 2026773 | g8460 | i0 | 77.1 | 0.929032258064516 | 48 | 11 | 92.9 | 0 | 1 | 144 | 101 | 148 | MCK5604707.1 DUF5309 domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 144 | 69.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29320837 | 29320837 | PRJNA557436_S_NODE_1009_length_359_cov_1.462963_g961_i0 | PRJNA557436 | 1009 | 359 | 1.462963 | 5.25203717 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 112 | 2.46e-27 | NR | MAG25533.1 | 2026773 | g961 | i0 | 51.4 | 0.877437325905292 | 105 | 50 | 86.9 | 1 | 317 | 6 | 73 | 177 | MAG25533.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 315 | 112 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29415519 | 29415519 | PRJNA557436_S_NODE_3769_length_204_cov_1.928994_g3721_i0 | PRJNA557436 | 3769 | 204 | 1.928994 | 3.93514776 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 46.6 | 9.27e-4 | NR | MAG25533.1 | 2026773 | g3721 | i0 | 38.7 | 0.911764705882353 | 62 | 36 | 91.2 | 1 | 3 | 188 | 3 | 62 | MAG25533.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 186 | 46.6 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29573328 | 29573328 | PRJNA557436_S_NODE_4570_length_190_cov_1.574194_g4522_i0 | PRJNA557436 | 4570 | 190 | 1.574194 | 2.9909686 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 91.7 | 8.1800000000000005e-22 | NR | MCK5605839.1 | 2026773 | g4522 | i0 | 65.6 | 0.963157894736842 | 61 | 21 | 96.3 | 0 | 190 | 8 | 5 | 65 | MCK5605839.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 183 | 91.7 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29952469 | 29952469 | PRJNA557436_S_NODE_4731_length_187_cov_2.381579_g4683_i0 | PRJNA557436 | 4731 | 187 | 2.381579 | 4.45355273 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 63.2 | 1.11e-9 | NR | MCK5601933.1 | 2026773 | g4683 | i0 | 46.8 | 0.994652406417112 | 62 | 33 | 99.5 | 0 | 1 | 186 | 266 | 327 | MCK5601933.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 186 | 63.2 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30173549 | 30173549 | PRJNA557436_S_NODE_9012_length_152_cov_2.290598_g8964_i0 | PRJNA557436 | 9012 | 152 | 2.290598 | 3.48170896 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 48.9 | 7.14e-5 | NR | MCK5606892.1 | 2026773 | g8964 | i0 | 45.1 | 1.00657894736842 | 51 | 27 | 98.7 | 1 | 2 | 151 | 643 | 693 | MCK5606892.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 153 | 48.9 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32038755 | 32038755 | PRJNA557436_S_NODE_338_length_598_cov_2.813499_g298_i0 | PRJNA557436 | 338 | 598 | 2.813499 | 16.82472402 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 52.4 | 3.34e-4 | NR | MAG26708.1 | 2026773 | g298 | i0 | 34.3 | 0.496655518394649 | 99 | 53 | 49.7 | 1 | 126 | 422 | 8 | 94 | MAG26708.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 297 | 52.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32386761 | 32386761 | PRJNA557436_S_NODE_3199_length_217_cov_2.637363_g3151_i0 | PRJNA557436 | 3199 | 217 | 2.637363 | 5.72307771 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 67.8 | 4.01e-11 | NR | MCK5606892.1 | 2026773 | g3151 | i0 | 44.4 | 0.995391705069124 | 72 | 38 | 98.2 | 2 | 213 | 1 | 687 | 757 | MCK5606892.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 216 | 67.8 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32670899 | 32670899 | PRJNA557436_S_NODE_8740_length_154_cov_1.008403_g8692_i0 | PRJNA557436 | 8740 | 154 | 1.008403 | 1.55294062 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 51.6 | 4.26e-7 | NR | MCK5607935.1 | 2026773 | g8692 | i0 | 57.9 | 1.48051948051948 | 38 | 16 | 74 | 0 | 36 | 149 | 12 | 49 | MCK5607935.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 228 | 51.6 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota 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);;