contig_metadata
16 rows where analysis = "diamond" and tax_phylum = "Candidatus Hydrothermarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27491692 | 27491692 | PRJNA630162_P_NODE_81323_length_200_cov_1.324503_g79800_i0 | PRJNA630162 | 81323 | 200 | 1.324503 | 2.649006 | Candidatus Hydrothermarchaeaceae archaeon | 3107143 | Archaea | Archaea | 48.1 | 2.6e-4 | NR | MEE8403649.1 | 3107143 | g79800 | i0 | 48.9 | 0.675 | 45 | 23 | 67.5 | 0 | 169 | 35 | 151 | 195 | MEE8403649.1 hypothetical protein [Candidatus Hydrothermarchaeaceae archaeon] | diamond | 135 | 48.1 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeaceae | Candidatus Hydrothermarchaeaceae archaeon | |||
| 27902422 | 27902422 | PRJNA657343_P_NODE_4625_length_356_cov_2.110749_g4602_i0 | PRJNA657343 | 4625 | 356 | 2.110749 | 7.51426644 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 95.1 | 3.39e-21 | NR | MFQ5887953.1 | 3107144 | g4602 | i0 | 45.8 | 2.62921348314607 | 107 | 55 | 89.3 | 2 | 36 | 353 | 19 | 123 | MFQ5887953.1 30S ribosomal protein S4e [Candidatus Hydrothermarchaeales archaeon] | diamond | 936 | 95.1 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 29318447 | 29318447 | PRJNA493244_P_NODE_1148929_length_347_cov_1.751748_g1125805_i0 | PRJNA493244 | 1148929 | 347 | 1.751748 | 6.07856556 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 43.9 | 0.0412 | NR | MEE8167398.1 | 3107144 | g1125805 | i0 | 42.2 | 0.553314121037464 | 64 | 33 | 55.3 | 2 | 63 | 254 | 167 | 226 | MEE8167398.1 Fic family protein [Candidatus Hydrothermarchaeales archaeon] | diamond | 192 | 43.9 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 29541829 | 29541829 | PRJNA557436_S_NODE_430_length_531_cov_3.141129_g386_i0 | PRJNA557436 | 430 | 531 | 3.141129 | 16.67939499 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 52.8 | 1.97e-5 | NR | MEE9594261.1 | 3107144 | g386 | i0 | 53.3 | 0.254237288135593 | 45 | 21 | 25.4 | 0 | 136 | 2 | 15 | 59 | MEE9594261.1 hypothetical protein [Candidatus Hydrothermarchaeales archaeon] | diamond | 135 | 52.8 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 29640717 | 29640717 | PRJNA704949_P_NODE_281250_length_505_cov_2.473684_g266541_i0 | PRJNA704949 | 281250 | 505 | 2.473684 | 12.4921042 | Candidatus Hydrothermarchaeaceae archaeon | 3107143 | Archaea | Archaea | 56.2 | 1.12e-6 | NR | MEE9564908.1 | 3107143 | g266541 | i0 | 35.4 | 0.487128712871287 | 82 | 53 | 48.7 | 0 | 127 | 372 | 3 | 84 | MEE9564908.1 SpoVG family protein [Candidatus Hydrothermarchaeaceae archaeon] | diamond | 246 | 56.2 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeaceae | Candidatus Hydrothermarchaeaceae archaeon | |||
| 30277475 | 30277475 | PRJNA906294_P_NODE_191512_length_264_cov_1.089005_g187396_i0 | PRJNA906294 | 191512 | 264 | 1.089005 | 2.8749732 | Candidatus Hydrothermarchaeota archaeon | 2250275 | Archaea | Archaea | 42.4 | 0.0263 | NR | RLG56997.1 | 2250275 | g187396 | i0 | 51.3 | 0.443181818181818 | 39 | 19 | 44.3 | 0 | 120 | 4 | 87 | 125 | RLG56997.1 MAG: hypothetical protein DRN88_03320 [Candidatus Hydrothermarchaeota archaeon] | diamond | 117 | 42.4 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeota archaeon | ||||||
| 30371629 | 30371629 | PRJNA876641_P_NODE_10232_length_281_cov_1.043269_g10158_i0 | PRJNA876641 | 10232 | 281 | 1.043269 | 2.93158589 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 51.6 | 3.65e-5 | NR | MFQ6137201.1 | 3107144 | g10158 | i0 | 38.8 | 3.73665480427046 | 85 | 35 | 90.7 | 3 | 262 | 8 | 186 | 253 | MFQ6137201.1 prephenate dehydratase [Candidatus Hydrothermarchaeales archaeon] | diamond | 1050 | 51.6 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 30412716 | 30412716 | PRJEB30004_P_NODE_124993_length_534_cov_1.773737_g109587_i0 | PRJEB30004 | 124993 | 534 | 1.773737 | 9.47175558 | Candidatus Hydrothermarchaeota archaeon | 2250275 | Archaea | Archaea | 57.4 | 1.1e-6 | NR | MFQ6052574.1 | 2250275 | g109587 | i0 | 36.7 | 0.50561797752809 | 90 | 46 | 45.5 | 4 | 532 | 290 | 83 | 170 | MFQ6052574.1 hypothetical protein [Candidatus Hydrothermarchaeota archaeon] | diamond | 270 | 57.4 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeota archaeon | ||||||
| 30655863 | 30655863 | PRJNA895185_P_NODE_28233_length_242_cov_1.355030_g28136_i0 | PRJNA895185 | 28233 | 242 | 1.35503 | 3.2791726 | Candidatus Hydrothermarchaeaceae archaeon | 3107143 | Archaea | Archaea | 51.6 | 2.66e-5 | NR | MEE9474822.1 | 3107143 | g28136 | i0 | 33.9 | 0.768595041322314 | 62 | 41 | 76.9 | 0 | 2 | 187 | 190 | 251 | MEE9474822.1 FAD-dependent oxidoreductase [Candidatus Hydrothermarchaeaceae archaeon] | diamond | 186 | 51.6 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeaceae | Candidatus Hydrothermarchaeaceae archaeon | |||
| 30711370 | 30711370 | PRJNA565584_P_NODE_95914_length_305_cov_3.241379_g94762_i0 | PRJNA565584 | 95914 | 305 | 3.241379 | 9.88620595 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 49.7 | 2.7e-4 | NR | MFQ5800522.1 | 3107144 | g94762 | i0 | 47.9 | 0.472131147540984 | 48 | 25 | 47.2 | 0 | 301 | 158 | 241 | 288 | MFQ5800522.1 glycerate kinase [Candidatus Hydrothermarchaeales archaeon] | diamond | 144 | 49.7 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 30872021 | 30872021 | PRJNA684129_S_NODE_5554_length_172_cov_4.162963_g5547_i0 | PRJNA684129 | 5554 | 172 | 4.162963 | 7.16029636 | Candidatus Hydrothermarchaeota archaeon | 2250275 | Archaea | Archaea | 79.3 | 6.56e-16 | NR | MFQ6052329.1 | 2250275 | g5547 | i0 | 72 | 0.872093023255814 | 50 | 14 | 87.2 | 0 | 152 | 3 | 1 | 50 | MFQ6052329.1 arginase family protein [Candidatus Hydrothermarchaeota archaeon] | diamond | 150 | 79.3 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeota archaeon | ||||||
| 30966506 | 30966506 | PRJNA669701_P_NODE_81114_length_280_cov_3.439614_g80719_i0 | PRJNA669701 | 81114 | 280 | 3.439614 | 9.6309192 | Candidatus Hydrothermarchaeota archaeon | 2250275 | Archaea | Archaea | 70.1 | 9.22e-13 | NR | MFQ6050670.1 | 2250275 | g80719 | i0 | 60.3 | 1.83214285714286 | 58 | 21 | 62.1 | 1 | 8 | 181 | 21 | 76 | MFQ6050670.1 NUDIX domain-containing protein [Candidatus Hydrothermarchaeota archaeon] | diamond | 513 | 70.1 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeota archaeon | ||||||
| 31804075 | 31804075 | PRJEB75230_P_NODE_62817_length_296_cov_1.381166_g62635_i0 | PRJEB75230 | 62817 | 296 | 1.381166 | 4.08825136 | Candidatus Hydrothermarchaeaceae archaeon | 3107143 | Archaea | Archaea | 43.9 | 0.0177 | NR | MEE8401213.1 | 3107143 | g62635 | i0 | 35.2 | 0.719594594594595 | 71 | 43 | 69.9 | 2 | 262 | 56 | 99 | 168 | MEE8401213.1 class I SAM-dependent methyltransferase [Candidatus Hydrothermarchaeaceae archaeon] | diamond | 213 | 43.9 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeaceae | Candidatus Hydrothermarchaeaceae archaeon | |||
| 31838380 | 31838380 | PRJNA1120060_P_NODE_1679357_length_286_cov_1.253521_g1661356_i0 | PRJNA1120060 | 1679357 | 286 | 1.253521 | 3.58507006 | Candidatus Hydrothermarchaeaceae archaeon | 3107143 | Archaea | Archaea | 44.7 | 0.00454 | NR | MFQ6105948.1 | 3107143 | g1661356 | i0 | 34.6 | 1.54195804195804 | 78 | 46 | 78.7 | 2 | 13 | 237 | 29 | 104 | MFQ6105948.1 ribonuclease HI family protein [Candidatus Hydrothermarchaeaceae archaeon] | diamond | 441 | 44.7 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeaceae | Candidatus Hydrothermarchaeaceae archaeon | |||
| 32342861 | 32342861 | PRJNA1011844_P_NODE_148579_length_249_cov_1.653409_g140000_i0 | PRJNA1011844 | 148579 | 249 | 1.653409 | 4.11698841 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 43.5 | 0.0203 | NR | MEE8357917.1 | 3107144 | g140000 | i0 | 40.8 | 0.590361445783133 | 49 | 24 | 53 | 2 | 41 | 172 | 238 | 286 | MEE8357917.1 cytochrome c biogenesis protein CcdA [Candidatus Hydrothermarchaeales archaeon] | diamond | 147 | 43.5 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 32850649 | 32850649 | PRJNA1120060_P_NODE_3240880_length_229_cov_4.884615_g3222773_i0 | PRJNA1120060 | 3240880 | 229 | 4.884615 | 11.18576835 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 56.6 | 6.44e-8 | NR | MFQ5800413.1 | 3107144 | g3222773 | i0 | 42.3 | 0.930131004366812 | 71 | 41 | 93 | 0 | 8 | 220 | 41 | 111 | MFQ5800413.1 ribonuclease HI family protein [Candidatus Hydrothermarchaeales archaeon] | diamond | 213 | 56.6 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales 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);;