contig_metadata
9 rows where bioproject = "PRJNA312107" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9305620 | 9305620 | PRJNA312107_P_NODE_19608_length_168_cov_0.873950_g19442_i0 | PRJNA312107 | 19608 | 168 | 0.87395 | 1.468236 | Natrinema versiforme | 88724 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|1657691899|gb|CP040330.1| | 88724 | g19442 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 119 | 146 | 2253550 | 2253523 | Natrinema versiforme strain BOL5-4 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema versiforme | |
| 27010882 | 27010882 | PRJNA312107_P_NODE_18542_length_169_cov_1.300000_g18376_i0 | PRJNA312107 | 18542 | 169 | 1.3 | 2.197 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 74.3 | 3.25e-14 | NR | MAF88893.1 | 2026739 | g18376 | i0 | 58.2 | 0.976331360946746 | 55 | 23 | 97.6 | 0 | 1 | 165 | 17 | 71 | MAF88893.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 165 | 74.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27453705 | 27453705 | PRJNA312107_P_NODE_22143_length_166_cov_0.888889_g21977_i0 | PRJNA312107 | 22143 | 166 | 0.888889 | 1.47555574 | Methanosarcina sp. | 2213 | Archaea | Archaea | 53.9 | 1.35e-6 | NR | HET8685954.1 | 2213 | g21977 | i0 | 80 | 1.08433734939759 | 30 | 6 | 54.2 | 0 | 6 | 95 | 279 | 308 | HET8685954.1 Mu-like prophage major head subunit gpT family protein [Methanosarcina sp.] | diamond | 180 | 53.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28337577 | 28337577 | PRJNA312107_P_NODE_17866_length_172_cov_1.691057_g17700_i0 | PRJNA312107 | 17866 | 172 | 1.691057 | 2.90861804 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 42.7 | 0.0138 | NR | HEV2429800.1 | 1906666 | g17700 | i0 | 43.2 | 0.645348837209302 | 37 | 21 | 64.5 | 0 | 167 | 57 | 43 | 79 | HEV2429800.1 DNA methyltransferase [Thermoplasmata archaeon] | diamond | 111 | 42.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28495564 | 28495564 | PRJNA312107_P_NODE_24367_length_163_cov_1.570175_g24201_i0 | PRJNA312107 | 24367 | 163 | 1.570175 | 2.55938525 | Methanosarcina sp. | 2213 | Archaea | Archaea | 67 | 3.33e-11 | NR | HET8685110.1 | 2213 | g24201 | i0 | 75 | 1.91411042944785 | 52 | 13 | 95.7 | 0 | 161 | 6 | 345 | 396 | HET8685110.1 hypothetical protein [Methanosarcina sp.] | diamond | 312 | 67 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29821268 | 29821268 | PRJNA312107_P_NODE_14671_length_191_cov_0.760563_g14505_i0 | PRJNA312107 | 14671 | 191 | 0.760563 | 1.45267533 | Haloarchaeobius amylolyticus | 1198296 | Archaea | Archaea | 42.7 | 0.0186 | NR | WP_267639183.1 | 1198296 | g14505 | i0 | 54.1 | 0.581151832460733 | 37 | 17 | 58.1 | 0 | 7 | 117 | 342 | 378 | WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus] | diamond | 111 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius amylolyticus | |
| 31654322 | 31654322 | PRJNA312107_P_NODE_24657_length_163_cov_0.912281_g24491_i0 | PRJNA312107 | 24657 | 163 | 0.912281 | 1.48701803 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 75.1 | 4.84e-14 | NR | MEA3198869.1 | 1906666 | g24491 | i0 | 64.2 | 0.975460122699387 | 53 | 19 | 97.5 | 0 | 4 | 162 | 272 | 324 | MEA3198869.1 inorganic phosphate transporter, PiT family [Thermoplasmata archaeon] | diamond | 159 | 75.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32477268 | 32477268 | PRJNA312107_P_NODE_5619_length_299_cov_1.060000_g5453_i0 | PRJNA312107 | 5619 | 299 | 1.06 | 3.1694 | Halobacterium hubeiense | 1407499 | Archaea | Archaea | 43.1 | 0.0458 | NR | WP_143416443.1 | 1407499 | g5453 | i0 | 30.4 | 0.692307692307692 | 69 | 46 | 67.2 | 1 | 18 | 218 | 112 | 180 | WP_143416443.1 hypothetical protein [Halobacterium hubeiense] | diamond | 207 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium hubeiense | |
| 32823925 | 32823925 | PRJNA312107_P_NODE_20900_length_167_cov_0.881356_g20734_i0 | PRJNA312107 | 20900 | 167 | 0.881356 | 1.47186452 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 47 | 4.26e-4 | NR | NDB94291.1 | 2026739 | g20734 | i0 | 44.7 | 1.76047904191617 | 47 | 26 | 84.4 | 0 | 164 | 24 | 380 | 426 | NDB94291.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 294 | 47 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota 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);;