contig_metadata
10 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Hadarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2841636 | 2841636 | PRJNA1148190_P_NODE_12443_length_2736_cov_15.671799_g432_i7 | PRJNA1148190 | 12443 | 2736 | 15.671799 | 428.78042064 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 184 | 3.8e-50 | NR | MEM3453498.1 | 2883567 | g432 | i7 | 60.1 | 0.156798245614035 | 143 | 56 | 15.7 | 1 | 1588 | 1160 | 1 | 142 | MEM3453498.1 phage tail tube protein [Candidatus Hadarchaeum sp.] | diamond | 429 | 184 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 26996185 | 26996185 | PRJNA1148190_P_NODE_759802_length_242_cov_0.911243_g748629_i0 | PRJNA1148190 | 759802 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 64.7 | 6.08e-10 | NR | MEM4725085.1 | 2883567 | g748629 | i0 | 52.9 | 4.25206611570248 | 68 | 31 | 83.1 | 1 | 240 | 40 | 122 | 189 | MEM4725085.1 lamin tail domain-containing protein [Candidatus Hadarchaeum sp.] | diamond | 1029 | 64.7 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 28238994 | 28238994 | PRJNA1148190_P_NODE_115686_length_492_cov_1.417661_g104524_i0 | PRJNA1148190 | 115686 | 492 | 1.417661 | 6.97489212 | Candidatus Hadarchaeales archaeon | 3058034 | Archaea | Archaea | 48.5 | 0.00107 | NR | MEM2619184.1 | 3058034 | g104524 | i0 | 29.7 | 1.85365853658537 | 101 | 67 | 59.1 | 2 | 461 | 171 | 19 | 119 | MEM2619184.1 hypothetical protein [Candidatus Hadarchaeales archaeon] | diamond | 912 | 48.5 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeales archaeon | ||||
| 28428983 | 28428983 | PRJNA1148190_P_NODE_256866_length_340_cov_1.101124_g245696_i0 | PRJNA1148190 | 256866 | 340 | 1.101124 | 3.7438216 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 143 | 2.92e-41 | NR | MEM3453498.1 | 2883567 | g245696 | i0 | 58.7 | 0.961764705882353 | 109 | 45 | 96.2 | 0 | 4 | 330 | 34 | 142 | MEM3453498.1 phage tail tube protein [Candidatus Hadarchaeum sp.] | diamond | 327 | 143 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 28935140 | 28935140 | PRJNA1148190_P_NODE_90808_length_565_cov_3.792683_g79668_i0 | PRJNA1148190 | 90808 | 565 | 3.792683 | 21.42865895 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 181 | 6.1999999999999985e-55 | NR | MEM3453498.1 | 2883567 | g79668 | i0 | 60.1 | 0.75929203539823 | 143 | 56 | 75.9 | 1 | 111 | 539 | 1 | 142 | MEM3453498.1 phage tail tube protein [Candidatus Hadarchaeum sp.] | diamond | 429 | 181 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 29629132 | 29629132 | PRJNA1148190_P_NODE_709770_length_245_cov_0.895349_g698597_i0 | PRJNA1148190 | 709770 | 245 | 0.895349 | 2.19360505 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 90.5 | 5.110000000000001e-21 | NR | MEM3453498.1 | 2883567 | g698597 | i0 | 57.3 | 0.918367346938776 | 75 | 31 | 90.6 | 1 | 13 | 234 | 43 | 117 | MEM3453498.1 phage tail tube protein [Candidatus Hadarchaeum sp.] | diamond | 225 | 90.5 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 30102158 | 30102158 | PRJNA1148190_P_NODE_167612_length_407_cov_1.511976_g156443_i0 | PRJNA1148190 | 167612 | 407 | 1.511976 | 6.15374232 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 149 | 2.63e-40 | NR | MEM4724101.1 | 2883567 | g156443 | i0 | 68.1 | 0.692874692874693 | 94 | 30 | 69.3 | 0 | 3 | 284 | 322 | 415 | MEM4724101.1 phage major capsid protein [Candidatus Hadarchaeum sp.] | diamond | 282 | 149 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 30639304 | 30639304 | PRJNA1148190_P_NODE_163333_length_412_cov_1.439528_g152166_i0 | PRJNA1148190 | 163333 | 412 | 1.439528 | 5.93085536 | Candidatus Hadarchaeales archaeon | 3058034 | Archaea | Archaea | 43.5 | 0.01 | NR | MEM2908306.1 | 3058034 | g152166 | i0 | 38.5 | 0.378640776699029 | 52 | 30 | 36.4 | 1 | 191 | 340 | 4 | 55 | MEM2908306.1 hypothetical protein [Candidatus Hadarchaeales archaeon] | diamond | 156 | 43.5 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeales archaeon | ||||
| 31651519 | 31651519 | PRJNA1148190_P_NODE_5897_length_4949_cov_4.174323_g2833_i0 | PRJNA1148190 | 5897 | 4949 | 4.174323 | 206.58724527 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 187 | 2.53e-47 | NR | MEM4724101.1 | 2883567 | g2833 | i0 | 30.9 | 0.2570216205294 | 424 | 281 | 25.5 | 7 | 4724 | 3462 | 1 | 415 | MEM4724101.1 phage major capsid protein [Candidatus Hadarchaeum sp.] | diamond | 1272 | 187 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. | ||
| 32094226 | 32094226 | PRJNA1148190_P_NODE_384598_length_289_cov_1.601852_g373425_i0 | PRJNA1148190 | 384598 | 289 | 1.601852 | 4.62935228 | Candidatus Hadarchaeum sp. | 2883567 | Archaea | Archaea | 48.9 | 4.26e-4 | NR | MCJ7720110.1 | 2883567 | g373425 | i0 | 52.6 | 1.20415224913495 | 38 | 18 | 39.4 | 0 | 244 | 131 | 179 | 216 | MCJ7720110.1 hypothetical protein [Candidatus Hadarchaeum sp.] | diamond | 348 | 48.9 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum sp. |
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);;