contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26968438 | 26968438 | PRJNA900028_P_NODE_195962_length_161_cov_0.910714_g195213_i0 | PRJNA900028 | 195962 | 161 | 0.910714 | 1.46624954 | Halobacteriales | 2235 | Archaea | Archaea | 81.6 | 1.91e-17 | NR | WP_121744904.1 | 1702106 | g195213 | i0 | 78.8 | 2.92546583850932 | 52 | 11 | 96.9 | 0 | 159 | 4 | 6 | 57 | WP_121744904.1 recombinase family protein [Natronorubrum halophilum] | diamond | 471 | 82.4 | 0.990291262135922 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum halophilum | |
| 28326577 | 28326577 | PRJNA900028_P_NODE_148206_length_165_cov_0.879310_g147457_i0 | PRJNA900028 | 148206 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 1.3e-5 | NR | RQW80199.1 | 90426 | g147457 | i0 | 52.5 | 6.58181818181818 | 40 | 19 | 72.7 | 0 | 161 | 42 | 368 | 407 | RQW80199.1 MAG: DNA helicase RecQ [Methanothrix sp.] | diamond | 1086 | 51.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28389826 | 28389826 | PRJNA900028_P_NODE_178846_length_162_cov_0.902655_g178097_i0 | PRJNA900028 | 178846 | 162 | 0.902655 | 1.4623011 | Natronomonas | 63743 | Archaea | Archaea | 43.1 | 0.00905 | NR | WP_410321013.1 | 2184060 | g178097 | i0 | 88 | 1.38888888888889 | 25 | 3 | 46.3 | 0 | 11 | 85 | 1 | 25 | WP_410321013.1 DUF2298 domain-containing protein [Natronomonas sp.] | diamond | 225 | 43.5 | 0.990804597701149 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. | |
| 28413897 | 28413897 | PRJNA900028_P_NODE_132526_length_166_cov_0.871795_g131777_i0 | PRJNA900028 | 132526 | 166 | 0.871795 | 1.4471797 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 99.8 | 9.14e-23 | NR | MBS3761550.1 | 1980530 | g131777 | i0 | 92.5 | 0.957831325301205 | 53 | 4 | 95.8 | 0 | 159 | 1 | 434 | 486 | MBS3761550.1 molybdopterin-dependent oxidoreductase [Halodesulfurarchaeum sp.] | diamond | 159 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 28484658 | 28484658 | PRJNA900028_P_NODE_56926_length_200_cov_1.350993_g56177_i0 | PRJNA900028 | 56926 | 200 | 1.350993 | 2.701986 | root | 1 | Root_unresolved | Root_unresolved | 94.7 | 5.22e-21 | NR | MDD1724742.1 | 45200 | g56177 | i0 | 63.6 | 38.535 | 66 | 24 | 99 | 0 | 2 | 199 | 148 | 213 | MDD1724742.1 cysteine desulfurase NifS [Methanospirillum sp.] | diamond | 7707 | 94.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29589356 | 29589356 | PRJNA900028_P_NODE_185330_length_162_cov_0.902655_g184581_i0 | PRJNA900028 | 185330 | 162 | 0.902655 | 1.4623011 | Halobacteriales | 2235 | Archaea | Archaea | 89.4 | 4.62e-19 | NR | MFB6202471.1 | 1961697 | g184581 | i0 | 77.4 | 1.96296296296296 | 53 | 12 | 98.1 | 0 | 3 | 161 | 506 | 558 | MFB6202471.1 winged helix-turn-helix domain-containing protein [Halorhabdus sp.] | diamond | 318 | 89.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus sp. | |
| 30245573 | 30245573 | PRJNA900028_P_NODE_67852_length_190_cov_1.446809_g67103_i0 | PRJNA900028 | 67852 | 190 | 1.446809 | 2.7489371 | Methanogenium sp. | 2196 | Archaea | Archaea | 58.2 | 6.13e-8 | NR | MFA5395000.1 | 2196 | g67103 | i0 | 41.3 | 1.98947368421053 | 63 | 37 | 99.5 | 0 | 1 | 189 | 46 | 108 | MFA5395000.1 HAD family acid phosphatase [Methanogenium sp.] | diamond | 378 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 30687572 | 30687572 | PRJNA900028_P_NODE_161433_length_164_cov_0.886957_g160684_i0 | PRJNA900028 | 161433 | 164 | 0.886957 | 1.45460948 | Haloplanus sp. GCM1 | 1961696 | Archaea | Archaea | 77.8 | 1.73e-16 | NR | WP_379798203.1 | 3252679 | g160684 | i0 | 82.6 | 0.841463414634146 | 46 | 8 | 84.1 | 0 | 26 | 163 | 1 | 46 | WP_379798203.1 hypothetical protein [Haloplanus sp. GCM10025708] | diamond | 138 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. GCM10025708 | |
| 30750936 | 30750936 | PRJNA900028_P_NODE_143414_length_165_cov_0.879310_g142665_i0 | PRJNA900028 | 143414 | 165 | 0.87931 | 1.4508615 | Halorubrum miltondacostae | 3076378 | Archaea | Archaea | 114 | 6.03e-29 | NR | WP_371163206.1 | 3076378 | g142665 | i0 | 94.4 | 0.981818181818182 | 54 | 3 | 98.2 | 0 | 163 | 2 | 104 | 157 | WP_371163206.1 dipeptidase [Halorubrum miltondacostae] | diamond | 162 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum miltondacostae | |
| 30972186 | 30972186 | PRJNA900028_P_NODE_55434_length_202_cov_1.000000_g54685_i0 | PRJNA900028 | 55434 | 202 | 1 | 2.02 | Methanoregula sp. | 2052170 | Archaea | Archaea | 63.5 | 7.78e-10 | NR | HSQ94427.1 | 2052170 | g54685 | i0 | 50.8 | 2.62871287128713 | 63 | 31 | 93.6 | 0 | 202 | 14 | 144 | 206 | HSQ94427.1 PP2C family serine/threonine-protein phosphatase [Methanoregula sp.] | diamond | 531 | 63.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 30972194 | 30972194 | PRJNA900028_P_NODE_72134_length_188_cov_1.467626_g71385_i0 | PRJNA900028 | 72134 | 188 | 1.467626 | 2.75913688 | Halobellus ruber | 2761102 | Archaea | Archaea | 93.2 | 2.44e-21 | NR | WP_185193430.1 | 2761102 | g71385 | i0 | 66.7 | 0.957446808510638 | 60 | 20 | 95.7 | 0 | 3 | 182 | 158 | 217 | WP_185193430.1 DUF547 domain-containing protein [Halobellus ruber] | diamond | 180 | 93.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus ruber |
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);;