contig_metadata
11 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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);;