contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10539234 | 10539234 | PRJNA1227535_P_NODE_25969_length_248_cov_0.891429_g25845_i0 | PRJNA1227535 | 25969 | 248 | 0.891429 | 2.21074392 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 148 | 2.72e-39 | NR | MDZ7849945.1 | 1980530 | g25845 | i0 | 92.7 | 1.98387096774194 | 82 | 6 | 99.2 | 0 | 247 | 2 | 40 | 121 | MDZ7849945.1 ATP-dependent DNA helicase [Halodesulfurarchaeum sp.] | diamond | 492 | 148 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 27262489 | 27262489 | PRJNA1227535_P_NODE_19983_length_258_cov_2.924324_g19859_i0 | PRJNA1227535 | 19983 | 258 | 2.924324 | 7.54475592 | Natrinema sp. DC36 | 2878680 | Archaea | Archaea | 45.8 | 0.0028 | NR | WP_226041190.1 | 2878680 | g19859 | i0 | 38.2 | 1.03488372093023 | 89 | 48 | 100 | 4 | 258 | 1 | 121 | 205 | WP_226041190.1 hypothetical protein [Natrinema sp. DC36] | diamond | 267 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. DC36 | |
| 27628808 | 27628808 | PRJNA1227535_P_NODE_33384_length_227_cov_2.025974_g33260_i0 | PRJNA1227535 | 33384 | 227 | 2.025974 | 4.59896098 | Halonotius | 869896 | Archaea | Archaea | 128 | 4.42e-33 | NR | WP_120101492.1 | 2216978 | g33260 | i0 | 90.7 | 2.97356828193833 | 75 | 7 | 99.1 | 0 | 226 | 2 | 268 | 342 | WP_120101492.1 bifunctional hydroxymethylpyrimidine kinase/phosphomethylpyrimidine kinase [Halonotius aquaticus] | diamond | 675 | 129 | 0.992248062015504 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius aquaticus | |
| 28936026 | 28936026 | PRJNA1227535_P_NODE_22228_length_253_cov_0.866667_g22104_i0 | PRJNA1227535 | 22228 | 253 | 0.866667 | 2.19266751 | Halodesulfurarchaeum sp. HSR-GB | 3074077 | Archaea | Archaea | 76.6 | 4.86e-14 | NR | WP_310553072.1 | 3074077 | g22104 | i0 | 66.7 | 0.640316205533597 | 54 | 18 | 64 | 0 | 163 | 2 | 1 | 54 | WP_310553072.1 COG1361 S-layer family protein [Halodesulfurarchaeum sp. HSR-GB] | diamond | 162 | 76.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. HSR-GB | |
| 28999466 | 28999466 | PRJNA1227535_P_NODE_18708_length_263_cov_1.231579_g18584_i0 | PRJNA1227535 | 18708 | 263 | 1.231579 | 3.23905277 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 57.8 | 2.09e-7 | NR | HUV84177.1 | 2250255 | g18584 | i0 | 39.5 | 0.980988593155893 | 86 | 50 | 98.1 | 1 | 259 | 2 | 132 | 215 | HUV84177.1 N4-gp56 family major capsid protein [Methanosarcinales archaeon] | diamond | 258 | 57.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 29062395 | 29062395 | PRJNA1227535_P_NODE_12228_length_285_cov_1.136792_g12105_i0 | PRJNA1227535 | 12228 | 285 | 1.136792 | 3.2398572 | Methanobacterium sp. | 2164 | Archaea | Archaea | 127 | 6.059999999999999e-35 | NR | TMS40652.1 | 2164 | g12105 | i0 | 81.3 | 1.57894736842105 | 75 | 14 | 78.9 | 0 | 59 | 283 | 1 | 75 | TMS40652.1 MAG: hypothetical protein FGO69_10600 [Methanobacterium sp.] | diamond | 450 | 127 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31196942 | 31196942 | PRJNA1227535_P_NODE_30675_length_242_cov_0.923077_g30551_i0 | PRJNA1227535 | 30675 | 242 | 0.923077 | 2.23384634 | Halobacteriales | 2235 | Archaea | Archaea | 86.3 | 3.3e-18 | NR | SEP16067.1 | 1367881 | g30551 | i0 | 51.3 | 7.71074380165289 | 78 | 38 | 96.7 | 0 | 1 | 234 | 123 | 200 | SEP16067.1 exodeoxyribonuclease VII large subunit [Halorientalis persicus] | diamond | 1866 | 87 | 0.991954022988506 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis persicus | |
| 31621298 | 31621298 | PRJNA1227535_P_NODE_22716_length_252_cov_0.871508_g22592_i0 | PRJNA1227535 | 22716 | 252 | 0.871508 | 2.19620016 | Methanobacterium sp. | 2164 | Archaea | Archaea | 75.1 | 1.32e-15 | NR | HEY0196787.1 | 2164 | g22592 | i0 | 70.5 | 0.928571428571429 | 78 | 23 | 92.9 | 0 | 251 | 18 | 5 | 82 | HEY0196787.1 hypothetical protein [Methanobacterium sp.] | diamond | 234 | 75.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. |
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);;