contig_metadata
7 rows where bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26653328 | 26653328 | PRJEB43370_P_NODE_6221_length_184_cov_1.259259_g6178_i0 | PRJEB43370 | 6221 | 184 | 1.259259 | 2.31703656 | Halonotius sp. J | 2218529 | Archaea | Archaea | 43.9 | 0.00667 | NR | ERH05107.1 | 1070774 | g6178 | i0 | 40.4 | 3.60326086956522 | 52 | 27 | 84.8 | 1 | 5 | 160 | 87 | 134 | ERH05107.1 MAG: ABC-type transport system, periplasmic component/surface lipoprotein [Halonotius sp. J07HN4] | diamond | 663 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius sp. J07HN4 | |
| 26994884 | 26994884 | PRJEB43370_P_NODE_5462_length_194_cov_1.434483_g5419_i0 | PRJEB43370 | 5462 | 194 | 1.434483 | 2.78289702 | Methanobacteriati | 3366610 | Archaea | Archaea | 105 | 7.26e-26 | NR | MBH33411.1 | 2026739 | g5419 | i0 | 76.6 | 3.94329896907217 | 64 | 15 | 99 | 0 | 1 | 192 | 223 | 286 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 765 | 105 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27191388 | 27191388 | PRJEB43370_P_NODE_5622_length_192_cov_1.090909_g5579_i0 | PRJEB43370 | 5622 | 192 | 1.090909 | 2.09454528 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.4 | 0.00213 | NR | HKZ49298.1 | 1906666 | g5579 | i0 | 60.9 | 3.03125 | 46 | 16 | 71.9 | 2 | 53 | 190 | 1059 | 1102 | HKZ49298.1 PKD domain-containing protein [Thermoplasmata archaeon] | diamond | 582 | 45.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27949539 | 27949539 | PRJEB43370_P_NODE_4525_length_210_cov_6.267081_g4482_i0 | PRJEB43370 | 4525 | 210 | 6.267081 | 13.1608701 | Methanomassiliicoccales archaeon LGM-RCC1 | 3018355 | Archaea | Archaea | 41.2 | 0.00996 | NR | WII08072.1 | 3018355 | g4482 | i0 | 73.1 | 0.371428571428571 | 26 | 7 | 37.1 | 0 | 190 | 113 | 24 | 49 | WII08072.1 hypothetical protein PED39_02425 [Methanomassiliicoccales archaeon LGM-RCC1] | diamond | 78 | 41.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon LGM-RCC1 | ||||
| 28201875 | 28201875 | PRJEB43370_P_NODE_8166_length_168_cov_0.873950_g8123_i0 | PRJEB43370 | 8166 | 168 | 0.87395 | 1.468236 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 61.6 | 1.47e-9 | NR | MEE2759763.1 | 2806419 | g8123 | i0 | 68.3 | 1.46428571428571 | 41 | 13 | 73.2 | 0 | 44 | 166 | 1 | 41 | MEE2759763.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Thermoplasmatota archaeon] | diamond | 246 | 61.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29773993 | 29773993 | PRJEB43370_P_NODE_6031_length_186_cov_1.518248_g5988_i0 | PRJEB43370 | 6031 | 186 | 1.518248 | 2.82394128 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 1.52e-7 | NR | UCE38141.1 | 1906666 | g5988 | i0 | 42.4 | 3.85483870967742 | 59 | 34 | 95.2 | 0 | 5 | 181 | 106 | 164 | UCE38141.1 MAG: MTAP family purine nucleoside phosphorylase [Thermoplasmata archaeon] | diamond | 717 | 56.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31455608 | 31455608 | PRJEB43370_P_NODE_3236_length_242_cov_1.886010_g3193_i0 | PRJEB43370 | 3236 | 242 | 1.88601 | 4.5641442 | Methanocaldococcus villosus | 667126 | Archaea | Archaea | 56.2 | 1.41e-7 | NR | WP_004592618.1 | 667126 | g3193 | i0 | 40 | 0.991735537190083 | 80 | 31 | 99.2 | 2 | 242 | 3 | 78 | 140 | WP_004592618.1 30S ribosomal protein S19e [Methanocaldococcus villosus] | diamond | 240 | 56.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus villosus |
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);;