contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20745899 | 20745899 | PRJNA1237347_P_NODE_500837_length_247_cov_2.988506_g494264_i0 | PRJNA1237347 | 500837 | 247 | 2.988506 | 7.38160982 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 99 | 5.34e-22 | NR | MBI5148367.1 | 2026773 | g494264 | i0 | 51.9 | 4.84615384615385 | 81 | 37 | 98.4 | 1 | 247 | 5 | 117 | 195 | MBI5148367.1 glutamine-hydrolyzing GMP synthase [Candidatus Pacearchaeota archaeon] | diamond | 1197 | 99 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 26724742 | 26724742 | PRJNA1237347_P_NODE_547061_length_242_cov_0.911243_g540488_i0 | PRJNA1237347 | 547061 | 242 | 0.911243 | 2.20520806 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 54.3 | 2.73e-7 | NR | MCK9568552.1 | 2026773 | g540488 | i0 | 53.2 | 0.582644628099174 | 47 | 19 | 54.5 | 2 | 133 | 2 | 23 | 69 | MCK9568552.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 141 | 54.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28336438 | 28336438 | PRJNA1237347_P_NODE_38506_length_1235_cov_2.099828_g34352_i0 | PRJNA1237347 | 38506 | 1235 | 2.099828 | 25.9328758 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 335 | 3.579999999999999e-107 | NR | MCK5600511.1 | 2026773 | g34352 | i0 | 56.2 | 0.782186234817814 | 322 | 136 | 77.5 | 3 | 1195 | 239 | 172 | 491 | MCK5600511.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 966 | 335 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29094423 | 29094423 | PRJNA1237347_P_NODE_430908_length_267_cov_1.190722_g424335_i0 | PRJNA1237347 | 430908 | 267 | 1.190722 | 3.17922774 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 90.1 | 9.4e-21 | NR | MCK5600512.1 | 2026773 | g424335 | i0 | 53.9 | 0.853932584269663 | 76 | 35 | 85.4 | 0 | 255 | 28 | 65 | 140 | MCK5600512.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 228 | 90.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29270291 | 29270291 | PRJNA1237347_P_NODE_248309_length_376_cov_1.752475_g241736_i0 | PRJNA1237347 | 248309 | 376 | 1.752475 | 6.589306 | root | 1 | Root_unresolved | Root_unresolved | 68.2 | 5.17e-12 | NR | MBS3099389.1 | 2026773 | g241736 | i0 | 39.6 | 3.6063829787234 | 96 | 54 | 75 | 3 | 302 | 21 | 1 | 94 | MBS3099389.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 1356 | 68.2 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30010165 | 30010165 | PRJNA1237347_P_NODE_394571_length_282_cov_1.229665_g387998_i0 | PRJNA1237347 | 394571 | 282 | 1.229665 | 3.4676553 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 106 | 1.0600000000000002e-27 | NR | HOS12476.1 | 2026773 | g387998 | i0 | 58.1 | 0.787234042553192 | 74 | 31 | 78.7 | 0 | 4 | 225 | 13 | 86 | HOS12476.1 zinc ribbon domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 222 | 106 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30862823 | 30862823 | PRJNA1237347_P_NODE_261354_length_364_cov_2.013746_g254781_i0 | PRJNA1237347 | 261354 | 364 | 2.013746 | 7.33003544 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 50.1 | 4.07e-4 | NR | MBR9701694.1 | 2026773 | g254781 | i0 | 36.4 | 0.634615384615385 | 77 | 48 | 62.6 | 1 | 324 | 97 | 808 | 884 | MBR9701694.1 DUF5011 domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 231 | 50.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31052516 | 31052516 | PRJNA1237347_P_NODE_108975_length_645_cov_1.625874_g102516_i0 | PRJNA1237347 | 108975 | 645 | 1.625874 | 10.4868873 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 57.4 | 6.64e-7 | NR | MCK5600513.1 | 2026773 | g102516 | i0 | 28.1 | 0.530232558139535 | 114 | 78 | 53 | 2 | 26 | 367 | 1 | 110 | MCK5600513.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 342 | 57.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31178684 | 31178684 | PRJNA1237347_P_NODE_374915_length_290_cov_1.870968_g368342_i0 | PRJNA1237347 | 374915 | 290 | 1.870968 | 5.4258072 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 83.2 | 6.47e-17 | NR | MBL7059037.1 | 2026773 | g368342 | i0 | 56.1 | 2.73103448275862 | 66 | 27 | 68.3 | 1 | 91 | 288 | 1 | 64 | MBL7059037.1 exodeoxyribonuclease III [Candidatus Pacearchaeota archaeon] | diamond | 792 | 83.2 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 31906272 | 31906272 | PRJNA1237347_P_NODE_260417_length_365_cov_1.537671_g253844_i0 | PRJNA1237347 | 260417 | 365 | 1.537671 | 5.61249915 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 48.5 | 0.00141 | NR | MCK5607152.1 | 2026773 | g253844 | i0 | 36.4 | 0.723287671232877 | 88 | 50 | 68.2 | 3 | 19 | 267 | 7 | 93 | MCK5607152.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 264 | 48.5 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32032936 | 32032936 | PRJNA1237347_P_NODE_304878_length_331_cov_0.868217_g298305_i0 | PRJNA1237347 | 304878 | 331 | 0.868217 | 2.87379827 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 47 | 0.00334 | NR | MCK5613876.1 | 2026773 | g298305 | i0 | 31.5 | 1.95770392749245 | 111 | 73 | 98.8 | 3 | 3 | 329 | 323 | 432 | MCK5613876.1 LamG domain-containing protein [Candidatus Pacearchaeota archaeon] | diamond | 648 | 47 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32096397 | 32096397 | PRJNA1237347_P_NODE_486498_length_249_cov_1.465909_g479925_i0 | PRJNA1237347 | 486498 | 249 | 1.465909 | 3.65011341 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 74.3 | 3.06e-13 | NR | MEM1535065.1 | 2026773 | g479925 | i0 | 46.3 | 0.987951807228916 | 82 | 40 | 94 | 1 | 249 | 16 | 358 | 439 | MEM1535065.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Pacearchaeota archaeon] | diamond | 246 | 74.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 32317873 | 32317873 | PRJNA1237347_P_NODE_209899_length_420_cov_1.331412_g203327_i0 | PRJNA1237347 | 209899 | 420 | 1.331412 | 5.5919304 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 47 | 0.00305 | NR | MEM4259439.1 | 2026773 | g203327 | i0 | 37 | 0.571428571428571 | 46 | 29 | 32.9 | 0 | 283 | 420 | 98 | 143 | MEM4259439.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 240 | 47 | 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);;