contig_metadata
10 rows where bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4524683 | 4524683 | PRJNA704949_P_NODE_305284_length_487_cov_2.047945_g290458_i0 | PRJNA704949 | 305284 | 487 | 2.047945 | 9.97349215 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 186 | 3.1e-51 | NR | MCK9567728.1 | 2026773 | g290458 | i0 | 63.4 | 0.874743326488706 | 142 | 43 | 81.9 | 2 | 69 | 467 | 144 | 285 | MCK9567728.1 phage terminase large subunit family protein [Candidatus Pacearchaeota archaeon] | diamond | 426 | 186 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 27114518 | 27114518 | PRJNA704949_P_NODE_1740322_length_182_cov_1.172932_g1724983_i0 | PRJNA704949 | 1740322 | 182 | 1.172932 | 2.13473624 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 55.1 | 7.21e-7 | NR | MCK9570096.1 | 2026773 | g1724983 | i0 | 60.5 | 0.708791208791209 | 43 | 17 | 70.9 | 0 | 130 | 2 | 245 | 287 | MCK9570096.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 129 | 55.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 27209388 | 27209388 | PRJNA704949_P_NODE_1925122_length_169_cov_1.300000_g1909783_i0 | PRJNA704949 | 1925122 | 169 | 1.3 | 2.197 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 77.4 | 7.6e-15 | NR | MCK9567837.1 | 2026773 | g1909783 | i0 | 66 | 0.940828402366864 | 53 | 18 | 94.1 | 0 | 159 | 1 | 359 | 411 | MCK9567837.1 DUF559 domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 159 | 77.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 27936167 | 27936167 | PRJNA704949_P_NODE_249885_length_532_cov_2.693582_g235332_i0 | PRJNA704949 | 249885 | 532 | 2.693582 | 14.32985624 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 73.9 | 9.49e-13 | NR | MFA5484919.1 | 2026773 | g235332 | i0 | 72.3 | 0.513157894736842 | 47 | 13 | 26.5 | 0 | 525 | 385 | 141 | 187 | MFA5484919.1 IS607 family transposase [Candidatus Pacearchaeota archaeon] | diamond | 273 | 73.9 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30082903 | 30082903 | PRJNA704949_P_NODE_1742112_length_182_cov_1.172932_g1726773_i0 | PRJNA704949 | 1742112 | 182 | 1.172932 | 2.13473624 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 41.2 | 0.00867 | NR | MCK5612539.1 | 2026773 | g1726773 | i0 | 56.7 | 0.494505494505495 | 30 | 13 | 49.5 | 0 | 90 | 179 | 1 | 30 | MCK5612539.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 90 | 41.2 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30904871 | 30904871 | PRJNA704949_P_NODE_323574_length_474_cov_2.602353_g308676_i0 | PRJNA704949 | 323574 | 474 | 2.602353 | 12.33515322 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 105 | 4.0399999999999996e-24 | NR | MCK5602921.1 | 2026773 | g308676 | i0 | 40.8 | 0.930379746835443 | 147 | 83 | 91.1 | 2 | 453 | 22 | 45 | 190 | MCK5602921.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 441 | 105 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30978907 | 30978907 | PRJNA704949_P_NODE_384994_length_438_cov_0.971722_g369920_i0 | PRJNA704949 | 384994 | 438 | 0.971722 | 4.25614236 | root | 1 | Root_unresolved | Root_unresolved | 73.9 | 8.45e-13 | NR | MCK5617027.1 | 2026773 | g369920 | i0 | 51.7 | 1.98630136986301 | 58 | 28 | 39.7 | 0 | 4 | 177 | 171 | 228 | MCK5617027.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 870 | 73.9 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32549365 | 32549365 | PRJNA704949_P_NODE_1390879_length_211_cov_1.413580_g1375541_i0 | PRJNA704949 | 1390879 | 211 | 1.41358 | 2.9826538 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 63.5 | 1.07e-9 | NR | MCK9567837.1 | 2026773 | g1375541 | i0 | 54.4 | 0.81042654028436 | 57 | 26 | 81 | 0 | 176 | 6 | 300 | 356 | MCK9567837.1 DUF559 domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 171 | 63.5 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32843540 | 32843540 | PRJNA704949_P_NODE_936560_length_271_cov_1.405405_g921226_i0 | PRJNA704949 | 936560 | 271 | 1.405405 | 3.80864755 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0121 | NR | MCK5613390.1 | 2026773 | g921226 | i0 | 75 | 1.59409594095941 | 24 | 6 | 26.6 | 0 | 270 | 199 | 96 | 119 | MCK5613390.1 tRNA-binding protein [Candidatus Pacearchaeota archaeon] | diamond | 432 | 43.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32875026 | 32875026 | PRJNA704949_P_NODE_1832480_length_175_cov_1.650794_g1817141_i0 | PRJNA704949 | 1832480 | 175 | 1.650794 | 2.8888895 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00162 | NR | MCK9569075.1 | 2026773 | g1817141 | i0 | 39.3 | 1.88571428571429 | 56 | 31 | 96 | 1 | 170 | 3 | 332 | 384 | MCK9569075.1 DEAD/DEAH box helicase [Candidatus Pacearchaeota archaeon] | diamond | 330 | 45.8 | 0.991266375545852 | 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);;