contig_metadata
24 rows where bioproject = "PRJNA494251", tax_phylum = "Methanobacteriota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6210350 | 6210350 | PRJNA494251_P_NODE_49265_length_241_cov_0.916667_g48951_i0 | PRJNA494251 | 49265 | 241 | 0.916667 | 2.20916747 | Methanomicrobiales | 2191 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2006650972|gb|CP036172.1| | 126734 | g48951 | i0 | 100 | 0.37344398340249 | 30 | 0 | 12 | 0 | 160 | 189 | 59530 | 59559 | Methanofollis aquaemaris strain N2F9704 chromosome, complete genome | blastn | 90 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis aquaemaris | |
| 8128447 | 8128447 | PRJNA494251_P_NODE_38187_length_250_cov_0.870056_g37873_i0 | PRJNA494251 | 38187 | 250 | 0.870056 | 2.17514 | Natronomonas salina | 1710540 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|1865519430|gb|CP058335.1| | 1710540 | g37873 | i0 | 94.118 | 0.136 | 34 | 2 | 14 | 0 | 98 | 131 | 739519 | 739486 | Natronomonas salina strain YPL13 chromosome, complete genome | blastn | 34 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas salina | |
| 9403423 | 9403423 | PRJNA494251_P_NODE_40328_length_248_cov_1.320000_g40014_i0 | PRJNA494251 | 40328 | 248 | 1.32 | 3.2736 | Haloglomus halophilum | 2962672 | Archaea | Archaea | 62.1 | 3.73e-5 | NTclustered | gi|2273560679|gb|CP101166.1| | 2962672 | g40014 | i0 | 89.583 | 0.193548387096774 | 48 | 5 | 19 | 0 | 125 | 172 | 614724 | 614771 | Haloglomus halophilum strain ZY41 chromosome, complete genome | blastn | 48 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus halophilum | |
| 11954180 | 11954180 | PRJNA494251_P_NODE_39630_length_249_cov_0.875000_g39316_i0 | PRJNA494251 | 39630 | 249 | 0.875 | 2.17875 | Natrinema pallidum | 69527 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1674549330|gb|CP040637.1| | 69527 | g39316 | i0 | 100 | 0.240963855421687 | 30 | 0 | 12 | 0 | 29 | 58 | 813772 | 813743 | Natrinema pallidum strain BOL6-1 chromosome, complete genome | blastn | 60 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema pallidum | |
| 15778069 | 15778069 | PRJNA494251_P_NODE_40773_length_248_cov_0.880000_g40459_i0 | PRJNA494251 | 40773 | 248 | 0.88 | 2.1824 | uncultured marine group II/III euryarchaeote KM3_110_C01 | 1457851 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|663508794|gb|KF900564.1| | 1457851 | g40459 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 57 | 84 | 34025 | 33998 | Uncultured marine group II/III euryarchaeote KM3_110_C01 genomic sequence | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote KM3_110_C01 | ||||||
| 17052531 | 17052531 | PRJNA494251_P_NODE_20194_length_316_cov_1.522634_g19880_i0 | PRJNA494251 | 20194 | 316 | 1.522634 | 4.81152344 | Halospeciosus flavus | 3032283 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2490484842|gb|CP122312.1| | 3032283 | g19880 | i0 | 100 | 0.0917721518987342 | 29 | 0 | 9 | 0 | 65 | 93 | 3051262 | 3051234 | Halospeciosus flavus strain XZGYJ-43 chromosome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halospeciosus | Halospeciosus flavus | |
| 19601076 | 19601076 | PRJNA494251_P_NODE_18736_length_326_cov_1.739130_g18422_i0 | PRJNA494251 | 18736 | 326 | 1.73913 | 5.6695638 | Natronococcus wangiae | 3068275 | Archaea | Archaea | 58.4 | 6.59e-4 | NTclustered | gi|2563036162|gb|CP132294.1| | 3068275 | g18422 | i0 | 92.5 | 0.331288343558282 | 40 | 3 | 12 | 0 | 258 | 297 | 4001600 | 4001561 | Natronococcus wangiae strain AD-5 chromosome, complete genome | blastn | 108 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus wangiae | |
| 24701336 | 24701336 | PRJNA494251_P_NODE_34120_length_258_cov_2.529730_g33806_i0 | PRJNA494251 | 34120 | 258 | 2.52973 | 6.5267034 | Thermococcus indicus | 2586643 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|1681065834|gb|CP040846.1| | 2586643 | g33806 | i0 | 100 | 0.108527131782946 | 28 | 0 | 11 | 0 | 18 | 45 | 2100561 | 2100534 | Thermococcus indicus strain IOH1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus indicus | ||
| 24701412 | 24701412 | PRJNA494251_P_NODE_40540_length_248_cov_0.880000_g40226_i0 | PRJNA494251 | 40540 | 248 | 0.88 | 2.1824 | halophilic archaeon DL31 | 756883 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|344319636|gb|CP002988.1| | 756883 | g40226 | i0 | 100 | 0.225806451612903 | 28 | 0 | 11 | 0 | 185 | 212 | 171503 | 171476 | Halophilic archaeon DL31 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon DL31 | |||
| 26649174 | 26649174 | PRJNA494251_P_NODE_5161_length_561_cov_1.262295_g4867_i0 | PRJNA494251 | 5161 | 561 | 1.262295 | 7.08147495 | Methanoregula | 395331 | Archaea | Archaea | 79.7 | 1.73e-14 | NR | HSQ94182.1 | 2052170 | g4867 | i0 | 26.2 | 9.77540106951872 | 191 | 129 | 99.5 | 4 | 3 | 560 | 47 | 230 | HSQ94182.1 aquaporin Z [Methanoregula sp.] | diamond | 5484 | 80.1 | 0.995006242197254 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 26776180 | 26776180 | PRJNA494251_P_NODE_34741_length_257_cov_1.103261_g34427_i0 | PRJNA494251 | 34741 | 257 | 1.103261 | 2.83538077 | Stenosarchaea group | 2290931 | Archaea | Archaea | 48.1 | 5.14e-4 | NR | WP_199233658.1 | 1537267 | g34427 | i0 | 31.2 | 6.18677042801556 | 77 | 53 | 89.9 | 0 | 10 | 240 | 29 | 105 | WP_199233658.1 NAD-dependent epimerase/dehydratase family protein, partial [Halorubrum sp. SP9] | diamond | 1590 | 48.5 | 0.991752577319588 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. SP9 | |
| 26887322 | 26887322 | PRJNA494251_P_NODE_7721_length_471_cov_1.298995_g7418_i0 | PRJNA494251 | 7721 | 471 | 1.298995 | 6.11826645 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 51.6 | 2.4e-4 | NR | RYE84638.1 | 2250255 | g7418 | i0 | 38 | 0.452229299363057 | 71 | 41 | 45.2 | 1 | 259 | 471 | 75 | 142 | RYE84638.1 MAG: hypothetical protein EOO65_01930 [Methanosarcinales archaeon] | diamond | 213 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27772092 | 27772092 | PRJNA494251_P_NODE_43844_length_245_cov_1.755814_g43530_i0 | PRJNA494251 | 43844 | 245 | 1.755814 | 4.3017443 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 68.9 | 1.64e-11 | NR | RYF00025.1 | 2026739 | g43530 | i0 | 40 | 0.857142857142857 | 70 | 42 | 85.7 | 0 | 1 | 210 | 102 | 171 | RYF00025.1 MAG: hypothetical protein EOO41_00120 [Methanobacteriota archaeon] | diamond | 210 | 68.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28308718 | 28308718 | PRJNA494251_P_NODE_2926_length_716_cov_2.259720_g2657_i0 | PRJNA494251 | 2926 | 716 | 2.25972 | 16.1795952 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 57.8 | 1.32e-5 | NR | MEE3325473.1 | 2666342 | g2657 | i0 | 25.4 | 1.88128491620112 | 244 | 128 | 96.8 | 13 | 697 | 5 | 100 | 302 | MEE3325473.1 hypothetical protein [Methanosphaera sp.] | diamond | 1347 | 57.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 28656039 | 28656039 | PRJNA494251_P_NODE_24347_length_294_cov_1.361991_g24033_i0 | PRJNA494251 | 24347 | 294 | 1.361991 | 4.00425354 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 102 | 2.41e-25 | NR | MEE3444538.1 | 66852 | g24033 | i0 | 52.6 | 0.989795918367347 | 97 | 46 | 99 | 0 | 3 | 293 | 5 | 101 | MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.] | diamond | 291 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29871425 | 29871425 | PRJNA494251_P_NODE_39211_length_249_cov_0.875000_g38897_i0 | PRJNA494251 | 39211 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0063 | NR | AIF23262.1 | 1456558 | g38897 | i0 | 32.4 | 5.49397590361446 | 71 | 45 | 85.5 | 1 | 214 | 2 | 2027 | 2094 | AIF23262.1 RCC1 domain-containing protein [uncultured marine group II/III euryarchaeote SAT1000_14_B08] | diamond | 1368 | 45.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote SAT1000_14_B08 | ||||||
| 30171598 | 30171598 | PRJNA494251_P_NODE_13072_length_378_cov_1.262295_g12764_i0 | PRJNA494251 | 13072 | 378 | 1.262295 | 4.7714751 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 156 | 2.96e-41 | NR | MAD56215.1 | 2026739 | g12764 | i0 | 61.6 | 0.992063492063492 | 125 | 48 | 99.2 | 0 | 2 | 376 | 912 | 1036 | MAD56215.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 375 | 156 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30393352 | 30393352 | PRJNA494251_P_NODE_4233_length_612_cov_4.812616_g3943_i0 | PRJNA494251 | 4233 | 612 | 4.812616 | 29.45320992 | Haloplanus salinus | 1126245 | Archaea | Archaea | 84.7 | 2.01e-16 | NR | WP_114450628.1 | 1126245 | g3943 | i0 | 32.6 | 2.07843137254902 | 138 | 88 | 67.6 | 1 | 14 | 427 | 48 | 180 | WP_114450628.1 DUF4397 domain-containing protein [Haloplanus salinus] | diamond | 1272 | 84.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus salinus | |
| 30835175 | 30835175 | PRJNA494251_P_NODE_2914_length_717_cov_1.739130_g2645_i0 | PRJNA494251 | 2914 | 717 | 1.73913 | 12.4695621 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 79.7 | 4.29e-13 | NR | WP_266077698.1 | 2993314 | g2645 | i0 | 30.4 | 1.88284518828452 | 148 | 99 | 60.7 | 3 | 22 | 456 | 123 | 269 | WP_266077698.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus] | diamond | 1350 | 79.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus | |
| 30929989 | 30929989 | PRJNA494251_P_NODE_10474_length_415_cov_1.798246_g10168_i0 | PRJNA494251 | 10474 | 415 | 1.798246 | 7.4627209 | Haloarculaceae archaeon | 2497615 | Archaea | Archaea | 45.4 | 0.0167 | NR | MEF8842997.1 | 2497615 | g10168 | i0 | 40 | 0.650602409638554 | 90 | 46 | 60.7 | 3 | 19 | 270 | 60 | 147 | MEF8842997.1 MBL fold metallo-hydrolase [Haloarculaceae archaeon] | diamond | 270 | 45.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarculaceae archaeon | ||
| 31340879 | 31340879 | PRJNA494251_P_NODE_17636_length_334_cov_1.750958_g17322_i0 | PRJNA494251 | 17636 | 334 | 1.750958 | 5.84819972 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 90.1 | 1.5e-19 | NR | RMG30150.1 | 2026739 | g17322 | i0 | 45.9 | 1.77844311377246 | 98 | 53 | 88 | 0 | 299 | 6 | 7 | 104 | RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] | diamond | 594 | 90.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31546421 | 31546421 | PRJNA494251_P_NODE_20136_length_316_cov_2.432099_g19822_i0 | PRJNA494251 | 20136 | 316 | 2.432099 | 7.68543284 | Methanomicrobiales | 2191 | Archaea | Archaea | 60.5 | 4.82e-8 | NR | WP_318622147.1 | 394967 | g19822 | i0 | 39.4 | 3.9493670886076 | 104 | 52 | 98.7 | 3 | 314 | 3 | 33 | 125 | WP_318622147.1 peptide chain release factor aRF-1 [Methanoculleus receptaculi] | diamond | 1248 | 60.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus receptaculi | |
| 31641041 | 31641041 | PRJNA494251_P_NODE_37256_length_251_cov_0.865169_g36942_i0 | PRJNA494251 | 37256 | 251 | 0.865169 | 2.17157419 | Methanobacteriati | 3366610 | Archaea | Archaea | 48.9 | 2.68e-4 | NR | MAY05171.1 | 2026739 | g36942 | i0 | 51.4 | 0.884462151394422 | 37 | 18 | 44.2 | 0 | 249 | 139 | 176 | 212 | MAY05171.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 222 | 49.3 | 0.991886409736308 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32068341 | 32068341 | PRJNA494251_P_NODE_43258_length_246_cov_0.890173_g42944_i0 | PRJNA494251 | 43258 | 246 | 0.890173 | 2.18982558 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 80.5 | 1.93e-15 | NR | RMG40079.1 | 2026739 | g42944 | i0 | 50 | 0.951219512195122 | 78 | 34 | 95.1 | 1 | 239 | 6 | 445 | 517 | RMG40079.1 MAG: S9 family peptidase [Methanobacteriota archaeon] | diamond | 234 | 80.5 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota 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);;