contig_metadata
20 rows where bioproject = "PRJNA594101" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8220114 | 8220114 | PRJNA594101_S_NODE_12467_length_467_cov_1.758883_g12165_i0 | PRJNA594101 | 12467 | 467 | 1.758883 | 8.21398361 | Halorarius litoreus | 2962676 | Archaea | Archaea | 52.8 | 0.045 | NTclustered | gi|2274417429|gb|CP101454.1| | 2962676 | g12165 | i0 | 100 | 0.0599571734475375 | 28 | 0 | 6 | 0 | 7 | 34 | 2612466 | 2612493 | Halorarius litoreus strain BND22 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halorarius | Halorarius litoreus | |
| 9495626 | 9495626 | PRJNA594101_S_NODE_53328_length_246_cov_0.890173_g53026_i0 | PRJNA594101 | 53328 | 246 | 0.890173 | 2.18982558 | Haloferacaceae archaeon 50 | 3384156 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2869714876|gb|CP175567.1| | 3384156 | g53026 | i0 | 96.774 | 0.126016260162602 | 31 | 1 | 13 | 0 | 132 | 162 | 69124 | 69154 | Haloferacaceae archaeon 50 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon 50 | ||
| 10771454 | 10771454 | PRJNA594101_S_NODE_4669_length_748_cov_6.591111_g4258_i1 | PRJNA594101 | 4669 | 748 | 6.591111 | 49.30151028 | Methanolobus sp. WCC4 | 3125784 | Archaea | Archaea | 60.2 | 4.48e-4 | NTclustered | gi|2713784040|gb|CP150629.1| | 3125784 | g4258 | i1 | 97.143 | 0.0467914438502674 | 35 | 1 | 5 | 0 | 7 | 41 | 239171 | 239137 | Methanolobus sp. WCC4 chromosome, complete genome | blastn | 35 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. WCC4 | |
| 12046279 | 12046279 | PRJNA594101_S_NODE_4530_length_758_cov_5.854015_g4258_i0 | PRJNA594101 | 4530 | 758 | 5.854015 | 44.3734337 | Methanolobus sp. WCC4 | 3125784 | Archaea | Archaea | 60.2 | 4.54e-4 | NTclustered | gi|2713784040|gb|CP150629.1| | 3125784 | g4258 | i0 | 97.143 | 0.0461741424802111 | 35 | 1 | 5 | 0 | 718 | 752 | 239137 | 239171 | Methanolobus sp. WCC4 chromosome, complete genome | blastn | 35 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. WCC4 | |
| 13321015 | 13321015 | PRJNA594101_S_NODE_29151_length_316_cov_1.588477_g28849_i0 | PRJNA594101 | 29151 | 316 | 1.588477 | 5.01958732 | Haloferacaceae archaeon 50 | 3384156 | Archaea | Archaea | 86.1 | 2.92e-12 | NTclustered | gi|2869714876|gb|CP175567.1| | 3384156 | g28849 | i0 | 93.103 | 3.21518987341772 | 58 | 4 | 18 | 0 | 71 | 128 | 1968987 | 1969044 | Haloferacaceae archaeon 50 chromosome, complete genome | blastn | 1016 | 86.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon 50 | ||
| 26636564 | 26636564 | PRJNA594101_S_NODE_6921_length_621_cov_2.142336_g6625_i0 | PRJNA594101 | 6921 | 621 | 2.142336 | 13.30390656 | Haloarcula argentinensis | 43776 | Archaea | Archaea | 99 | 4.37e-20 | NR | WP_005536382.1 | 43776 | g6625 | i0 | 41.6 | 1.31400966183575 | 137 | 67 | 63.3 | 4 | 619 | 227 | 397 | 526 | WP_005536382.1 bifunctional metallophosphatase/5'-nucleotidase [Haloarcula argentinensis] | diamond | 816 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula argentinensis | |
| 26699705 | 26699705 | PRJNA594101_S_NODE_2421_length_1007_cov_3.667024_g2219_i0 | PRJNA594101 | 2421 | 1007 | 3.667024 | 36.92693168 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 73.6 | 1.03e-10 | NR | NYT04245.1 | 2099674 | g2219 | i0 | 31 | 0.911618669314796 | 171 | 100 | 49.2 | 5 | 950 | 456 | 20 | 178 | NYT04245.1 alpha/beta hydrolase [Candidatus Methanofastidiosia archaeon] | diamond | 918 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 27111249 | 27111249 | PRJNA594101_S_NODE_7242_length_607_cov_1.586142_g6945_i0 | PRJNA594101 | 7242 | 607 | 1.586142 | 9.62788194 | Methanoregula sp. | 2052170 | Archaea | Archaea | 47 | 0.0235 | NR | MDD1682051.1 | 2052170 | g6945 | i0 | 32 | 0.509060955518946 | 103 | 57 | 47.9 | 5 | 465 | 175 | 80 | 175 | MDD1682051.1 cobalt-precorrin-5B (C(1))-methyltransferase [Methanoregula sp.] | diamond | 309 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 27237740 | 27237740 | PRJNA594101_S_NODE_37643_length_283_cov_1.147619_g37341_i0 | PRJNA594101 | 37643 | 283 | 1.147619 | 3.24776177 | Methanolacinia paynteri | 230356 | Archaea | Archaea | 53.1 | 1.02e-5 | NR | WP_048151653.1 | 230356 | g37341 | i0 | 52.3 | 1.39929328621908 | 44 | 21 | 46.6 | 0 | 134 | 3 | 6 | 49 | WP_048151653.1 DnaJ domain-containing protein, partial [Methanolacinia paynteri] | diamond | 396 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanolacinia | Methanolacinia paynteri | |
| 27346241 | 27346241 | PRJNA594101_S_NODE_59403_length_207_cov_4.320896_g59101_i0 | PRJNA594101 | 59403 | 207 | 4.320896 | 8.94425472 | root | 1 | Root_unresolved | Root_unresolved | 79.7 | 1.84e-15 | NR | MDM7913544.1 | 2595067 | g59101 | i0 | 57.1 | 3.68115942028985 | 63 | 27 | 91.3 | 0 | 194 | 6 | 6 | 68 | MDM7913544.1 translation elongation factor EF-1 subunit alpha [Methanotrichaceae archaeon] | diamond | 762 | 79.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 27788246 | 27788246 | PRJNA594101_S_NODE_2724_length_955_cov_3.138322_g2504_i0 | PRJNA594101 | 2724 | 955 | 3.138322 | 29.9709751 | Methanocella | 570266 | Archaea | Archaea | 79.3 | 9.07e-13 | NR | WP_012034477.1 | 1175445 | g2504 | i0 | 36.4 | 2.19267015706806 | 118 | 64 | 33.6 | 2 | 579 | 899 | 180 | 297 | WP_012034477.1 ribose 1,5-bisphosphate isomerase [Methanocella arvoryzae] | diamond | 2094 | 79.7 | 0.994981179422836 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella arvoryzae | |
| 28406290 | 28406290 | PRJNA594101_S_NODE_5446_length_696_cov_2.887640_g5162_i0 | PRJNA594101 | 5446 | 696 | 2.88764 | 20.0979744 | Methanolobus profundi | 487685 | Archaea | Archaea | 102 | 1.18e-22 | NR | WP_091933702.1 | 487685 | g5162 | i0 | 27.7 | 2.99568965517241 | 231 | 140 | 99.6 | 3 | 693 | 1 | 8 | 211 | WP_091933702.1 MIP/aquaporin family protein [Methanolobus profundi] | diamond | 2085 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus profundi | |
| 28722027 | 28722027 | PRJNA594101_S_NODE_27307_length_325_cov_2.134921_g27005_i0 | PRJNA594101 | 27307 | 325 | 2.134921 | 6.93849325 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.7 | 3.22e-11 | NR | HNJ81026.1 | 2485498 | g27005 | i0 | 53.3 | 0.553846153846154 | 60 | 26 | 55.4 | 1 | 260 | 81 | 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 | ||
| 29258386 | 29258386 | PRJNA594101_S_NODE_14649_length_433_cov_1.675000_g14347_i0 | PRJNA594101 | 14649 | 433 | 1.675 | 7.25275 | Natronolimnobius sp. AArcel1 | 1679093 | Archaea | Archaea | 100 | 3.74e-22 | NR | WP_165161068.1 | 1679093 | g14347 | i0 | 40.5 | 2.85450346420323 | 131 | 70 | 88 | 3 | 3 | 383 | 60 | 186 | WP_165161068.1 D-2-hydroxyacid dehydrogenase [Natronolimnobius sp. AArcel1] | diamond | 1236 | 100 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronolimnobius | Natronolimnobius sp. AArcel1 | |
| 29763709 | 29763709 | PRJNA594101_S_NODE_59071_length_226_cov_2.143791_g58769_i0 | PRJNA594101 | 59071 | 226 | 2.143791 | 4.84496766 | halophilic archaeon | 29295 | Archaea | Archaea | 44.7 | 0.0063 | NR | RBI62334.1 | 29295 | g58769 | i0 | 37.1 | 0.929203539823009 | 70 | 42 | 90.3 | 1 | 8 | 211 | 412 | 481 | RBI62334.1 ABC transporter substrate-binding protein [halophilic archaeon] | diamond | 210 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon | |||
| 30237716 | 30237716 | PRJNA594101_S_NODE_10752_length_501_cov_1.126168_g10451_i0 | PRJNA594101 | 10752 | 501 | 1.126168 | 5.64210168 | Methanothrix sp. | 90426 | Archaea | Archaea | 44.7 | 0.0274 | NR | HOU71457.1 | 90426 | g10451 | i0 | 29.8 | 0.682634730538922 | 114 | 62 | 62.3 | 5 | 449 | 138 | 37 | 142 | HOU71457.1 hypothetical protein [Methanothrix sp.] | diamond | 342 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30251382 | 30251382 | PRJNA594101_S_NODE_44572_length_262_cov_0.798942_g44270_i0 | PRJNA594101 | 44572 | 262 | 0.798942 | 2.09322804 | Methanosarcina | 2207 | Archaea | Archaea | 43.5 | 0.0257 | NR | WP_011306373.1 | 2208 | g44270 | i0 | 43.9 | 2.87404580152672 | 41 | 23 | 46.9 | 0 | 249 | 127 | 491 | 531 | WP_011306373.1 tetratricopeptide repeat protein [Methanosarcina barkeri] | diamond | 753 | 43.9 | 0.990888382687927 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 30806474 | 30806474 | PRJNA594101_S_NODE_19534_length_379_cov_1.006536_g19232_i0 | PRJNA594101 | 19534 | 379 | 1.006536 | 3.81477144 | Methanolobus sp. | 1874737 | Archaea | Archaea | 44.3 | 0.0368 | NR | MDK2948738.1 | 1874737 | g19232 | i0 | 44.9 | 0.387862796833773 | 49 | 24 | 36.4 | 1 | 173 | 310 | 47 | 95 | MDK2948738.1 hypothetical protein [Methanolobus sp.] | diamond | 147 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 31312013 | 31312013 | PRJNA594101_S_NODE_175_length_2645_cov_7.179238_g132_i0 | PRJNA594101 | 175 | 2645 | 7.179238 | 189.8908451 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 69.7 | 4.96e-8 | NR | HNJ81026.1 | 2485498 | g132 | i0 | 53.3 | 0.81890359168242 | 60 | 26 | 6.8 | 1 | 1853 | 2032 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 2166 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 32766330 | 32766330 | PRJNA594101_S_NODE_43680_length_264_cov_1.465969_g43378_i0 | PRJNA594101 | 43680 | 264 | 1.465969 | 3.87015816 | Halobellus rarus | 1126237 | Archaea | Archaea | 44.7 | 0.0102 | NR | WP_390278278.1 | 1126237 | g43378 | i0 | 33.3 | 0.784090909090909 | 69 | 46 | 78.4 | 0 | 46 | 252 | 37 | 105 | WP_390278278.1 hypothetical protein [Halobellus rarus] | diamond | 207 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus rarus |
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);;