contig_metadata
7 rows where bioproject = "PRJNA222400", tax_kingdom = "Methanobacteriati" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13809946 | 13809946 | PRJNA222400_P_NODE_2271_length_328_cov_2.143369_g2238_i0 | PRJNA222400 | 2271 | 328 | 2.143369 | 7.03025032 | Haloquadratum | 293431 | Archaea | Archaea | 60.2 | 1.84e-4 | NTclustered | gi|109624723|emb|AM180088.1| | 362976 | g2238 | i0 | 97.143 | 0.414634146341463 | 35 | 1 | 11 | 0 | 217 | 251 | 416558 | 416524 | Haloquadratum walsbyi DSM 16790 complete genome | blastn | 136 | 60.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloquadratum | Haloquadratum walsbyi | |
| 13809951 | 13809951 | PRJNA222400_P_NODE_5591_length_190_cov_0.879433_g5558_i0 | PRJNA222400 | 5591 | 190 | 0.879433 | 1.6709227 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 1.62e-7 | NTclustered | gi|409168338|gb|CP003083.1| | 1094980 | g5558 | i0 | 93.617 | 3.37894736842105 | 47 | 1 | 26 | 2 | 31 | 77 | 237478 | 237434 | Methanolobus psychrophilus R15 chromosome, complete genome | blastn | 642 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus psychrophilus | |
| 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 | ||||||
| 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 |
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);;