contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3989343 | 3989343 | PRJNA1025141_P_NODE_2624_length_506_cov_1.551963_g2563_i0 | PRJNA1025141 | 2624 | 506 | 1.551963 | 7.85293278 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 147 | 1.24e-40 | NR | RYE97637.1 | 2026739 | g2563 | i0 | 70.5 | 0.66403162055336 | 112 | 31 | 65.2 | 1 | 177 | 506 | 20 | 131 | RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon] | diamond | 336 | 147 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 18855790 | 18855790 | PRJNA1025141_P_NODE_415_length_1169_cov_4.146898_g388_i0 | PRJNA1025141 | 415 | 1169 | 4.146898 | 48.47723762 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 607 | 8.879999999999997e-216 | NR | RYE83110.1 | 2250255 | g388 | i0 | 79.5 | 0.962360992301112 | 375 | 77 | 96.2 | 0 | 2 | 1126 | 42 | 416 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 1125 | 607 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 24388862 | 24388862 | PRJNA1025141_P_NODE_3580_length_431_cov_1.402235_g3519_i0 | PRJNA1025141 | 3580 | 431 | 1.402235 | 6.04363285 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 227 | 6.32e-73 | NR | RYE84306.1 | 2250255 | g3519 | i0 | 79.4 | 0.946635730858469 | 136 | 28 | 94.7 | 0 | 2 | 409 | 88 | 223 | RYE84306.1 MAG: 50S ribosomal protein L3 [Methanosarcinales archaeon] | diamond | 408 | 227 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26813527 | 26813527 | PRJNA1025141_P_NODE_921_length_855_cov_1.439898_g873_i0 | PRJNA1025141 | 921 | 855 | 1.439898 | 12.3111279 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 116 | 3.86e-25 | NR | MEE3419037.1 | 2666342 | g873 | i0 | 35.2 | 0.757894736842105 | 216 | 130 | 74.4 | 4 | 173 | 808 | 874 | 1083 | MEE3419037.1 hypothetical protein [Methanosphaera sp.] | diamond | 648 | 116 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 27635437 | 27635437 | PRJNA1025141_P_NODE_6044_length_326_cov_0.735178_g5983_i0 | PRJNA1025141 | 6044 | 326 | 0.735178 | 2.39668028 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 96.7 | 1.23e-22 | NR | RYE99645.1 | 2026739 | g5983 | i0 | 54.8 | 0.957055214723926 | 104 | 34 | 90.2 | 2 | 326 | 33 | 61 | 157 | RYE99645.1 MAG: hypothetical protein EOO41_00780 [Methanobacteriota archaeon] | diamond | 312 | 96.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27730345 | 27730345 | PRJNA1025141_P_NODE_8664_length_264_cov_1.408377_g8603_i0 | PRJNA1025141 | 8664 | 264 | 1.408377 | 3.71811528 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 89 | 2.33e-19 | NR | RYE97637.1 | 2026739 | g8603 | i0 | 60 | 0.795454545454545 | 70 | 27 | 78.4 | 1 | 209 | 3 | 20 | 89 | RYE97637.1 MAG: C1 family peptidase, partial [Methanobacteriota archaeon] | diamond | 210 | 89 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27919384 | 27919384 | PRJNA1025141_P_NODE_11085_length_246_cov_1.335260_g11024_i0 | PRJNA1025141 | 11085 | 246 | 1.33526 | 3.2847396 | Halorubrum sp. BV1 | 1498500 | Archaea | Archaea | 43.1 | 0.0277 | NR | WP_049984514.1 | 1498500 | g11024 | i0 | 35.4 | 0.792682926829268 | 65 | 35 | 70.7 | 2 | 17 | 190 | 136 | 200 | WP_049984514.1 PAS domain-containing protein [Halorubrum sp. BV1] | diamond | 195 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. BV1 | |
| 28290327 | 28290327 | PRJNA1025141_P_NODE_3706_length_422_cov_2.071633_g3645_i0 | PRJNA1025141 | 3706 | 422 | 2.071633 | 8.74229126 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 2.13e-14 | NR | MBO7518105.1 | 66852 | g3645 | i0 | 69.4 | 1.84123222748815 | 49 | 14 | 34.1 | 1 | 323 | 180 | 423 | 471 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 777 | 80.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter 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);;