contig_metadata
10 rows where bioproject = "PRJNA744060", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24949623 | 24949623 | PRJNA744060_P_NODE_22260_length_343_cov_3.174074_g21931_i0 | PRJNA744060 | 22260 | 343 | 3.174074 | 10.88707382 | uncultured Methanoregulaceae archaeon | 1392423 | Archaea | Archaea | 198 | 3.94e-46 | NTclustered | gi|2874254037|emb|OY970361.1| | 1392423 | g21931 | i0 | 85.714 | 46.3119533527697 | 189 | 25 | 55 | 2 | 49 | 236 | 2544725 | 2544912 | MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1 | blastn | 15885 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | uncultured Methanoregulaceae archaeon | ||
| 24949793 | 24949793 | PRJNA744060_P_NODE_31360_length_293_cov_1.418182_g31031_i0 | PRJNA744060 | 31360 | 293 | 1.418182 | 4.15527326 | Haloferax mediterranei | 2252 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|640913992|gb|CP001868.2| | 523841 | g31031 | i0 | 94.444 | 0.368600682593857 | 36 | 1 | 12 | 1 | 47 | 82 | 1848311 | 1848345 | Haloferax mediterranei ATCC 33500, complete genome | blastn | 108 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax mediterranei | |
| 24950063 | 24950063 | PRJNA744060_P_NODE_48340_length_246_cov_1.323699_g48011_i0 | PRJNA744060 | 48340 | 246 | 1.323699 | 3.25629954 | Haloarcula regularis | 3033392 | Archaea | Archaea | 58.4 | 4.78e-4 | NTclustered | gi|2463595545|gb|CP119794.1| | 3033392 | g48011 | i0 | 100 | 0.601626016260163 | 31 | 0 | 13 | 0 | 216 | 246 | 814474 | 814444 | Haloarcula regularis strain SYNS111 chromosome, complete genome | blastn | 148 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 27283984 | 27283984 | PRJNA744060_P_NODE_51343_length_242_cov_0.923077_g51014_i0 | PRJNA744060 | 51343 | 242 | 0.923077 | 2.23384634 | Halobacteriales | 2235 | Archaea | Archaea | 80.9 | 1.37e-15 | NR | WP_263017800.1 | 1679076 | g51014 | i0 | 44.6 | 2.78925619834711 | 74 | 41 | 91.7 | 0 | 4 | 225 | 144 | 217 | WP_263017800.1 beta-mannosidase [Natronobiforma cellulositropha] | diamond | 675 | 80.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobiforma | Natronobiforma cellulositropha | |
| 27811046 | 27811046 | PRJNA744060_P_NODE_46184_length_249_cov_2.159091_g45855_i0 | PRJNA744060 | 46184 | 249 | 2.159091 | 5.37613659 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 122 | 1.38e-30 | NR | RYE85578.1 | 2250255 | g45855 | i0 | 68.3 | 0.987951807228916 | 82 | 26 | 98.8 | 0 | 2 | 247 | 177 | 258 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 246 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28294339 | 28294339 | PRJNA744060_P_NODE_12426_length_455_cov_2.018325_g12098_i0 | PRJNA744060 | 12426 | 455 | 2.018325 | 9.18337875 | Methanosarcina | 2207 | Archaea | Archaea | 76.3 | 2.39e-13 | NR | WP_300098040.1 | 2213 | g12098 | i0 | 41.3 | 4.06153846153846 | 104 | 57 | 67.9 | 3 | 367 | 59 | 173 | 273 | WP_300098040.1 protease inhibitor I42 family protein [Methanosarcina sp.] | diamond | 1848 | 77 | 0.990909090909091 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28979222 | 28979222 | PRJNA744060_P_NODE_43248_length_254_cov_1.767956_g42919_i0 | PRJNA744060 | 43248 | 254 | 1.767956 | 4.49060824 | Methanoregula sp. | 2052170 | Archaea | Archaea | 42.4 | 0.0465 | NR | MCX6686830.1 | 2052170 | g42919 | i0 | 30 | 0.826771653543307 | 70 | 49 | 82.7 | 0 | 13 | 222 | 79 | 148 | MCX6686830.1 DNA double-strand break repair nuclease NurA [Methanoregula sp.] | diamond | 210 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32170971 | 32170971 | PRJNA744060_P_NODE_34718_length_280_cov_1.449275_g34389_i0 | PRJNA744060 | 34718 | 280 | 1.449275 | 4.05797 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 129 | 1.1399999999999999e-32 | NR | RYE85578.1 | 2250255 | g34389 | i0 | 65.5 | 0.9 | 84 | 27 | 87.9 | 1 | 30 | 275 | 19 | 102 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 252 | 129 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 32812309 | 32812309 | PRJNA744060_P_NODE_20600_length_356_cov_2.056537_g20271_i0 | PRJNA744060 | 20600 | 356 | 2.056537 | 7.32127172 | root | 1 | Root_unresolved | Root_unresolved | 67.8 | 2.43e-10 | NR | OPX78749.1 | 1811685 | g20271 | i0 | 41.2 | 6.37078651685393 | 102 | 54 | 85.1 | 4 | 8 | 310 | 1769 | 1865 | OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039] | diamond | 2268 | 68.2 | 0.994134897360704 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaB.Bin039 | |
| 32896681 | 32896681 | PRJNA744060_P_NODE_20260_length_359_cov_1.790210_g19931_i0 | PRJNA744060 | 20260 | 359 | 1.79021 | 6.4268539 | Methanovulcanius yangii | 1789227 | Archaea | Archaea | 46.2 | 0.00879 | NR | MBT8507577.1 | 1789227 | g19931 | i0 | 30.4 | 1.92200557103064 | 115 | 62 | 96.1 | 3 | 348 | 4 | 1357 | 1453 | MBT8507577.1 hypothetical protein [Methanovulcanius yangii] | diamond | 690 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanovulcanius | Methanovulcanius yangii |
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);;