contig_metadata
14 rows where bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2127510 | 2127510 | PRJNA874604_P_NODE_59362_length_267_cov_1.407216_g59010_i0 | PRJNA874604 | 59362 | 267 | 1.407216 | 3.75726672 | Haladaptatus halobius | 2884875 | Archaea | Archaea | 195 | 3.84e-45 | NTclustered | gi|2124335437|gb|CP085336.1| | 2884875 | g59010 | i0 | 80.075 | 8.8689138576779 | 266 | 49 | 99 | 4 | 4 | 267 | 751820 | 752083 | Haladaptatus halobius strain PSR5 chromosome 2, complete sequence | blastn | 2368 | 195 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus halobius | |
| 13991989 | 13991989 | PRJNA874604_P_NODE_62711_length_261_cov_1.569149_g62359_i0 | PRJNA874604 | 62711 | 261 | 1.569149 | 4.09547889 | Methanocaldococcus | 196118 | Archaea | Archaea | 60.2 | 1.42e-4 | NTclustered | gi|103488854|gb|DQ516907.1| | 2190 | g62359 | i0 | 100 | 0.245210727969349 | 32 | 0 | 12 | 0 | 230 | 261 | 69 | 38 | Methanocaldococcus jannaschii spike-in control MJ-8000-191 genomic sequence | blastn | 64 | 60.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus jannaschii | |
| 26706757 | 26706757 | PRJNA874604_P_NODE_80521_length_247_cov_0.885057_g80169_i0 | PRJNA874604 | 80521 | 247 | 0.885057 | 2.18609079 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 41.2 | 0.0276 | NR | MCK5109419.1 | 2250255 | g80169 | i0 | 36.4 | 0.534412955465587 | 44 | 28 | 53.4 | 0 | 66 | 197 | 17 | 60 | MCK5109419.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 132 | 41.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27505873 | 27505873 | PRJNA874604_P_NODE_81083_length_247_cov_0.885057_g80731_i0 | PRJNA874604 | 81083 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0363 | NR | MBR3156603.1 | 66852 | g80731 | i0 | 36 | 2.36842105263158 | 75 | 38 | 91.1 | 2 | 233 | 9 | 156 | 220 | MBR3156603.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 585 | 43.1 | 0.990719257540603 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28129194 | 28129194 | PRJNA874604_P_NODE_75145_length_249_cov_0.875000_g74793_i0 | PRJNA874604 | 75145 | 249 | 0.875 | 2.17875 | Methanospirillum sp. | 45200 | Archaea | Archaea | 45.1 | 0.00522 | NR | HWQ67247.1 | 45200 | g74793 | i0 | 50.8 | 0.710843373493976 | 59 | 20 | 68.7 | 2 | 242 | 72 | 184 | 235 | HWQ67247.1 hypothetical protein [Methanospirillum sp.] | diamond | 177 | 45.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 28191983 | 28191983 | PRJNA874604_P_NODE_55946_length_273_cov_1.540000_g55594_i0 | PRJNA874604 | 55946 | 273 | 1.54 | 4.2042 | Natrinema ejinorense | 373386 | Archaea | Archaea | 43.1 | 0.039 | NR | WP_097379368.1 | 373386 | g55594 | i0 | 38.3 | 0.659340659340659 | 60 | 37 | 65.9 | 0 | 226 | 47 | 93 | 152 | WP_097379368.1 amino acid permease [Natrinema ejinorense] | diamond | 180 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema ejinorense | |
| 29612705 | 29612705 | PRJNA874604_P_NODE_60150_length_266_cov_1.020725_g59798_i0 | PRJNA874604 | 60150 | 266 | 1.020725 | 2.7151285 | Halovenus sp. | 1954478 | Archaea | Archaea | 72.4 | 1.68e-12 | NR | MFT4944476.1 | 1954478 | g59798 | i0 | 41.9 | 1.66917293233083 | 74 | 42 | 82.3 | 1 | 259 | 41 | 109 | 182 | MFT4944476.1 diacylglycerol O-acyltransferase [Halovenus sp.] | diamond | 444 | 72.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halovenus | Halovenus sp. | |
| 30497639 | 30497639 | PRJNA874604_P_NODE_48453_length_287_cov_1.439252_g48101_i0 | PRJNA874604 | 48453 | 287 | 1.439252 | 4.13065324 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 58.2 | 1.04e-7 | NR | MBR95856.1 | 2026739 | g48101 | i0 | 44.6 | 1.60975609756098 | 74 | 36 | 76.3 | 3 | 274 | 56 | 2 | 71 | MBR95856.1 thiopurine S-methyltransferase [Methanobacteriota archaeon] | diamond | 462 | 58.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30592272 | 30592272 | PRJNA874604_P_NODE_97133_length_242_cov_0.911243_g96781_i0 | PRJNA874604 | 97133 | 242 | 0.911243 | 2.20520806 | Methanosarcina sp. | 2213 | Archaea | Archaea | 49.3 | 1.82e-5 | NR | HET8687115.1 | 2213 | g96781 | i0 | 42.5 | 0.495867768595041 | 40 | 21 | 49.6 | 1 | 239 | 120 | 32 | 69 | HET8687115.1 hypothetical protein [Methanosarcina sp.] | diamond | 120 | 49.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30623773 | 30623773 | PRJNA874604_P_NODE_81173_length_247_cov_0.885057_g80821_i0 | PRJNA874604 | 81173 | 247 | 0.885057 | 2.18609079 | Haloplanus sp. XH21 | 2934938 | Archaea | Archaea | 41.2 | 0.0339 | NR | WP_345779736.1 | 2934938 | g80821 | i0 | 41.3 | 0.910931174089069 | 75 | 40 | 87.4 | 2 | 216 | 1 | 2 | 75 | WP_345779736.1 heavy-metal-associated domain-containing protein [Haloplanus sp. XH21] | diamond | 225 | 41.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus halobius | |
| 30916544 | 30916544 | PRJNA874604_P_NODE_88854_length_245_cov_0.860465_g88502_i0 | PRJNA874604 | 88854 | 245 | 0.860465 | 2.10813925 | Methanocaldococcaceae | 196117 | Archaea | Archaea | 43.1 | 0.0267 | NR | WP_013799082.1 | 2189 | g88502 | i0 | 30.7 | 1.62857142857143 | 75 | 51 | 90.6 | 1 | 245 | 24 | 238 | 312 | WP_013799082.1 mechanosensitive ion channel family protein [Methanotorris igneus] | diamond | 399 | 43.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanotorris | Methanotorris igneus | |
| 31192287 | 31192287 | PRJNA874604_P_NODE_87035_length_245_cov_0.895349_g86683_i0 | PRJNA874604 | 87035 | 245 | 0.895349 | 2.19360505 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 65.1 | 5.08e-10 | NR | HNJ81026.1 | 2485498 | g86683 | i0 | 45.8 | 0.722448979591837 | 59 | 30 | 72.2 | 1 | 69 | 245 | 603 | 659 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 177 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 31414100 | 31414100 | PRJNA874604_P_NODE_79636_length_248_cov_0.880000_g79284_i0 | PRJNA874604 | 79636 | 248 | 0.88 | 2.1824 | Methanoregula sp. | 2052170 | Archaea | Archaea | 50.1 | 1.06e-4 | NR | WP_373007287.1 | 2052170 | g79284 | i0 | 43.3 | 0.810483870967742 | 67 | 28 | 78.6 | 3 | 46 | 240 | 126 | 184 | WP_373007287.1 TIGR03768 family metallophosphoesterase [Methanoregula sp.] | diamond | 201 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 32616028 | 32616028 | PRJNA874604_P_NODE_87800_length_245_cov_0.895349_g87448_i0 | PRJNA874604 | 87800 | 245 | 0.895349 | 2.19360505 | Haloarcula saliterrae | 2950534 | Archaea | Archaea | 64.3 | 9.32e-10 | NR | WP_310921739.1 | 2950534 | g87448 | i0 | 43.2 | 0.906122448979592 | 74 | 40 | 90.6 | 1 | 229 | 8 | 120 | 191 | WP_310921739.1 type I restriction-modification system subunit M [Haloarcula saliterrae] | diamond | 222 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula saliterrae |
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);;