contig_metadata
7 rows where bioproject = "PRJNA966993", tax_clade = "Stenosarchaea group" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12421074 | 12421074 | PRJNA966993_P_NODE_22290_length_445_cov_1.685484_g21843_i0 | PRJNA966993 | 22290 | 445 | 1.685484 | 7.5004038 | Halorutilales archaeon Cl-col2-1 | 3242703 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2801083086|gb|CP169074.1| | 3242703 | g21843 | i0 | 100 | 0.0651685393258427 | 29 | 0 | 7 | 0 | 2 | 30 | 912412 | 912384 | Halorutilales archaeon Cl-col2-1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halorutilales | Halorutilales archaeon Cl-col2-1 | |||
| 12421417 | 12421417 | PRJNA966993_P_NODE_60150_length_284_cov_2.919431_g59698_i0 | PRJNA966993 | 60150 | 284 | 2.919431 | 8.29118404 | Halomarina rubra | 2071873 | Archaea | Archaea | 96.7 | 1.18e-21 | NR | WP_250873790.1 | 2071873 | g59698 | i0 | 50 | 0.992957746478873 | 94 | 46 | 99.3 | 1 | 282 | 1 | 23 | 115 | WP_250873790.1 oxidoreductase [Halomarina rubra] | diamond | 282 | 96.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina rubra | |
| 13695817 | 13695817 | PRJNA966993_P_NODE_4411_length_979_cov_2.591611_g4103_i0 | PRJNA966993 | 4411 | 979 | 2.591611 | 25.37187169 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 627 | 5.91e-225 | NR | RYE83110.1 | 2250255 | g4103 | i0 | 94.5 | 0.995914198161389 | 325 | 18 | 99.6 | 0 | 977 | 3 | 55 | 379 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 975 | 627 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 23894984 | 23894984 | PRJNA966993_P_NODE_76439_length_260_cov_1.647059_g75987_i0 | PRJNA966993 | 76439 | 260 | 1.647059 | 4.2823534 | Salinibaculum marinum | 3131993 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2700494403|gb|CP147838.1| | 3131993 | g75987 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 41 | 69 | 145888 | 145916 | Salinibaculum marinum strain SYNS191 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum marinum | |
| 27752620 | 27752620 | PRJNA966993_P_NODE_24904_length_422_cov_1.656160_g24457_i0 | PRJNA966993 | 24904 | 422 | 1.65616 | 6.9889952 | Methanoregula sp. | 2052170 | Archaea | Archaea | 57.8 | 1.33e-6 | NR | HZK31245.1 | 2052170 | g24457 | i0 | 29.2 | 3.69668246445498 | 130 | 88 | 91 | 2 | 39 | 422 | 15 | 142 | HZK31245.1 AMP-binding protein [Methanoregula sp.] | diamond | 1560 | 57.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 28320767 | 28320767 | PRJNA966993_P_NODE_70366_length_269_cov_4.846939_g69914_i0 | PRJNA966993 | 70366 | 269 | 4.846939 | 13.03826591 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 52.4 | 4.93e-6 | NR | MEI7649696.1 | 2184052 | g69914 | i0 | 51 | 1.66171003717472 | 49 | 21 | 54.6 | 1 | 118 | 264 | 8 | 53 | MEI7649696.1 ester cyclase [Methanomicrobiales archaeon] | diamond | 447 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 30626023 | 30626023 | PRJNA966993_P_NODE_30933_length_382_cov_1.495146_g30481_i0 | PRJNA966993 | 30933 | 382 | 1.495146 | 5.71145772 | Methanoregula sp. | 2052170 | Archaea | Archaea | 67.8 | 3.12e-10 | NR | WP_373007287.1 | 2052170 | g30481 | i0 | 38 | 0.950261780104712 | 121 | 51 | 82.5 | 5 | 338 | 24 | 126 | 238 | WP_373007287.1 TIGR03768 family metallophosphoesterase [Methanoregula sp.] | diamond | 363 | 67.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. |
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);;