contig_metadata
12 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Altarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9218913 | 9218913 | PRJNA1148190_P_NODE_13028_length_2644_cov_2.842863_g6980_i0 | PRJNA1148190 | 13028 | 2644 | 2.842863 | 75.16529772 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 322 | 2.3699999999999995e-99 | NR | MBU4266867.1 | 2599821 | g6980 | i0 | 54.1 | 1.37291981845688 | 307 | 133 | 34.2 | 3 | 134 | 1036 | 1 | 305 | MBU4266867.1 FAD-dependent oxidoreductase [Candidatus Altiarchaeota archaeon] | diamond | 3630 | 322 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 27545820 | 27545820 | PRJNA1148190_P_NODE_90384_length_567_cov_1.742915_g79246_i0 | PRJNA1148190 | 90384 | 567 | 1.742915 | 9.88232805 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 52 | 2.48e-4 | NR | MBD3260690.1 | 2250256 | g79246 | i0 | 44.6 | 0.296296296296296 | 56 | 31 | 29.6 | 0 | 383 | 550 | 3 | 58 | MBD3260690.1 hypothetical protein [Candidatus Altiarchaeales archaeon] | diamond | 168 | 52 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 28081436 | 28081436 | PRJNA1148190_P_NODE_215245_length_365_cov_1.154110_g204075_i0 | PRJNA1148190 | 215245 | 365 | 1.15411 | 4.2125015 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 116 | 2.5800000000000004e-27 | NR | MBD3260175.1 | 2250256 | g204075 | i0 | 47.4 | 5.91780821917808 | 133 | 58 | 99.5 | 2 | 365 | 3 | 468 | 600 | MBD3260175.1 hypothetical protein [Candidatus Altiarchaeales archaeon] | diamond | 2160 | 116 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 28333936 | 28333936 | PRJNA1148190_P_NODE_141606_length_442_cov_1.252033_g130441_i0 | PRJNA1148190 | 141606 | 442 | 1.252033 | 5.53398586 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 139 | 6.35e-36 | NR | MBD3260586.1 | 2250256 | g130441 | i0 | 58.3 | 0.780542986425339 | 115 | 48 | 78.1 | 0 | 98 | 442 | 263 | 377 | MBD3260586.1 toprim domain-containing protein [Candidatus Altiarchaeales archaeon] | diamond | 345 | 139 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 29596917 | 29596917 | PRJNA1148190_P_NODE_34470_length_1149_cov_1.895911_g24426_i0 | PRJNA1148190 | 34470 | 1149 | 1.895911 | 21.78401739 | Candidatus Altarchaeum sp. CG | 2817952 | Archaea | Archaea | 106 | 4.570000000000001e-22 | NR | PIV28955.1 | 2014241 | g24426 | i0 | 28.1 | 0.7911227154047 | 303 | 197 | 76.5 | 7 | 960 | 82 | 23 | 314 | PIV28955.1 MAG: hypothetical protein COS36_00220 [Candidatus Altarchaeum sp. CG03_land_8_20_14_0_80_32_618] | diamond | 909 | 106 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altarchaeaceae | Candidatus Altarchaeum | Candidatus Altarchaeum sp. CG03_land_8_20_14_0_80_32_618 | ||
| 29849657 | 29849657 | PRJNA1148190_P_NODE_153071_length_425_cov_1.360795_g141904_i0 | PRJNA1148190 | 153071 | 425 | 1.360795 | 5.78337875 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 100 | 1.9e-21 | NR | MBN2251641.1 | 2599821 | g141904 | i0 | 48.6 | 0.769411764705882 | 109 | 50 | 76.9 | 1 | 418 | 92 | 429 | 531 | MBN2251641.1 Eco57I restriction-modification methylase domain-containing protein [Candidatus Altiarchaeota archaeon] | diamond | 327 | 100 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 29850154 | 29850154 | PRJNA1148190_P_NODE_436851_length_279_cov_1.262136_g425678_i0 | PRJNA1148190 | 436851 | 279 | 1.262136 | 3.52135944 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 43.1 | 0.0381 | NR | MBD3260587.1 | 2250256 | g425678 | i0 | 32.9 | 0.78494623655914 | 73 | 46 | 75.3 | 2 | 213 | 4 | 41 | 113 | MBD3260587.1 uracil-DNA glycosylase [Candidatus Altiarchaeales archaeon] | diamond | 219 | 43.1 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 30344464 | 30344464 | PRJNA1148190_P_NODE_246032_length_345_cov_2.408088_g234862_i0 | PRJNA1148190 | 246032 | 345 | 2.408088 | 8.3079036 | root | 1 | Root_unresolved | Root_unresolved | 92 | 2.59e-20 | NR | MBD3260253.1 | 2250256 | g234862 | i0 | 44.2 | 1.69565217391304 | 95 | 53 | 82.6 | 0 | 342 | 58 | 106 | 200 | MBD3260253.1 hypothetical protein [Candidatus Altiarchaeales archaeon] | diamond | 585 | 92 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 31524784 | 31524784 | PRJNA1148190_P_NODE_276656_length_330_cov_1.498054_g265485_i0 | PRJNA1148190 | 276656 | 330 | 1.498054 | 4.9435782 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 112 | 2.42e-26 | NR | RLI90911.1 | 2250256 | g265485 | i0 | 47.8 | 1.98181818181818 | 113 | 55 | 99.1 | 3 | 1 | 327 | 253 | 365 | RLI90911.1 MAG: hypothetical protein DRO89_05010 [Candidatus Altiarchaeales archaeon] | diamond | 654 | 112 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales archaeon | ||||
| 32062486 | 32062486 | PRJNA1148190_P_NODE_368398_length_294_cov_1.171946_g357225_i0 | PRJNA1148190 | 368398 | 294 | 1.171946 | 3.44552124 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 58.9 | 1.39e-7 | NR | MFH1721562.1 | 2599821 | g357225 | i0 | 42.9 | 0.928571428571429 | 91 | 41 | 85.7 | 4 | 34 | 285 | 149 | 235 | MFH1721562.1 SAM-dependent methyltransferase [Candidatus Altiarchaeota archaeon] | diamond | 273 | 58.9 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 32694530 | 32694530 | PRJNA1148190_P_NODE_295280_length_322_cov_1.060241_g284107_i0 | PRJNA1148190 | 295280 | 322 | 1.060241 | 3.4139760199999998 | Candidatus Altiarchaeota archaeon | 2599821 | Archaea | Archaea | 50.1 | 2.25e-4 | NR | MFH0862054.1 | 2599821 | g284107 | i0 | 46.8 | 1.28571428571429 | 47 | 25 | 43.8 | 0 | 178 | 318 | 1 | 47 | MFH0862054.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Altiarchaeota archaeon] | diamond | 414 | 50.1 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeota archaeon | ||||||
| 32883808 | 32883808 | PRJNA1148190_P_NODE_50800_length_838_cov_2.284967_g39997_i0 | PRJNA1148190 | 50800 | 838 | 2.284967 | 19.14802346 | Candidatus Altiarchaeales archaeon | 2250256 | Archaea | Archaea | 209 | 1.26e-62 | NR | MBD3261818.1 | 2250256 | g39997 | i0 | 42.3 | 1.62529832935561 | 227 | 127 | 81.3 | 1 | 119 | 799 | 1 | 223 | MBD3261818.1 hypothetical protein [Candidatus Altiarchaeales archaeon] | diamond | 1362 | 209 | 1 | Archaea | Nanobdellati | Candidatus Altarchaeota | Candidatus Altiarchaeia | Candidatus Altarchaeales | Candidatus Altiarchaeales 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);;