contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 |
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);;