contig_metadata
20 rows where bioproject = "PRJNA1010780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26869041 | 26869041 | PRJNA1010780_S_NODE_61761_length_152_cov_2.153846_g60472_i0 | PRJNA1010780 | 61761 | 152 | 2.153846 | 3.27384592 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 3.66e-6 | NR | WP_243684832.1 | 2208 | g60472 | i0 | 45.8 | 3.84868421052632 | 48 | 26 | 94.7 | 0 | 6 | 149 | 12 | 59 | WP_243684832.1 tetratricopeptide repeat protein [Methanosarcina barkeri] | diamond | 585 | 51.6 | 0.992248062015504 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 26876650 | 26876650 | PRJNA1010780_S_NODE_21161_length_379_cov_1.895349_g19872_i0 | PRJNA1010780 | 21161 | 379 | 1.895349 | 7.18337271 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 65.9 | 1.35e-9 | NR | HNJ81026.1 | 2485498 | g19872 | i0 | 53.4 | 0.45910290237467 | 58 | 25 | 45.9 | 1 | 377 | 204 | 605 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 174 | 65.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 28132647 | 28132647 | PRJNA1010780_S_NODE_21125_length_379_cov_3.808140_g19836_i0 | PRJNA1010780 | 21125 | 379 | 3.80814 | 14.4328506 | Methanothrix | 2222 | Archaea | Archaea | 47.8 | 0.00304 | NR | MDD4161994.1 | 90426 | g19836 | i0 | 38.5 | 1.14775725593668 | 65 | 40 | 51.5 | 0 | 2 | 196 | 968 | 1032 | MDD4161994.1 PKD domain-containing protein [Methanothrix sp.] | diamond | 435 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28669390 | 28669390 | PRJNA1010780_S_NODE_10367_length_750_cov_3.577622_g9397_i0 | PRJNA1010780 | 10367 | 750 | 3.577622 | 26.832165 | Haladaptatus | 367188 | Archaea | Archaea | 102 | 8.89e-22 | NR | WP_244895571.1 | 367189 | g9397 | i0 | 34.2 | 1.568 | 196 | 123 | 76.4 | 4 | 46 | 618 | 20 | 214 | WP_244895571.1 DUF4397 domain-containing protein [Haladaptatus paucihalophilus] | diamond | 1176 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus paucihalophilus | |
| 28732500 | 28732500 | PRJNA1010780_S_NODE_63007_length_151_cov_1.112069_g61718_i0 | PRJNA1010780 | 63007 | 151 | 1.112069 | 1.67922419 | Candidatus Methanofastidiosum | 2666130 | Archaea | Archaea | 56.2 | 1.85e-7 | NR | KYC52904.1 | 1705564 | g61718 | i0 | 56.5 | 4.56953642384106 | 46 | 20 | 91.4 | 0 | 141 | 4 | 12 | 57 | KYC52904.1 MAG: lipoprotein NlpI [Candidatus Methanofastidiosum methylothiophilum] | diamond | 690 | 56.6 | 0.992932862190813 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Candidatus Methanofastidiosum methylothiophilum | |
| 28897683 | 28897683 | PRJNA1010780_S_NODE_1968_length_1806_cov_8.608131_g1750_i0 | PRJNA1010780 | 1968 | 1806 | 8.608131 | 155.46284586 | Methanoregula sp. | 2052170 | Archaea | Archaea | 61.2 | 1.28e-6 | NR | MDD1690355.1 | 2052170 | g1750 | i0 | 32.7 | 0.172757475083056 | 104 | 68 | 16.9 | 1 | 6 | 311 | 36 | 139 | MDD1690355.1 tetratricopeptide repeat protein [Methanoregula sp.] | diamond | 312 | 61.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 29079838 | 29079838 | PRJNA1010780_S_NODE_34648_length_232_cov_3.862944_g33359_i0 | PRJNA1010780 | 34648 | 232 | 3.862944 | 8.96203008 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00364 | NR | WP_373840184.1 | 45200 | g33359 | i0 | 57.6 | 2.0948275862069 | 33 | 14 | 42.7 | 0 | 228 | 130 | 39 | 71 | WP_373840184.1 tetratricopeptide repeat protein [Methanospirillum sp.] | diamond | 486 | 45.8 | 0.991266375545852 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29276547 | 29276547 | PRJNA1010780_S_NODE_1969_length_1806_cov_8.604178_g1750_i1 | PRJNA1010780 | 1969 | 1806 | 8.604178 | 155.39145468 | Methanoregula sp. | 2052170 | Archaea | Archaea | 61.2 | 1.28e-6 | NR | MDD1690355.1 | 2052170 | g1750 | i1 | 32.7 | 0.172757475083056 | 104 | 68 | 16.9 | 1 | 1801 | 1496 | 36 | 139 | MDD1690355.1 tetratricopeptide repeat protein [Methanoregula sp.] | diamond | 312 | 61.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 29332336 | 29332336 | PRJNA1010780_S_NODE_11389_length_692_cov_6.520548_g10355_i0 | PRJNA1010780 | 11389 | 692 | 6.520548 | 45.12219216 | Halobacterium | 2239 | Archaea | Archaea | 164 | 1.72e-46 | NR | WP_237007340.1 | 2239 | g10355 | i0 | 41 | 7.00578034682081 | 212 | 110 | 90.6 | 5 | 668 | 42 | 31 | 230 | WP_237007340.1 MULTISPECIES: GAF domain-containing protein [Halobacterium] | diamond | 4848 | 165 | 0.993939393939394 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | ||
| 30160818 | 30160818 | PRJNA1010780_S_NODE_7952_length_917_cov_25.371882_g7152_i0 | PRJNA1010780 | 7952 | 917 | 25.371882 | 232.66015794 | Methanothrix sp. | 90426 | Archaea | Archaea | 50.1 | 0.0111 | NR | HOI69132.1 | 90426 | g7152 | i0 | 44.6 | 0.549618320610687 | 56 | 31 | 18.3 | 0 | 903 | 736 | 622 | 677 | HOI69132.1 tetratricopeptide repeat protein [Methanothrix sp.] | diamond | 504 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30184948 | 30184948 | PRJNA1010780_S_NODE_56672_length_161_cov_1.436508_g55383_i0 | PRJNA1010780 | 56672 | 161 | 1.436508 | 2.31277788 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 3.14e-5 | NR | HPS90528.1 | 90426 | g55383 | i0 | 51.2 | 2.73913043478261 | 43 | 21 | 80.1 | 0 | 159 | 31 | 168 | 210 | HPS90528.1 tetratricopeptide repeat protein [Methanothrix sp.] | diamond | 441 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 30224044 | 30224044 | PRJNA1010780_S_NODE_12792_length_627_cov_19.552365_g11679_i0 | PRJNA1010780 | 12792 | 627 | 19.552365000000002 | 122.59332855 | Methanochimaera problematica | 2609417 | Archaea | Archaea | 89.7 | 3.78e-18 | NR | WP_317136169.1 | 2609417 | g11679 | i0 | 36.2 | 0.674641148325359 | 141 | 81 | 66.5 | 4 | 532 | 116 | 70 | 203 | WP_317136169.1 DOMON domain-containing protein [Methanochimaera problematica] | diamond | 423 | 89.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanochimaera | Methanochimaera problematica | |
| 31330124 | 31330124 | PRJNA1010780_S_NODE_36856_length_221_cov_1.887097_g35567_i0 | PRJNA1010780 | 36856 | 221 | 1.887097 | 4.17048437 | Methanocella sp. | 2052833 | Archaea | Archaea | 51.2 | 2.8e-5 | NR | WP_325376951.1 | 2052833 | g35567 | i0 | 38.4 | 0.990950226244344 | 73 | 43 | 96.4 | 1 | 219 | 7 | 309 | 381 | WP_325376951.1 chromosome condensation regulator RCC1 [Methanocella sp.] | diamond | 219 | 51.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanocellales | Methanocellaceae | Methanocella | Methanocella sp. | |
| 31488580 | 31488580 | PRJNA1010780_S_NODE_49336_length_177_cov_1.246479_g48047_i0 | PRJNA1010780 | 49336 | 177 | 1.246479 | 2.20626783 | Natronorubrum halophilum | 1702106 | Archaea | Archaea | 57.4 | 9.82e-8 | NR | WP_238709484.1 | 1702106 | g48047 | i0 | 43.1 | 2.94915254237288 | 58 | 33 | 98.3 | 0 | 176 | 3 | 178 | 235 | WP_238709484.1 NAD(P)/FAD-dependent oxidoreductase [Natronorubrum halophilum] | diamond | 522 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum halophilum | |
| 31677975 | 31677975 | PRJNA1010780_S_NODE_27977_length_283_cov_3.028226_g26688_i0 | PRJNA1010780 | 27977 | 283 | 3.028226 | 8.56987958 | Haloplanus sp. GCM1 | 1961696 | Archaea | Archaea | 55.1 | 6.09e-7 | NR | WP_379796082.1 | 3252679 | g26688 | i0 | 41.9 | 0.657243816254417 | 62 | 35 | 64.7 | 1 | 184 | 2 | 47 | 108 | WP_379796082.1 OsmC family protein [Haloplanus sp. GCM10025708] | diamond | 186 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GCM10025708 | |
| 31772964 | 31772964 | PRJNA1010780_S_NODE_9717_length_788_cov_12.701195_g8791_i0 | PRJNA1010780 | 9717 | 788 | 12.701195 | 100.0854166 | Methanosaeta sp. PtaU1.Bin112 | 1811689 | Archaea | Archaea | 44.3 | 0.0432 | NR | OPY50796.1 | 1811689 | g8791 | i0 | 41.2 | 0.194162436548223 | 51 | 30 | 19.4 | 0 | 783 | 631 | 20 | 70 | OPY50796.1 MAG: Tetratricopeptide repeat protein [Methanosaeta sp. PtaU1.Bin112] | diamond | 153 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaU1.Bin112 | |
| 31923513 | 31923513 | PRJNA1010780_S_NODE_20717_length_387_cov_2.786932_g19428_i0 | PRJNA1010780 | 20717 | 387 | 2.786932 | 10.78542684 | Methanobacteriota | 28890 | Archaea | Archaea | 52 | 5.49e-6 | NR | MDD5024391.1 | 2052170 | g19428 | i0 | 61.1 | 0.806201550387597 | 36 | 14 | 27.9 | 0 | 387 | 280 | 19 | 54 | MDD5024391.1 tetratricopeptide repeat protein [Methanoregula sp.] | diamond | 312 | 52 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32247940 | 32247940 | PRJNA1010780_S_NODE_45558_length_187_cov_1.875000_g44269_i0 | PRJNA1010780 | 45558 | 187 | 1.875 | 3.50625 | Halobacterium sp. | 2243 | Archaea | Archaea | 55.1 | 2.11e-7 | NR | MFB6068836.1 | 2243 | g44269 | i0 | 44.4 | 1.01069518716578 | 63 | 34 | 99.5 | 1 | 187 | 2 | 58 | 120 | MFB6068836.1 OsmC family protein [Halobacterium sp.] | diamond | 189 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. | |
| 32500958 | 32500958 | PRJNA1010780_S_NODE_62079_length_152_cov_1.444444_g60790_i0 | PRJNA1010780 | 62079 | 152 | 1.444444 | 2.19555488 | Halorutilus salinus | 2487751 | Archaea | Archaea | 45.1 | 0.00162 | NR | WP_266086359.1 | 2487751 | g60790 | i0 | 44.2 | 1.69736842105263 | 43 | 24 | 84.9 | 0 | 14 | 142 | 234 | 276 | WP_266086359.1 transcription initiation factor IIB [Halorutilus salinus] | diamond | 258 | 45.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halorutilales | Halorutilaceae | Halorutilus | Halorutilus salinus | |
| 32564214 | 32564214 | PRJNA1010780_S_NODE_28739_length_276_cov_2.381743_g27450_i0 | PRJNA1010780 | 28739 | 276 | 2.381743 | 6.57361068 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 135 | 1.28e-34 | NR | MFA5294606.1 | 2485498 | g27450 | i0 | 70 | 2.93478260869565 | 90 | 27 | 97.8 | 0 | 4 | 273 | 469 | 558 | MFA5294606.1 propionyl-CoA synthetase [Methanoregulaceae archaeon] | diamond | 810 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae 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);;