contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10382653 | 10382653 | PRJNA1063685_S_NODE_1549_length_980_cov_17.334068_g1258_i0 | PRJNA1063685 | 1549 | 980 | 17.334068 | 169.8738664 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 280 | 3.419999999999999e-89 | NR | RYE82365.1 | 2250255 | g1258 | i0 | 47.2 | 0.91530612244898 | 299 | 155 | 90.9 | 2 | 935 | 45 | 24 | 321 | RYE82365.1 MAG: fatty acid desaturase, partial [Methanosarcinales archaeon] | diamond | 897 | 280 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26814052 | 26814052 | PRJNA1063685_S_NODE_9741_length_633_cov_1.787500_g9229_i0 | PRJNA1063685 | 9741 | 633 | 1.7875 | 11.314875 | Halorussus halophilus | 2650975 | Archaea | Archaea | 64.3 | 8.47e-9 | NR | WP_158056415.1 | 2650975 | g9229 | i0 | 36.4 | 1.35545023696682 | 140 | 68 | 57.8 | 7 | 68 | 433 | 36 | 172 | WP_158056415.1 CHRD domain-containing protein [Halorussus halophilus] | diamond | 858 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus halophilus | |
| 26972128 | 26972128 | PRJNA1063685_S_NODE_8162_length_660_cov_3.415673_g7662_i0 | PRJNA1063685 | 8162 | 660 | 3.415673 | 22.5434418 | Halosimplex aquaticum | 3026162 | Archaea | Archaea | 112 | 1.66e-24 | NR | WP_274325319.1 | 3026162 | g7662 | i0 | 30.3 | 1.91818181818182 | 211 | 136 | 92.7 | 2 | 648 | 37 | 281 | 487 | WP_274325319.1 PAS domain-containing sensor histidine kinase [Halosimplex aquaticum] | diamond | 1266 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex aquaticum | |
| 29656095 | 29656095 | PRJNA1063685_S_NODE_35230_length_395_cov_2.537267_g34687_i0 | PRJNA1063685 | 35230 | 395 | 2.537267 | 10.02220465 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 64.3 | 3.56e-10 | NR | MCZ7358185.1 | 2032688 | g34687 | i0 | 34 | 3.91139240506329 | 103 | 66 | 78.2 | 1 | 7 | 315 | 17 | 117 | MCZ7358185.1 SRPBCC family protein [Candidatus Methanoperedens sp.] | diamond | 1545 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 30161661 | 30161661 | PRJNA1063685_S_NODE_33692_length_404_cov_5.057402_g33150_i0 | PRJNA1063685 | 33692 | 404 | 5.057402 | 20.43190408 | Candidatus Methanogaster sp. ANME-2c ERB4 | 2759911 | Archaea | Archaea | 96.3 | 2.62e-20 | NR | AAU82580.1 | 2759911 | g33150 | i0 | 39.1 | 3.8168316831683202 | 138 | 73 | 98.8 | 5 | 402 | 4 | 191 | 322 | AAU82580.1 hypothetical protein GZ18F2_10 [Candidatus Methanogaster sp. ANME-2c ERB4] | diamond | 1542 | 96.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanogasteraceae | Candidatus Methanogaster | Candidatus Methanogaster sp. ANME-2c ERB4 | |
| 30257055 | 30257055 | PRJNA1063685_S_NODE_51212_length_314_cov_1.278008_g50669_i0 | PRJNA1063685 | 51212 | 314 | 1.278008 | 4.01294512 | Methanofollis sp. | 2052835 | Archaea | Archaea | 44.7 | 0.0187 | NR | MDK2974386.1 | 2052835 | g50669 | i0 | 34.8 | 0.85031847133758 | 89 | 53 | 82.2 | 3 | 5 | 262 | 904 | 990 | MDK2974386.1 hypothetical protein [Methanofollis sp.] | diamond | 267 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis sp. | |
| 30446435 | 30446435 | PRJNA1063685_S_NODE_4893_length_735_cov_24.883686_g4463_i0 | PRJNA1063685 | 4893 | 735 | 24.883686 | 182.8950921 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 58.5 | 4.63e-6 | NR | MCI4343664.1 | 1906666 | g4463 | i0 | 28.3 | 0.763265306122449 | 187 | 109 | 68.2 | 6 | 718 | 218 | 68 | 249 | MCI4343664.1 MBL fold metallo-hydrolase [Thermoplasmata archaeon] | diamond | 561 | 58.5 | 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);;