contig_metadata
11 rows where bioproject = "PRJEB28062", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15327401 | 15327401 | PRJEB28062_P_NODE_64473_length_432_cov_61.637883_g62112_i0 | PRJEB28062 | 64473 | 432 | 61.637883 | 266.27565456 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 53.1 | 6.59e-5 | NR | MBN1389494.1 | 2806419 | g62112 | i0 | 34.5 | 1.45833333333333 | 110 | 67 | 73.6 | 2 | 4 | 321 | 658 | 766 | MBN1389494.1 DEAD/DEAH box helicase [Thermoplasmatota archaeon] | diamond | 630 | 53.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27096367 | 27096367 | PRJEB28062_P_NODE_47682_length_519_cov_9.735426_g45336_i0 | PRJEB28062 | 47682 | 519 | 9.735426 | 50.52686094 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 79.7 | 8.44e-14 | NR | MFA5453437.1 | 2517205 | g45336 | i0 | 40.6 | 1.74566473988439 | 133 | 66 | 74 | 6 | 5 | 388 | 37 | 161 | MFA5453437.1 glycosyl hydrolase family 28-related protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 906 | 79.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 27349533 | 27349533 | PRJEB28062_P_NODE_48623_length_513_cov_12.263636_g46276_i0 | PRJEB28062 | 48623 | 513 | 12.263636 | 62.91245268 | Methanomassiliicoccus luminyensis | 1080712 | Archaea | Archaea | 47.8 | 0.00145 | NR | WP_019177695.1 | 1080712 | g46276 | i0 | 29.5 | 0.514619883040936 | 88 | 56 | 48.5 | 3 | 409 | 161 | 1 | 87 | WP_019177695.1 hypothetical protein [Methanomassiliicoccus luminyensis] | diamond | 264 | 47.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Methanomassiliicoccus luminyensis | ||
| 28106978 | 28106978 | PRJEB28062_P_NODE_135065_length_224_cov_17.205298_g132701_i0 | PRJEB28062 | 135065 | 224 | 17.205298 | 38.53986752 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 42.4 | 0.0407 | NR | MEK9697218.1 | 2163009 | g132701 | i0 | 41.5 | 0.870535714285714 | 65 | 36 | 84.4 | 1 | 199 | 11 | 617 | 681 | MEK9697218.1 DUF4815 domain-containing protein [Candidatus Poseidoniales archaeon] | diamond | 195 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 29086049 | 29086049 | PRJEB28062_P_NODE_38748_length_585_cov_83.089844_g36418_i0 | PRJEB28062 | 38748 | 585 | 83.089844 | 486.0755874 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 47.8 | 0.00395 | NR | MEM3345770.1 | 1906666 | g36418 | i0 | 44.3 | 0.312820512820513 | 61 | 33 | 31.3 | 1 | 291 | 473 | 1 | 60 | MEM3345770.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 183 | 47.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29748683 | 29748683 | PRJEB28062_P_NODE_81531_length_372_cov_2.872910_g79169_i0 | PRJEB28062 | 81531 | 372 | 2.87291 | 10.6872252 | Methanomassiliicoccales archaeon PtaB.Bin215 | 1811728 | Archaea | Archaea | 89.7 | 9.94e-19 | NR | OPX63769.1 | 1811728 | g79169 | i0 | 87.8 | 0.395161290322581 | 49 | 6 | 39.5 | 0 | 354 | 208 | 184 | 232 | OPX63769.1 MAG: hypothetical protein A4E30_00576 [Methanomassiliicoccales archaeon PtaB.Bin215] | diamond | 147 | 89.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon PtaB.Bin215 | ||||
| 30570091 | 30570091 | PRJEB28062_P_NODE_85553_length_359_cov_6.258741_g83191_i0 | PRJEB28062 | 85553 | 359 | 6.258741 | 22.46888019 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 49.7 | 4.9e-4 | NR | RLF66359.1 | 1906666 | g83191 | i0 | 28.9 | 0.952646239554318 | 114 | 70 | 86.1 | 2 | 27 | 335 | 22 | 135 | RLF66359.1 MAG: hypothetical protein DRN30_02300 [Thermoplasmata archaeon] | diamond | 342 | 49.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31075995 | 31075995 | PRJEB28062_P_NODE_68895_length_415_cov_20.198830_g66534_i0 | PRJEB28062 | 68895 | 415 | 20.19883 | 83.8251445 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 92.4 | 4e-19 | NR | MFA5453182.1 | 2517205 | g66534 | i0 | 62.1 | 0.47710843373494 | 66 | 24 | 47.7 | 1 | 223 | 26 | 48 | 112 | MFA5453182.1 phage terminase large subunit [Candidatus Methanomethylophilaceae archaeon] | diamond | 198 | 92.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 31259040 | 31259040 | PRJEB28062_P_NODE_45415_length_534_cov_1.242950_g43076_i0 | PRJEB28062 | 45415 | 534 | 1.24295 | 6.637353 | root | 1 | Root_unresolved | Root_unresolved | 119 | 4.1e-29 | NR | MEK9694254.1 | 2163009 | g43076 | i0 | 80.8 | 1.23595505617978 | 73 | 10 | 41 | 1 | 3 | 221 | 233 | 301 | MEK9694254.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 660 | 119 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 32246502 | 32246502 | PRJEB28062_P_NODE_57478_length_464_cov_1.979540_g55123_i0 | PRJEB28062 | 57478 | 464 | 1.97954 | 9.1850656 | Ferroplasma sp. | 2591003 | Archaea | Archaea | 44.7 | 0.0429 | NR | WP_298278900.1 | 2591003 | g55123 | i0 | 25.5 | 0.607758620689655 | 94 | 62 | 60.8 | 1 | 297 | 16 | 29 | 114 | WP_298278900.1 hypothetical protein [Ferroplasma sp.] | diamond | 282 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Ferroplasma | Ferroplasma sp. | ||
| 32594197 | 32594197 | PRJEB28062_P_NODE_45280_length_534_cov_66.041215_g42941_i0 | PRJEB28062 | 45280 | 534 | 66.041215 | 352.6600881 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 50.1 | 4.37e-4 | NR | MEM3345770.1 | 1906666 | g42941 | i0 | 44.6 | 0.415730337078652 | 74 | 33 | 37.6 | 2 | 244 | 44 | 1 | 73 | MEM3345770.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 222 | 50.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);;