contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26896395 | 26896395 | PRJNA814235_P_NODE_186181_length_151_cov_3.640351_g184786_i0 | PRJNA814235 | 186181 | 151 | 3.640351 | 5.49693001 | Halococcus sp. | 29286 | Archaea | Archaea | 52.4 | 4.18e-6 | NR | HET7324631.1 | 29286 | g184786 | i0 | 80.8 | 0.516556291390728 | 26 | 5 | 51.7 | 0 | 74 | 151 | 326 | 351 | HET7324631.1 PD-(D/E)XK nuclease family protein [Halococcus sp.] | diamond | 78 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 27749659 | 27749659 | PRJNA814235_P_NODE_87424_length_203_cov_4.915663_g86029_i0 | PRJNA814235 | 87424 | 203 | 4.915663 | 9.97879589 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 94.7 | 1.07e-20 | NR | WP_181691861.1 | 2750669 | g86029 | i0 | 73.1 | 0.990147783251232 | 67 | 16 | 99 | 1 | 202 | 2 | 91 | 155 | WP_181691861.1 AMP-binding protein [Natronomonas sp. LN261] | diamond | 201 | 94.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27970306 | 27970306 | PRJNA814235_P_NODE_121005_length_203_cov_1.572289_g119610_i0 | PRJNA814235 | 121005 | 203 | 1.572289 | 3.19174667 | Halobellus clavatus | 660517 | Archaea | Archaea | 87.8 | 1.65e-18 | NR | WP_089768135.1 | 660517 | g119610 | i0 | 62.7 | 2.97044334975369 | 67 | 13 | 99 | 1 | 3 | 203 | 239 | 293 | WP_089768135.1 amidohydrolase family protein [Halobellus clavatus] | diamond | 603 | 87.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus clavatus | |
| 28601979 | 28601979 | PRJNA814235_P_NODE_185727_length_151_cov_3.745614_g184332_i0 | PRJNA814235 | 185727 | 151 | 3.7456140000000002 | 5.65587714 | Methanospirillum sp. | 45200 | Archaea | Archaea | 47 | 2.17e-4 | NR | MEN6342420.1 | 45200 | g184332 | i0 | 84.6 | 1.01324503311258 | 26 | 4 | 51.7 | 0 | 78 | 1 | 68 | 93 | MEN6342420.1 molybdopterin molybdenumtransferase MoeA [Methanospirillum sp.] | diamond | 153 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 29201954 | 29201954 | PRJNA814235_P_NODE_94629_length_203_cov_2.789157_g93234_i0 | PRJNA814235 | 94629 | 203 | 2.789157 | 5.66198871 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 50.8 | 2.89e-5 | NR | WP_048108076.1 | 2208 | g93234 | i0 | 96 | 0.369458128078818 | 25 | 1 | 36.9 | 0 | 3 | 77 | 259 | 283 | WP_048108076.1 IS5 family transposase [Methanosarcina barkeri] | diamond | 75 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 29801594 | 29801594 | PRJNA814235_P_NODE_24871_length_383_cov_3.222543_g23501_i0 | PRJNA814235 | 24871 | 383 | 3.222543 | 12.34233969 | Methanofollis formosanus | 299308 | Archaea | Archaea | 52.8 | 2.54e-5 | NR | WP_220681820.1 | 299308 | g23501 | i0 | 61.5 | 1.79373368146214 | 39 | 15 | 30.5 | 0 | 117 | 1 | 51 | 89 | WP_220681820.1 hypothetical protein [Methanofollis formosanus] | diamond | 687 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanofollis | Methanofollis formosanus | |
| 30244112 | 30244112 | PRJNA814235_P_NODE_185652_length_151_cov_3.763158_g184257_i0 | PRJNA814235 | 185652 | 151 | 3.763158 | 5.68236858 | Halalkalicoccus sp. NIPERK | 1973143 | Archaea | Archaea | 57 | 9.9e-8 | NR | WP_286044304.1 | 3053469 | g184257 | i0 | 100 | 0.496688741721854 | 25 | 0 | 49.7 | 0 | 150 | 76 | 755 | 779 | WP_286044304.1 hypothetical protein [Halalkalicoccus sp. NIPERK01] | diamond | 75 | 57 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus sp. NIPERK01 | |
| 30717839 | 30717839 | PRJNA814235_P_NODE_7294_length_694_cov_2.891933_g6293_i0 | PRJNA814235 | 7294 | 694 | 2.891933 | 20.07001502 | Halorussus | 1070314 | Archaea | Archaea | 47.4 | 0.0307 | NR | WP_253520985.1 | 1070314 | g6293 | i0 | 33.9 | 0.510086455331412 | 118 | 53 | 46.7 | 3 | 647 | 324 | 139 | 241 | WP_253520985.1 MULTISPECIES: hypothetical protein [Halorussus] | diamond | 354 | 47.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | ||
| 30749505 | 30749505 | PRJNA814235_P_NODE_16114_length_475_cov_3.107306_g14795_i0 | PRJNA814235 | 16114 | 475 | 3.107306 | 14.7597035 | Methanosarcina thermophila | 2210 | Archaea | Archaea | 140 | 8.429999999999998e-37 | NR | WP_048167731.1 | 2210 | g14795 | i0 | 53.1 | 0.821052631578947 | 130 | 61 | 82.1 | 0 | 391 | 2 | 149 | 278 | WP_048167731.1 radical SAM protein [Methanosarcina thermophila] | diamond | 390 | 140 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina thermophila | |
| 31065706 | 31065706 | PRJNA814235_P_NODE_40875_length_299_cov_2.049618_g39484_i0 | PRJNA814235 | 40875 | 299 | 2.049618 | 6.12835782 | Methanosarcina flavescens | 1715806 | Archaea | Archaea | 68.9 | 4.33e-11 | NR | WP_054298344.1 | 1715806 | g39484 | i0 | 58.6 | 0.581939799331104 | 58 | 23 | 57.2 | 1 | 2 | 172 | 371 | 428 | WP_054298344.1 radical SAM protein [Methanosarcina flavescens] | diamond | 174 | 68.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina flavescens | |
| 31571560 | 31571560 | PRJNA814235_P_NODE_200916_length_150_cov_2.787611_g199521_i0 | PRJNA814235 | 200916 | 150 | 2.787611 | 4.1814165 | Halogeometricum sp. CBA1124 | 2668071 | Archaea | Archaea | 48.1 | 1.33e-4 | NR | WP_191452886.1 | 2668071 | g199521 | i0 | 75.9 | 1.12 | 29 | 7 | 58 | 0 | 87 | 1 | 39 | 67 | WP_191452886.1 FAD-dependent oxidoreductase [Halogeometricum sp. CBA1124] | diamond | 168 | 48.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum sp. CBA1124 | |
| 32244776 | 32244776 | PRJNA814235_P_NODE_192158_length_151_cov_2.824561_g190763_i0 | PRJNA814235 | 192158 | 151 | 2.824561 | 4.26508711 | Archaea | 2157 | Archaea | Archaea | 58.9 | 1.8e-8 | NR | PSP54509.1 | 1919167 | g190763 | i0 | 95.8 | 6.21854304635762 | 24 | 1 | 47.7 | 0 | 78 | 149 | 31 | 54 | PSP54509.1 MAG: LLM class F420-dependent oxidoreductase [Halobacteriales archaeon QS_1_67_19] | diamond | 939 | 58.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QS_1_67_19 |
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);;