contig_metadata
15 rows where bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 8291512 | 8291512 | PRJNA670521_P_NODE_71347_length_251_cov_0.865169_g70602_i0 | PRJNA670521 | 71347 | 251 | 0.865169 | 2.17157419 | Methanothermococcus okinawensis | 155863 | Archaea | Archaea | 58.4 | 4.89e-4 | NTclustered | gi|334855522|gb|CP002792.1| | 647113 | g70602 | i0 | 97.143 | 0.48605577689243 | 35 | 0 | 14 | 1 | 80 | 114 | 1187252 | 1187285 | Methanothermococcus okinawensis IH1, complete genome | blastn | 122 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanothermococcus | Methanothermococcus okinawensis | |
| 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 | |
| 29418363 | 29418363 | PRJNA670521_P_NODE_57629_length_278_cov_1.502439_g56884_i0 | PRJNA670521 | 57629 | 278 | 1.502439 | 4.17678042 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 95.5 | 1.56e-20 | NR | MCU0798095.1 | 2806419 | g56884 | i0 | 54 | 0.938848920863309 | 87 | 39 | 93.9 | 1 | 15 | 275 | 483 | 568 | MCU0798095.1 glycine--tRNA ligase [Thermoplasmatota archaeon] | diamond | 261 | 95.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29430236 | 29430236 | PRJNA670521_P_NODE_52129_length_291_cov_0.857798_g51384_i0 | PRJNA670521 | 52129 | 291 | 0.857798 | 2.49619218 | Archaea | 2157 | Archaea | Archaea | 43.9 | 0.0237 | NR | MEA1998891.1 | 2026739 | g51384 | i0 | 34.6 | 2.50515463917526 | 81 | 44 | 75.3 | 4 | 38 | 256 | 261 | 340 | MEA1998891.1 aminoacyl--tRNA ligase-related protein [Methanobacteriota archaeon] | diamond | 729 | 43.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29745931 | 29745931 | PRJNA670521_P_NODE_26510_length_377_cov_2.256579_g25766_i0 | PRJNA670521 | 26510 | 377 | 2.256579 | 8.50730283 | Methanobacteriati | 3366610 | Archaea | Archaea | 45.4 | 0.0191 | NR | NCG00352.1 | 2026739 | g25766 | i0 | 29.5 | 2.83289124668435 | 95 | 58 | 71.6 | 2 | 324 | 55 | 1135 | 1225 | NCG00352.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 1068 | 45.8 | 0.991266375545852 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30113163 | 30113163 | PRJNA670521_P_NODE_18552_length_435_cov_1.237569_g17810_i0 | PRJNA670521 | 18552 | 435 | 1.237569 | 5.38342515 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 185 | 1.36e-54 | NR | MEE3325635.1 | 2666342 | g17810 | i0 | 63.7 | 1.00689655172414 | 146 | 50 | 98.6 | 1 | 431 | 3 | 84 | 229 | MEE3325635.1 C13 family peptidase [Methanosphaera sp.] | diamond | 438 | 185 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 30998050 | 30998050 | PRJNA670521_P_NODE_38514_length_328_cov_1.686275_g37769_i0 | PRJNA670521 | 38514 | 328 | 1.686275 | 5.530982 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.8 | 0.00817 | NR | HIH97985.1 | 1906666 | g37769 | i0 | 37 | 0.841463414634146 | 92 | 52 | 83.2 | 3 | 273 | 1 | 178 | 264 | HIH97985.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Thermoplasmata archaeon] | diamond | 276 | 45.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 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);;