contig_metadata
9 rows where bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4466003 | 4466003 | PRJNA670521_P_NODE_21184_length_412_cov_0.820059_g20441_i0 | PRJNA670521 | 21184 | 412 | 0.820059 | 3.37864308 | Halobaculum roseum | 2175149 | Archaea | Archaea | 52.8 | 0.04 | NTclustered | gi|2090005450|gb|CP082286.1| | 2175149 | g20441 | i0 | 96.875 | 0.0776699029126214 | 32 | 0 | 8 | 1 | 102 | 133 | 2558217 | 2558187 | Halobaculum roseum strain CGMCC 1.15501 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum roseum | |
| 9566653 | 9566653 | PRJNA670521_P_NODE_28768_length_366_cov_1.245734_g28023_i0 | PRJNA670521 | 28768 | 366 | 1.245734 | 4.55938644 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 189 | 2.02e-58 | NR | RYE84306.1 | 2250255 | g28023 | i0 | 73.6 | 0.991803278688525 | 121 | 32 | 99.2 | 0 | 2 | 364 | 70 | 190 | RYE84306.1 MAG: 50S ribosomal protein L3 [Methanosarcinales archaeon] | diamond | 363 | 189 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 18490666 | 18490666 | PRJNA670521_P_NODE_68715_length_254_cov_1.154696_g67970_i0 | PRJNA670521 | 68715 | 254 | 1.154696 | 2.93292784 | Haloferax larsenii | 302484 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2288350906|gb|CP078063.1| | 302484 | g67970 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 73 | 100 | 143192 | 143165 | Haloferax larsenii strain NCIM 5678 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax larsenii | |
| 21040815 | 21040815 | PRJNA670521_P_NODE_73737_length_250_cov_0.870056_g72992_i0 | PRJNA670521 | 73737 | 250 | 0.870056 | 2.17514 | Methanosarcina lacustris | 170861 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|805377189|gb|CP009515.1| | 1434111 | g72992 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 29 | 56 | 781978 | 782005 | Methanosarcina lacustris Z-7289, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina lacustris | |
| 26828680 | 26828680 | PRJNA670521_P_NODE_69021_length_253_cov_1.283333_g68276_i0 | PRJNA670521 | 69021 | 253 | 1.283333 | 3.24683249 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 104 | 1.45e-24 | NR | RYE85249.1 | 2250255 | g68276 | i0 | 56.6 | 0.984189723320158 | 83 | 36 | 98.4 | 0 | 253 | 5 | 3 | 85 | RYE85249.1 MAG: hypothetical protein EOO65_00785 [Methanosarcinales archaeon] | diamond | 249 | 104 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 26986637 | 26986637 | PRJNA670521_P_NODE_47542_length_302_cov_1.344978_g46797_i0 | PRJNA670521 | 47542 | 302 | 1.344978 | 4.06183356 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 121 | 6.72e-31 | NR | RYE82365.1 | 2250255 | g46797 | i0 | 58 | 0.993377483443709 | 100 | 42 | 99.3 | 0 | 2 | 301 | 152 | 251 | RYE82365.1 MAG: fatty acid desaturase, partial [Methanosarcinales archaeon] | diamond | 300 | 121 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 29102863 | 29102863 | PRJNA670521_P_NODE_12088_length_519_cov_2.500000_g11353_i0 | PRJNA670521 | 12088 | 519 | 2.5 | 12.975 | Halorubellus sp. PRR65 | 3098148 | Archaea | Archaea | 46.2 | 0.0311 | NR | WP_323675499.1 | 3098148 | g11353 | i0 | 35 | 0.578034682080925 | 100 | 54 | 57.2 | 4 | 24 | 320 | 607 | 696 | WP_323675499.1 S8 family serine peptidase [Halorubellus sp. PRR65] | diamond | 300 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Halorubellus | Halorubellus sp. PRR65 | |
| 31314008 | 31314008 | PRJNA670521_P_NODE_66155_length_259_cov_1.645161_g65410_i0 | PRJNA670521 | 66155 | 259 | 1.645161 | 4.26096699 | Methanolacinia paynteri | 230356 | Archaea | Archaea | 79.7 | 3.84e-15 | NR | WP_052418800.1 | 230356 | g65410 | i0 | 51.8 | 2.82625482625483 | 83 | 39 | 96.1 | 1 | 250 | 2 | 48 | 129 | WP_052418800.1 lamin tail domain-containing protein [Methanolacinia paynteri] | diamond | 732 | 79.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanolacinia | Methanolacinia paynteri | |
| 31535672 | 31535672 | PRJNA670521_P_NODE_66696_length_258_cov_1.443243_g65951_i0 | PRJNA670521 | 66696 | 258 | 1.443243 | 3.72356694 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 64.7 | 7.35e-10 | NR | RYE85335.1 | 2250255 | g65951 | i0 | 53.6 | 0.651162790697674 | 56 | 26 | 65.1 | 0 | 29 | 196 | 270 | 325 | RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon] | diamond | 168 | 64.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales 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);;