contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2957057 | 2957057 | PRJNA385073_P_NODE_55643_length_243_cov_0.905882_g55481_i0 | PRJNA385073 | 55643 | 243 | 0.905882 | 2.20129326 | Methanofollis ethanolicus | 488124 | Archaea | Archaea | 150 | 3.209999999999999e-43 | NR | WP_067049206.1 | 488124 | g55481 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 241 | 2 | 130 | 209 | WP_067049206.1 translation initiation factor IF-2 subunit alpha [Methanofollis ethanolicus] | diamond | 240 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis ethanolicus | |
| 22082680 | 22082680 | PRJNA385073_P_NODE_49858_length_246_cov_0.890173_g49696_i0 | PRJNA385073 | 49858 | 246 | 0.890173 | 2.18982558 | Methanospirillum sp. | 45200 | Archaea | Archaea | 132 | 4.62e-35 | NR | MEN6341541.1 | 45200 | g49696 | i0 | 79 | 1.98780487804878 | 81 | 17 | 98.8 | 0 | 244 | 2 | 149 | 229 | MEN6341541.1 hypothetical protein [Methanospirillum sp.] | diamond | 489 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 26632032 | 26632032 | PRJNA385073_P_NODE_42441_length_251_cov_0.865169_g42279_i0 | PRJNA385073 | 42441 | 251 | 0.865169 | 2.17157419 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 140 | 2.02e-40 | NR | HIH02966.1 | 2485498 | g42279 | i0 | 84.3 | 0.99203187250996006 | 83 | 13 | 99.2 | 0 | 2 | 250 | 77 | 159 | HIH02966.1 Hsp20/alpha crystallin family protein [Methanoregulaceae archaeon] | diamond | 249 | 140 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 27675704 | 27675704 | PRJNA385073_P_NODE_46724_length_248_cov_0.880000_g46562_i0 | PRJNA385073 | 46724 | 248 | 0.88 | 2.1824 | Methanosarcina sp. UBA411 | 1915589 | Archaea | Archaea | 158 | 5.55e-45 | NR | WP_292374803.1 | 1915589 | g46562 | i0 | 95.1 | 0.991935483870968 | 82 | 4 | 99.2 | 0 | 246 | 1 | 98 | 179 | WP_292374803.1 hypothetical protein [Methanosarcina sp. UBA411] | diamond | 246 | 158 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. UBA411 | |
| 28496503 | 28496503 | PRJNA385073_P_NODE_44067_length_250_cov_0.870056_g43905_i0 | PRJNA385073 | 44067 | 250 | 0.870056 | 2.17514 | Methanoculleus sp. 1 | 90427 | Archaea | Archaea | 102 | 2.96e-23 | NR | WP_292489426.1 | 430615 | g43905 | i0 | 67.1 | 0.984 | 82 | 26 | 97.2 | 1 | 3 | 245 | 679 | 760 | WP_292489426.1 SwmB domain-containing protein [Methanoculleus sp. 10] | diamond | 246 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. 10 | |
| 28528140 | 28528140 | PRJNA385073_P_NODE_55627_length_243_cov_0.905882_g55465_i0 | PRJNA385073 | 55627 | 243 | 0.905882 | 2.20129326 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 114 | 2.4599999999999996e-29 | NR | WP_013719891.1 | 2223 | g55465 | i0 | 65.9 | 1.08641975308642 | 88 | 22 | 98.8 | 1 | 241 | 2 | 20 | 107 | WP_013719891.1 tetratricopeptide repeat protein [Methanothrix soehngenii] | diamond | 264 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 30282041 | 30282041 | PRJNA385073_P_NODE_11452_length_387_cov_1.353503_g11291_i0 | PRJNA385073 | 11452 | 387 | 1.353503 | 5.23805661 | Methanothrix | 2222 | Archaea | Archaea | 254 | 3.59e-81 | NR | WP_324308066.1 | 2223 | g11291 | i0 | 98.4 | 1.98449612403101 | 128 | 2 | 99.2 | 0 | 386 | 3 | 82 | 209 | WP_324308066.1 type I restriction endonuclease, partial [Methanothrix soehngenii] | diamond | 768 | 254 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 31180709 | 31180709 | PRJNA385073_P_NODE_50615_length_246_cov_0.890173_g50453_i0 | PRJNA385073 | 50615 | 246 | 0.890173 | 2.18982558 | Methanofastidiosum sp. | 2666341 | Archaea | Archaea | 84.7 | 7.92e-19 | NR | HNU62030.1 | 2666341 | g50453 | i0 | 67.7 | 1.51219512195122 | 62 | 20 | 75.6 | 0 | 60 | 245 | 1 | 62 | HNU62030.1 deaminase [Methanofastidiosum sp.] | diamond | 372 | 84.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosales | Candidatus Methanofastidiosaceae | Candidatus Methanofastidiosum | Methanofastidiosum sp. | |
| 31433965 | 31433965 | PRJNA385073_P_NODE_52436_length_245_cov_0.895349_g52274_i0 | PRJNA385073 | 52436 | 245 | 0.895349 | 2.19360505 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 175 | 3.88e-49 | NR | WP_287848715.1 | 2223 | g52274 | i0 | 100 | 3.96734693877551 | 81 | 0 | 99.2 | 0 | 244 | 2 | 521 | 601 | WP_287848715.1 CHAT domain-containing protein [Methanothrix soehngenii] | diamond | 972 | 175 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 31750188 | 31750188 | PRJNA385073_P_NODE_46877_length_248_cov_0.880000_g46715_i0 | PRJNA385073 | 46877 | 248 | 0.88 | 2.1824 | Methanosaeta sp. PtaU1.Bin112 | 1811689 | Archaea | Archaea | 161 | 8.76e-44 | NR | OPY56055.1 | 1811689 | g46715 | i0 | 96.3 | 0.991935483870968 | 82 | 3 | 99.2 | 0 | 1 | 246 | 767 | 848 | OPY56055.1 MAG: type I restriction enzyme EcoKI subunit R [Methanosaeta sp. PtaU1.Bin112] | diamond | 246 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaU1.Bin112 | |
| 31971710 | 31971710 | PRJNA385073_P_NODE_16558_length_340_cov_2.883895_g16397_i0 | PRJNA385073 | 16558 | 340 | 2.883895 | 9.805243 | Methanothrix sp. | 90426 | Archaea | Archaea | 69.7 | 9.99e-13 | NR | MDD1750004.1 | 90426 | g16397 | i0 | 67.4 | 0.405882352941176 | 46 | 15 | 40.6 | 0 | 184 | 47 | 63 | 108 | MDD1750004.1 hypothetical protein [Methanothrix sp.] | diamond | 138 | 69.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 32273632 | 32273632 | PRJNA385073_P_NODE_41918_length_251_cov_0.865169_g41756_i0 | PRJNA385073 | 41918 | 251 | 0.865169 | 2.17157419 | Stenosarchaea group | 2290931 | Archaea | Archaea | 116 | 1.44e-28 | NR | HPE52240.1 | 2223 | g41756 | i0 | 79.7 | 1.66135458167331 | 69 | 14 | 82.5 | 0 | 1 | 207 | 393 | 461 | HPE52240.1 DUF2207 domain-containing protein [Methanothrix soehngenii] | diamond | 417 | 117 | 0.991452991452991 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii |
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);;