contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Micrarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19465553 | 19465553 | PRJNA1237347_P_NODE_247536_length_377_cov_1.266447_g240963_i0 | PRJNA1237347 | 247536 | 377 | 1.266447 | 4.77450519 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 116 | 3.7199999999999995e-30 | NR | MEM0150155.1 | 2953041 | g240963 | i0 | 58.6 | 0.787798408488064 | 99 | 41 | 78.8 | 0 | 298 | 2 | 13 | 111 | MEM0150155.1 EF-hand domain-containing protein [Candidatus Micrarchaeaceae archaeon] | diamond | 297 | 116 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 27135944 | 27135944 | PRJNA1237347_P_NODE_397302_length_281_cov_1.086538_g390729_i0 | PRJNA1237347 | 397302 | 281 | 1.086538 | 3.05317178 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 117 | 5.7899999999999995e-30 | NR | MFH1095196.1 | 2250274 | g390729 | i0 | 60.9 | 16.0996441281139 | 92 | 36 | 98.2 | 0 | 5 | 280 | 142 | 233 | MFH1095196.1 lipopolysaccharide biosynthesis protein RfbH [Candidatus Micrarchaeota archaeon] | diamond | 4524 | 117 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 27768298 | 27768298 | PRJNA1237347_P_NODE_333744_length_312_cov_2.087866_g327171_i0 | PRJNA1237347 | 333744 | 312 | 2.087866 | 6.51414192 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 53.1 | 6.06e-6 | NR | MCS7109234.1 | 2250274 | g327171 | i0 | 34.7 | 2.625 | 101 | 59 | 95.2 | 3 | 311 | 15 | 1 | 96 | MCS7109234.1 tRNA-intron lyase [Candidatus Micrarchaeota archaeon] | diamond | 819 | 53.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 27818327 | 27818327 | PRJNA1237347_P_NODE_433904_length_266_cov_0.870466_g427331_i0 | PRJNA1237347 | 433904 | 266 | 0.870466 | 2.31543956 | Archaea | 2157 | Archaea | Archaea | 43.9 | 0.0195 | NR | MBU1197359.1 | 2250274 | g427331 | i0 | 41.1 | 1.35338345864662 | 56 | 30 | 59.8 | 1 | 24 | 182 | 318 | 373 | MBU1197359.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Micrarchaeota archaeon] | diamond | 360 | 44.3 | 0.99097065462754 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 28620531 | 28620531 | PRJNA1237347_P_NODE_196747_length_438_cov_1.978082_g190175_i0 | PRJNA1237347 | 196747 | 438 | 1.978082 | 8.66399916 | Candidatus Anstonellales archaeon | 3058027 | Archaea | Archaea | 102 | 2.08e-22 | NR | MEM3373391.1 | 3058027 | g190175 | i0 | 45.8 | 2.48630136986301 | 120 | 65 | 82.2 | 0 | 44 | 403 | 38 | 157 | MEM3373391.1 hypothetical protein [Candidatus Anstonellales archaeon] | diamond | 1089 | 102 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Anstonellales archaeon | ||||
| 28778062 | 28778062 | PRJNA1237347_P_NODE_173887_length_476_cov_1.198511_g167316_i0 | PRJNA1237347 | 173887 | 476 | 1.198511 | 5.70491236 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 45.1 | 0.0257 | NR | MBD3390005.1 | 2250274 | g167316 | i0 | 31.8 | 0.554621848739496 | 88 | 59 | 54.8 | 1 | 292 | 32 | 37 | 124 | MBD3390005.1 hypothetical protein [Candidatus Micrarchaeota archaeon] | diamond | 264 | 45.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 30452333 | 30452333 | PRJNA1237347_P_NODE_224213_length_402_cov_1.556231_g217641_i0 | PRJNA1237347 | 224213 | 402 | 1.556231 | 6.25604862 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 176 | 3.51e-49 | NR | MEM0150161.1 | 2953041 | g217641 | i0 | 59.9 | 1.09701492537313 | 147 | 43 | 99.3 | 2 | 401 | 3 | 197 | 341 | MEM0150161.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] | diamond | 441 | 176 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 31337260 | 31337260 | PRJNA1237347_P_NODE_91456_length_721_cov_23.364198_g85183_i0 | PRJNA1237347 | 91456 | 721 | 23.364198 | 168.45586758 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 51.2 | 5.69e-4 | NR | MCC7570764.1 | 2250274 | g85183 | i0 | 33.3 | 0.411927877947295 | 99 | 62 | 40.8 | 3 | 368 | 75 | 72 | 167 | MCC7570764.1 GNAT family N-acetyltransferase [Candidatus Micrarchaeota archaeon] | diamond | 297 | 51.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31464058 | 31464058 | PRJNA1237347_P_NODE_559716_length_238_cov_2.115152_g553143_i0 | PRJNA1237347 | 559716 | 238 | 2.115152 | 5.03406176 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 48.5 | 1.94e-4 | NR | MBD3389969.1 | 2250274 | g553143 | i0 | 52.9 | 0.857142857142857 | 34 | 16 | 42.9 | 0 | 55 | 156 | 143 | 176 | MBD3389969.1 glutamine-hydrolyzing GMP synthase [Candidatus Micrarchaeota archaeon] | diamond | 204 | 48.5 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31653292 | 31653292 | PRJNA1237347_P_NODE_450877_length_259_cov_1.241935_g444304_i0 | PRJNA1237347 | 450877 | 259 | 1.241935 | 3.21661165 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 115 | 3.82e-28 | NR | MFH0884207.1 | 2250274 | g444304 | i0 | 66.3 | 2.8030888030888 | 80 | 25 | 92.7 | 1 | 5 | 244 | 213 | 290 | MFH0884207.1 ATP citrate lyase citrate-binding domain-containing protein [Candidatus Micrarchaeota archaeon] | diamond | 726 | 115 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32064386 | 32064386 | PRJNA1237347_P_NODE_254498_length_370_cov_2.609428_g247925_i0 | PRJNA1237347 | 254498 | 370 | 2.609428 | 9.6548836 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 83.6 | 1.62e-17 | NR | MBI5227603.1 | 2250274 | g247925 | i0 | 42.7 | 1.58918918918919 | 96 | 53 | 77.8 | 1 | 83 | 370 | 3 | 96 | MBI5227603.1 GNAT family N-acetyltransferase [Candidatus Micrarchaeota archaeon] | diamond | 588 | 83.6 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32128248 | 32128248 | PRJNA1237347_P_NODE_463278_length_254_cov_1.397790_g456705_i0 | PRJNA1237347 | 463278 | 254 | 1.39779 | 3.5503866 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 134 | 1.3599999999999998e-35 | NR | MBD3210255.1 | 2250274 | g456705 | i0 | 73.8 | 13.511811023622 | 84 | 22 | 99.2 | 0 | 253 | 2 | 221 | 304 | MBD3210255.1 ATPase [Candidatus Micrarchaeota archaeon] | diamond | 3432 | 134 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32475967 | 32475967 | PRJNA1237347_P_NODE_229179_length_396_cov_2.256966_g222607_i0 | PRJNA1237347 | 229179 | 396 | 2.256966 | 8.93758536 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 59.7 | 9.35e-8 | NR | MBI5223301.1 | 2250274 | g222607 | i0 | 45.5 | 1.1969696969697 | 77 | 41 | 58.3 | 1 | 6 | 236 | 140 | 215 | MBI5223301.1 aquaporin [Candidatus Micrarchaeota archaeon] | diamond | 474 | 59.7 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota 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);;