contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3146828 | 3146828 | PRJNA615351_P_NODE_8843_length_2146_cov_6.032212_g6306_i0 | PRJNA615351 | 8843 | 2146 | 6.032212 | 129.45126952 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 148 | 5.42e-33 | NR | MDP4039392.1 | 2026773 | g6306 | i0 | 26.7 | 1.80475302889096 | 446 | 243 | 61.2 | 15 | 2 | 1315 | 94 | 463 | MDP4039392.1 aminopeptidase N [Candidatus Pacearchaeota archaeon] | diamond | 3873 | 148 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 26763987 | 26763987 | PRJNA615351_P_NODE_76721_length_448_cov_2.789346_g62709_i0 | PRJNA615351 | 76721 | 448 | 2.789346 | 12.49627008 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 80.5 | 1.08e-14 | NR | MAG26609.1 | 2026773 | g62709 | i0 | 73.5 | 0.328125 | 49 | 13 | 32.8 | 0 | 300 | 446 | 2 | 50 | MAG26609.1 UDP-glucose 4-epimerase [Candidatus Pacearchaeota archaeon] | diamond | 147 | 80.5 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 27175008 | 27175008 | PRJNA615351_P_NODE_159662_length_177_cov_1.521127_g145562_i0 | PRJNA615351 | 159662 | 177 | 1.521127 | 2.69239479 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 52.4 | 5.84e-6 | NR | MBS3081281.1 | 2026773 | g145562 | i0 | 45.5 | 3.4406779661017 | 55 | 29 | 93.2 | 1 | 12 | 176 | 251 | 304 | MBS3081281.1 FAD-dependent oxidoreductase [Candidatus Pacearchaeota archaeon] | diamond | 609 | 52.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28154404 | 28154404 | PRJNA615351_P_NODE_132365_length_221_cov_1.500000_g118265_i0 | PRJNA615351 | 132365 | 221 | 1.5 | 3.315 | Candidatus Pacearchaeota archaeon CG1 | 2026773 | Archaea | Archaea | 59.3 | 3.55e-8 | NR | PIO07672.1 | 1974443 | g118265 | i0 | 61.7 | 0.638009049773756 | 47 | 17 | 63.8 | 1 | 58 | 198 | 6 | 51 | PIO07672.1 MAG: hypothetical protein COU59_03115 [Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_34_12] | diamond | 141 | 59.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_34_12 | ||||||
| 28975198 | 28975198 | PRJNA615351_P_NODE_110368_length_279_cov_1.774590_g96269_i0 | PRJNA615351 | 110368 | 279 | 1.77459 | 4.9511061 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 50.1 | 1.11e-4 | NR | MBS3072430.1 | 2026773 | g96269 | i0 | 60 | 2.1505376344086 | 40 | 15 | 43 | 1 | 275 | 156 | 9 | 47 | MBS3072430.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Pacearchaeota archaeon] | diamond | 600 | 50.1 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29070030 | 29070030 | PRJNA615351_P_NODE_133888_length_218_cov_1.278689_g119788_i0 | PRJNA615351 | 133888 | 218 | 1.278689 | 2.78754202 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 51.6 | 1.81e-5 | NR | MCK5604596.1 | 2026773 | g119788 | i0 | 37.7 | 0.729357798165138 | 53 | 31 | 72.9 | 2 | 217 | 59 | 225 | 275 | MCK5604596.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 159 | 51.6 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29777357 | 29777357 | PRJNA615351_P_NODE_173551_length_162_cov_1.259843_g159451_i0 | PRJNA615351 | 173551 | 162 | 1.259843 | 2.04094566 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 2.74e-5 | NR | MCK5605676.1 | 2026773 | g159451 | i0 | 70.4 | 2.90740740740741 | 27 | 8 | 50 | 0 | 94 | 14 | 115 | 141 | MCK5605676.1 NADAR family protein [Candidatus Pacearchaeota archaeon] | diamond | 471 | 48.9 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30996680 | 30996680 | PRJNA615351_P_NODE_127894_length_231_cov_1.224490_g113794_i0 | PRJNA615351 | 127894 | 231 | 1.22449 | 2.8285719 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 84.7 | 2.21e-17 | NR | MBS3070868.1 | 2026773 | g113794 | i0 | 57.1 | 2.32467532467532 | 63 | 27 | 81.8 | 0 | 224 | 36 | 63 | 125 | MBS3070868.1 deoxyhypusine synthase [Candidatus Pacearchaeota archaeon] | diamond | 537 | 84.7 | 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);;