contig_metadata
17 rows where bioproject = "PRJNA688931" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668482 | 668482 | PRJNA688931_P_NODE_25941_length_200_cov_2.026490_g25728_i0 | PRJNA688931 | 25941 | 200 | 2.02649 | 4.05298 | Thermococcus sp. 2319x1 | 1674923 | Archaea | Archaea | 58.4 | 3.73e-4 | NTclustered | gi|1839133054|emb|LR778300.1| | 1674923 | g25728 | i0 | 100 | 0.46 | 31 | 0 | 16 | 0 | 37 | 67 | 306700 | 306670 | Thermococcus sp. 2319x1 strain Essen genome assembly, chromosome: 1 | blastn | 92 | 58.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 2319x1 | ||
| 19795386 | 19795386 | PRJNA688931_P_NODE_23856_length_209_cov_1.943750_g23643_i0 | PRJNA688931 | 23856 | 209 | 1.94375 | 4.0624375 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 5.06e-19 | NR | MCU0859611.1 | 1906666 | g23643 | i0 | 65.6 | 27.4593301435407 | 64 | 22 | 91.9 | 0 | 18 | 209 | 3 | 66 | MCU0859611.1 molecular chaperone DnaJ [Thermoplasmata archaeon] | diamond | 5739 | 89.7 | 0.996655518394649 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 23621318 | 23621318 | PRJNA688931_P_NODE_18939_length_235_cov_2.521505_g18726_i0 | PRJNA688931 | 18939 | 235 | 2.521505 | 5.92553675 | Halomarina pelagica | 2961599 | Archaea | Archaea | 71.3 | 5.81e-8 | NTclustered | gi|2270305250|gb|CP100454.1| | 2961599 | g18726 | i0 | 92 | 1.15744680851064 | 50 | 4 | 21 | 0 | 173 | 222 | 1375429 | 1375380 | Halomarina pelagica strain BND7 chromosome, complete genome | blastn | 272 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina pelagica | |
| 26935567 | 26935567 | PRJNA688931_P_NODE_16942_length_249_cov_2.150000_g16729_i0 | PRJNA688931 | 16942 | 249 | 2.15 | 5.3535 | Archaea | 2157 | Archaea | Archaea | 45.8 | 3.92e-4 | NR | KUO40167.1 | 1776334 | g16729 | i0 | 45.8 | 1.73493975903614 | 48 | 25 | 57.8 | 1 | 249 | 106 | 15 | 61 | KUO40167.1 MAG: hypothetical protein APZ16_07070 [Candidatus Hadarchaeum yellowstonense] | diamond | 432 | 45.8 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Candidatus Hadarchaeales | Candidatus Hadarchaeaceae | Candidatus Hadarchaeum | Candidatus Hadarchaeum yellowstonense | ||
| 27556026 | 27556026 | PRJNA688931_P_NODE_36144_length_168_cov_0.873950_g35931_i0 | PRJNA688931 | 36144 | 168 | 0.87395 | 1.468236 | Halonotius sp. F2-221B | 2731620 | Archaea | Archaea | 41.6 | 0.0346 | NR | WP_411797635.1 | 2731620 | g35931 | i0 | 48.8 | 0.767857142857143 | 43 | 20 | 76.8 | 1 | 23 | 151 | 249 | 289 | WP_411797635.1 histidine kinase N-terminal 7TM domain-containing protein [Halonotius sp. F2-221B] | diamond | 129 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius sp. F2-221B | |
| 27809031 | 27809031 | PRJNA688931_P_NODE_1784_length_848_cov_2.093867_g1632_i0 | PRJNA688931 | 1784 | 848 | 2.093867 | 17.75599216 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 47.8 | 0.0443 | NR | MDH7508558.1 | 1906667 | g1632 | i0 | 36.8 | 0.201650943396226 | 57 | 36 | 20.2 | 0 | 716 | 546 | 19 | 75 | MDH7508558.1 PAS domain S-box protein [Methanomassiliicoccales archaeon] | diamond | 171 | 47.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 28029928 | 28029928 | PRJNA688931_P_NODE_27585_length_194_cov_1.400000_g27372_i0 | PRJNA688931 | 27585 | 194 | 1.4 | 2.716 | Archaeoglobaceae archaeon | 2511821 | Archaea | Archaea | 43.1 | 0.0139 | NR | MEM4495995.1 | 2511821 | g27372 | i0 | 36.8 | 0.881443298969072 | 57 | 35 | 88.1 | 1 | 14 | 184 | 208 | 263 | MEM4495995.1 phosphate uptake regulator PhoU [Archaeoglobaceae archaeon] | diamond | 171 | 43.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobaceae archaeon | |||
| 28029936 | 28029936 | PRJNA688931_P_NODE_34125_length_172_cov_1.252033_g33912_i0 | PRJNA688931 | 34125 | 172 | 1.252033 | 2.15349676 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 50.8 | 2.01e-5 | NR | MFL2947514.1 | 2163009 | g33912 | i0 | 36.4 | 4.56976744186047 | 55 | 35 | 95.9 | 0 | 172 | 8 | 155 | 209 | MFL2947514.1 isopentenyl-diphosphate delta-isomerase [Candidatus Poseidoniales archaeon] | diamond | 786 | 50.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28156331 | 28156331 | PRJNA688931_P_NODE_17445_length_246_cov_1.050761_g17232_i0 | PRJNA688931 | 17445 | 246 | 1.050761 | 2.58487206 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 45.1 | 0.00565 | NR | MCL4450642.1 | 2806419 | g17232 | i0 | 47.7 | 1.59756097560976 | 44 | 23 | 53.7 | 0 | 1 | 132 | 260 | 303 | MCL4450642.1 deoxyhypusine synthase [Thermoplasmatota archaeon] | diamond | 393 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28356979 | 28356979 | PRJNA688931_P_NODE_42566_length_163_cov_0.894737_g42353_i0 | PRJNA688931 | 42566 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 5.64e-4 | NR | HDS44682.1 | 2268195 | g42353 | i0 | 43.2 | 10.6748466257669 | 44 | 25 | 81 | 0 | 132 | 1 | 251 | 294 | HDS44682.1 hypothetical protein [Methanomicrobia archaeon] | diamond | 1740 | 46.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobia archaeon | ||||
| 28377085 | 28377085 | PRJNA688931_P_NODE_9626_length_342_cov_1.242321_g9413_i0 | PRJNA688931 | 9626 | 342 | 1.242321 | 4.24873782 | Thermococcus sp. | 35749 | Archaea | Archaea | 46.2 | 0.00645 | NR | WP_297523431.1 | 35749 | g9413 | i0 | 36.8 | 1.31578947368421 | 76 | 44 | 64.9 | 2 | 17 | 238 | 333 | 406 | WP_297523431.1 flippase [Thermococcus sp.] | diamond | 450 | 46.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 29746114 | 29746114 | PRJNA688931_P_NODE_5290_length_483_cov_2.048387_g5078_i0 | PRJNA688931 | 5290 | 483 | 2.048387 | 9.89370921 | Methanomicrobia | 224756 | Archaea | Archaea | 124 | 1.15e-30 | NR | MCX6675397.1 | 90426 | g5078 | i0 | 46.5 | 4.77639751552795 | 129 | 68 | 80.1 | 1 | 388 | 2 | 123 | 250 | MCX6675397.1 translation elongation factor EF-1 subunit alpha [Methanothrix sp.] | diamond | 2307 | 125 | 0.992 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 29797873 | 29797873 | PRJNA688931_P_NODE_30051_length_185_cov_1.485294_g29838_i0 | PRJNA688931 | 30051 | 185 | 1.485294 | 2.7477939 | Methanosarcina hadiensis | 3078083 | Archaea | Archaea | 41.6 | 0.0434 | NR | WP_410508748.1 | 3078083 | g29838 | i0 | 38.8 | 0.794594594594595 | 49 | 26 | 73 | 1 | 15 | 149 | 59 | 107 | WP_410508748.1 PHP domain-containing protein [Methanosarcina hadiensis] | diamond | 147 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina hadiensis | |
| 31694124 | 31694124 | PRJNA688931_P_NODE_1797_length_845_cov_3.276382_g1645_i0 | PRJNA688931 | 1797 | 845 | 3.276382 | 27.6854279 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.7 | 2.68e-9 | NR | HNJ81026.1 | 2485498 | g1645 | i0 | 53.3 | 0.21301775147929 | 60 | 26 | 21.3 | 1 | 741 | 562 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 31757463 | 31757463 | PRJNA688931_P_NODE_40557_length_164_cov_0.904348_g40344_i0 | PRJNA688931 | 40557 | 164 | 0.904348 | 1.48313072 | Methanoregula sp. | 2052170 | Archaea | Archaea | 53.1 | 2.67e-6 | NR | MCX6691449.1 | 2052170 | g40344 | i0 | 47.9 | 0.878048780487805 | 48 | 25 | 87.8 | 0 | 4 | 147 | 140 | 187 | MCX6691449.1 CinA family protein [Methanoregula sp.] | diamond | 144 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32263935 | 32263935 | PRJNA688931_P_NODE_1678_length_871_cov_2.105839_g1530_i0 | PRJNA688931 | 1678 | 871 | 2.105839 | 18.34185769 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 80.5 | 6.19e-13 | NR | MBO7518105.1 | 66852 | g1530 | i0 | 54.7 | 0.730195177956372 | 64 | 27 | 21.4 | 1 | 535 | 350 | 420 | 483 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 636 | 80.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32642704 | 32642704 | PRJNA688931_P_NODE_28100_length_192_cov_1.328671_g27887_i0 | PRJNA688931 | 28100 | 192 | 1.328671 | 2.55104832 | Methanocaldococcus sp. FS4 | 2152917 | Archaea | Archaea | 42 | 0.0349 | NR | WP_012981188.1 | 644281 | g27887 | i0 | 40 | 0.9375 | 60 | 34 | 93.8 | 1 | 188 | 9 | 183 | 240 | WP_012981188.1 histidine--tRNA ligase [Methanocaldococcus sp. FS406-22] | diamond | 180 | 42 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus sp. FS406-22 |
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);;