contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA222400" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27281520 | 27281520 | PRJNA222400_P_NODE_3663_length_236_cov_1.042781_g3630_i0 | PRJNA222400 | 3663 | 236 | 1.042781 | 2.46096316 | root | 1 | Root_unresolved | Root_unresolved | 57.8 | 1.74e-7 | NR | MAS63026.1 | 2026739 | g3630 | i0 | 36.8 | 3.96610169491525 | 68 | 39 | 86.4 | 1 | 208 | 5 | 557 | 620 | MAS63026.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 936 | 57.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28481361 | 28481361 | PRJNA222400_P_NODE_2886_length_279_cov_1.356522_g2853_i0 | PRJNA222400 | 2886 | 279 | 1.356522 | 3.78469638 | root | 1 | Root_unresolved | Root_unresolved | 62.4 | 5.09e-9 | NR | WP_117594871.1 | 2283527 | g2853 | i0 | 49.2 | 3.43010752688172 | 61 | 30 | 64.5 | 1 | 27 | 206 | 238 | 298 | WP_117594871.1 alpha/beta fold hydrolase [Haloprofundus halophilus] | diamond | 957 | 62.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus halophilus | |
| 31071347 | 31071347 | PRJNA222400_P_NODE_5235_length_195_cov_1.547945_g5202_i0 | PRJNA222400 | 5235 | 195 | 1.547945 | 3.01849275 | Methanoregula | 395331 | Archaea | Archaea | 107 | 3.1e-25 | NR | WP_325410687.1 | 2052170 | g5202 | i0 | 75.8 | 30.8461538461538 | 62 | 15 | 95.4 | 0 | 2 | 187 | 503 | 564 | WP_325410687.1 AMP-binding protein [Methanoregula sp.] | diamond | 6015 | 107 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 31812394 | 31812394 | PRJNA222400_P_NODE_5537_length_190_cov_1.475177_g5504_i0 | PRJNA222400 | 5537 | 190 | 1.475177 | 2.8028363 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 53.1 | 3.06e-7 | NR | MBE28306.1 | 2026739 | g5504 | i0 | 43.5 | 0.978947368421053 | 62 | 32 | 94.7 | 2 | 188 | 9 | 19 | 79 | MBE28306.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 186 | 53.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32241784 | 32241784 | PRJNA222400_P_NODE_4998_length_199_cov_2.193333_g4965_i0 | PRJNA222400 | 4998 | 199 | 2.193333 | 4.36473267 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 1.41e-15 | NR | EMR73564.1 | 1198116 | g4965 | i0 | 51.6 | 9.61809045226131 | 62 | 29 | 93.5 | 1 | 198 | 13 | 349 | 409 | EMR73564.1 acyl-CoA synthetase/AMP-acid ligase [Thermoplasmatales archaeon SCGC AB-539-N05] | diamond | 1914 | 80.9 | 0.990111248454882 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon SCGC AB-539-N05 | ||||
| 32255722 | 32255722 | PRJNA222400_P_NODE_2998_length_273_cov_0.928571_g2965_i0 | PRJNA222400 | 2998 | 273 | 0.928571 | 2.53499883 | Halorussus | 1070314 | Archaea | Archaea | 77.8 | 8.22e-16 | NR | WP_253514529.1 | 1070314 | g2965 | i0 | 61.1 | 1.17582417582418 | 54 | 21 | 59.3 | 0 | 107 | 268 | 15 | 68 | WP_253514529.1 MULTISPECIES: thiol-disulfide oxidoreductase DCC family protein [Halorussus] | diamond | 321 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | ||
| 32255723 | 32255723 | PRJNA222400_P_NODE_3238_length_257_cov_1.413462_g3205_i0 | PRJNA222400 | 3238 | 257 | 1.413462 | 3.63259734 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 60.1 | 3.51e-8 | NR | MCX8174265.1 | 1906666 | g3205 | i0 | 39.5 | 0.945525291828794 | 81 | 48 | 93.4 | 1 | 243 | 4 | 832 | 912 | MCX8174265.1 S8 family serine peptidase [Thermoplasmata archaeon] | diamond | 243 | 60.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;