contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1061474" and tax_phylum = "Candidatus Bathyarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26782423 | 26782423 | PRJNA1061474_P_NODE_47921_length_249_cov_0.875000_g47675_i0 | PRJNA1061474 | 47921 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 50.4 | 5.82e-5 | NR | MDI6691073.1 | 2026714 | g47675 | i0 | 72.7 | 0.397590361445783 | 33 | 9 | 39.8 | 0 | 99 | 1 | 25 | 57 | MDI6691073.1 molybdenum cofactor guanylyltransferase [Candidatus Bathyarchaeota archaeon] | diamond | 99 | 50.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27288301 | 27288301 | PRJNA1061474_P_NODE_53763_length_244_cov_0.900585_g53517_i0 | PRJNA1061474 | 53763 | 244 | 0.900585 | 2.1974274 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 125 | 3.3799999999999995e-32 | NR | MFH0748580.1 | 2026714 | g53517 | i0 | 73.8 | 0.983606557377049 | 80 | 21 | 98.4 | 0 | 243 | 4 | 38 | 117 | MFH0748580.1 pyridoxal phosphate-dependent aminotransferase [Candidatus Bathyarchaeota archaeon] | diamond | 240 | 125 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27509587 | 27509587 | PRJNA1061474_P_NODE_45923_length_251_cov_0.865169_g45677_i0 | PRJNA1061474 | 45923 | 251 | 0.865169 | 2.17157419 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 122 | 4.1799999999999996e-32 | NR | MCX6648811.1 | 2026714 | g45677 | i0 | 93.4 | 0.729083665338645 | 61 | 4 | 72.9 | 0 | 67 | 249 | 1 | 61 | MCX6648811.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 183 | 122 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27699250 | 27699250 | PRJNA1061474_P_NODE_51764_length_246_cov_0.890173_g51518_i0 | PRJNA1061474 | 51764 | 246 | 0.890173 | 2.18982558 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 150 | 2.319999999999999e-41 | NR | HEX4921276.1 | 3045160 | g51518 | i0 | 85.2 | 4.9390243902439 | 81 | 12 | 98.8 | 0 | 2 | 244 | 87 | 167 | HEX4921276.1 MBL fold metallo-hydrolase [Candidatus Bathyarchaeia archaeon] | diamond | 1215 | 150 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 27825317 | 27825317 | PRJNA1061474_P_NODE_55624_length_243_cov_0.905882_g55378_i0 | PRJNA1061474 | 55624 | 243 | 0.905882 | 2.20129326 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 89.7 | 2.34e-19 | NR | HUK42860.1 | 3045160 | g55378 | i0 | 56.3 | 1.97530864197531 | 80 | 35 | 98.8 | 0 | 3 | 242 | 45 | 124 | HUK42860.1 carbohydrate kinase [Candidatus Bathyarchaeia archaeon] | diamond | 480 | 89.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28077684 | 28077684 | PRJNA1061474_P_NODE_51805_length_246_cov_0.890173_g51559_i0 | PRJNA1061474 | 51805 | 246 | 0.890173 | 2.18982558 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 55.1 | 1.73e-6 | NR | MDH5753783.1 | 2026714 | g51559 | i0 | 77.4 | 0.75609756097561 | 31 | 7 | 37.8 | 0 | 154 | 246 | 1 | 31 | MDH5753783.1 FAD-binding oxidoreductase [Candidatus Bathyarchaeota archaeon] | diamond | 186 | 55.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 28267027 | 28267027 | PRJNA1061474_P_NODE_51906_length_246_cov_0.890173_g51660_i0 | PRJNA1061474 | 51906 | 246 | 0.890173 | 2.18982558 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 145 | 2.5e-39 | NR | TFH23394.1 | 2026714 | g51660 | i0 | 87.8 | 3.97560975609756 | 82 | 10 | 100 | 0 | 246 | 1 | 120 | 201 | TFH23394.1 MAG: NAD(P)/FAD-dependent oxidoreductase [Candidatus Bathyarchaeota archaeon] | diamond | 978 | 145 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 28993727 | 28993727 | PRJNA1061474_P_NODE_51868_length_246_cov_0.890173_g51622_i0 | PRJNA1061474 | 51868 | 246 | 0.890173 | 2.18982558 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 134 | 6.1e-39 | NR | HXX98983.1 | 3045160 | g51622 | i0 | 91.7 | 0.878048780487805 | 72 | 6 | 87.8 | 0 | 218 | 3 | 1 | 72 | HXX98983.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 216 | 134 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29246015 | 29246015 | PRJNA1061474_P_NODE_48909_length_248_cov_0.880000_g48663_i0 | PRJNA1061474 | 48909 | 248 | 0.88 | 2.1824 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 99 | 6.5900000000000005e-22 | NR | MCW3996832.1 | 2026714 | g48663 | i0 | 59.8 | 0.991935483870968 | 82 | 25 | 99.2 | 1 | 246 | 1 | 283 | 356 | MCW3996832.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Bathyarchaeota archaeon] | diamond | 246 | 99 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30698906 | 30698906 | PRJNA1061474_P_NODE_55374_length_243_cov_0.905882_g55128_i0 | PRJNA1061474 | 55374 | 243 | 0.905882 | 2.20129326 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 153 | 1.02e-42 | NR | HJW65537.1 | 3045160 | g55128 | i0 | 88.8 | 5.92592592592593 | 80 | 9 | 98.8 | 0 | 242 | 3 | 38 | 117 | HJW65537.1 adenosylhomocysteinase [Candidatus Bathyarchaeia archaeon] | diamond | 1440 | 153 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 31046830 | 31046830 | PRJNA1061474_P_NODE_50195_length_247_cov_0.885057_g49949_i0 | PRJNA1061474 | 50195 | 247 | 0.885057 | 2.18609079 | Candidatus Bathyarchaeota archaeon RBG_16_48_13 | 1797381 | Archaea | Archaea | 120 | 1.15e-30 | NR | OGD45815.1 | 1797381 | g49949 | i0 | 71.4 | 1.02024291497976 | 84 | 22 | 99.6 | 1 | 246 | 1 | 173 | 256 | OGD45815.1 MAG: hypothetical protein A3K70_04550 [Candidatus Bathyarchaeota archaeon RBG_16_48_13] | diamond | 252 | 120 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon RBG_16_48_13 | ||||||
| 32312012 | 32312012 | PRJNA1061474_P_NODE_47899_length_249_cov_0.875000_g47653_i0 | PRJNA1061474 | 47899 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 154 | 1.59e-41 | NR | MCW4029465.1 | 2026714 | g47653 | i0 | 87.8 | 0.987951807228916 | 82 | 10 | 98.8 | 0 | 248 | 3 | 37 | 118 | MCW4029465.1 alpha amylase C-terminal domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 246 | 154 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32312018 | 32312018 | PRJNA1061474_P_NODE_56139_length_242_cov_0.911243_g55893_i0 | PRJNA1061474 | 56139 | 242 | 0.911243 | 2.20520806 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 152 | 1.2499999999999997e-42 | NR | MCJ7560518.1 | 2026714 | g55893 | i0 | 93.8 | 4.94628099173554 | 80 | 5 | 99.2 | 0 | 240 | 1 | 14 | 93 | MCJ7560518.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 1197 | 152 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32343616 | 32343616 | PRJNA1061474_P_NODE_55019_length_243_cov_0.905882_g54773_i0 | PRJNA1061474 | 55019 | 243 | 0.905882 | 2.20129326 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 149 | 5.509999999999999e-42 | NR | NLF88595.1 | 2026714 | g54773 | i0 | 93.8 | 0.987654320987654 | 80 | 5 | 98.8 | 0 | 242 | 3 | 55 | 134 | NLF88595.1 hydrogenase [Candidatus Bathyarchaeota archaeon] | diamond | 240 | 149 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32848182 | 32848182 | PRJNA1061474_P_NODE_49260_length_248_cov_0.880000_g49014_i0 | PRJNA1061474 | 49260 | 248 | 0.88 | 2.1824 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 169 | 2.38e-49 | NR | HYA82435.1 | 3045160 | g49014 | i0 | 93.9 | 1.98387096774194 | 82 | 5 | 99.2 | 0 | 3 | 248 | 257 | 338 | HYA82435.1 carbohydrate-binding protein [Candidatus Bathyarchaeia archaeon] | diamond | 492 | 169 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia 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);;