contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA640143" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 610018 | 610018 | PRJNA640143_S_NODE_29221_length_161_cov_1.258065_g29011_i0 | PRJNA640143 | 29221 | 161 | 1.258065 | 2.02548465 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 107 | 8.16e-27 | NR | MES2464319.1 | 2033014 | g29011 | i0 | 96.2 | 0.987577639751553 | 53 | 2 | 98.8 | 0 | 159 | 1 | 42 | 94 | MES2464319.1 dienelactone hydrolase family protein [Armatimonadota bacterium] | diamond | 159 | 107 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26986005 | 26986005 | PRJNA640143_S_NODE_31122_length_155_cov_0.991525_g30912_i0 | PRJNA640143 | 31122 | 155 | 0.991525 | 1.53686375 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 85.5 | 9.53e-18 | NR | MES2465196.1 | 2033014 | g30912 | i0 | 86.3 | 0.987096774193548 | 51 | 7 | 98.7 | 0 | 1 | 153 | 470 | 520 | MES2465196.1 methionine--tRNA ligase [Armatimonadota bacterium] | diamond | 153 | 85.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27080981 | 27080981 | PRJNA640143_S_NODE_26282_length_172_cov_1.414815_g26072_i0 | PRJNA640143 | 26282 | 172 | 1.414815 | 2.4334818 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 73.2 | 9.72e-14 | NR | MBC8136268.1 | 2033014 | g26072 | i0 | 57.4 | 3.83720930232558 | 54 | 23 | 94.2 | 0 | 169 | 8 | 178 | 231 | MBC8136268.1 SDR family oxidoreductase [Armatimonadota bacterium] | diamond | 660 | 73.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27112477 | 27112477 | PRJNA640143_S_NODE_17402_length_210_cov_1.578035_g17192_i0 | PRJNA640143 | 17402 | 210 | 1.578035 | 3.3138735 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0237 | NR | MBW3638176.1 | 2033014 | g17192 | i0 | 48.6 | 0.528571428571429 | 37 | 19 | 52.9 | 0 | 100 | 210 | 217 | 253 | MBW3638176.1 PHP domain-containing protein [Armatimonadota bacterium] | diamond | 111 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27649787 | 27649787 | PRJNA640143_S_NODE_31224_length_154_cov_2.051282_g31014_i0 | PRJNA640143 | 31224 | 154 | 2.051282 | 3.15897428 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 40.8 | 0.0323 | NR | HLJ57173.1 | 2739509 | g31014 | i0 | 45.2 | 0.818181818181818 | 42 | 23 | 81.8 | 0 | 137 | 12 | 41 | 82 | HLJ57173.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 126 | 40.8 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 27933861 | 27933861 | PRJNA640143_S_NODE_24065_length_180_cov_1.230769_g23855_i0 | PRJNA640143 | 24065 | 180 | 1.230769 | 2.2153842 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 91.7 | 1.07e-20 | NR | HVK04732.1 | 2933160 | g23855 | i0 | 85 | 1 | 60 | 8 | 100 | 1 | 1 | 180 | 53 | 111 | HVK04732.1 UMP kinase [Armatimonadaceae bacterium] | diamond | 180 | 91.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 27946327 | 27946327 | PRJNA640143_S_NODE_29725_length_159_cov_1.844262_g29515_i0 | PRJNA640143 | 29725 | 159 | 1.844262 | 2.93237658 | Bacteria | 2 | Bacteria | Bacteria | 70.9 | 1.04e-12 | NR | MDQ3813416.1 | 2033014 | g29515 | i0 | 61.2 | 1.84905660377358 | 49 | 19 | 92.5 | 0 | 149 | 3 | 284 | 332 | MDQ3813416.1 tetratricopeptide repeat protein [Armatimonadota bacterium] | diamond | 294 | 70.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28565309 | 28565309 | PRJNA640143_S_NODE_7747_length_304_cov_2.112360_g7537_i0 | PRJNA640143 | 7747 | 304 | 2.11236 | 6.4215744 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 110 | 1.25e-25 | NR | MCL6449576.1 | 2033014 | g7537 | i0 | 56.8 | 0.868421052631579 | 88 | 38 | 86.8 | 0 | 11 | 274 | 336 | 423 | MCL6449576.1 YfhO family protein [Armatimonadota bacterium] | diamond | 264 | 110 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28691842 | 28691842 | PRJNA640143_S_NODE_31747_length_153_cov_1.413793_g31537_i0 | PRJNA640143 | 31747 | 153 | 1.413793 | 2.16310329 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 68.6 | 1.69e-13 | NR | MES2459938.1 | 2033014 | g31537 | i0 | 94.3 | 0.686274509803922 | 35 | 2 | 68.6 | 0 | 17 | 121 | 57 | 91 | MES2459938.1 30S ribosomal protein S15 [Armatimonadota bacterium] | diamond | 105 | 68.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29102175 | 29102175 | PRJNA640143_S_NODE_17068_length_212_cov_1.337143_g16858_i0 | PRJNA640143 | 17068 | 212 | 1.337143 | 2.83474316 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.9 | 0.00589 | NR | MBW3635311.1 | 2033014 | g16858 | i0 | 87.5 | 0.707547169811321 | 24 | 3 | 34 | 0 | 210 | 139 | 143 | 166 | MBW3635311.1 hypothetical protein [Armatimonadota bacterium] | diamond | 150 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30143843 | 30143843 | PRJNA640143_S_NODE_31032_length_155_cov_1.322034_g30822_i0 | PRJNA640143 | 31032 | 155 | 1.322034 | 2.0491527 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 51.6 | 8.05e-6 | NR | HZT42006.1 | 2739509 | g30822 | i0 | 63.9 | 1.93548387096774 | 36 | 13 | 69.7 | 0 | 109 | 2 | 99 | 134 | HZT42006.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 300 | 51.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30302623 | 30302623 | PRJNA640143_S_NODE_27772_length_166_cov_1.410853_g27562_i0 | PRJNA640143 | 27772 | 166 | 1.410853 | 2.34201598 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 97.8 | 3.3e-24 | NR | MBC8104744.1 | 2033014 | g27562 | i0 | 93.6 | 1.69879518072289 | 47 | 3 | 84.9 | 0 | 164 | 24 | 55 | 101 | MBC8104744.1 cytidine/deoxycytidylate deaminase family protein [Armatimonadota bacterium] | diamond | 282 | 97.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31060757 | 31060757 | PRJNA640143_S_NODE_25335_length_175_cov_3.847826_g25125_i0 | PRJNA640143 | 25335 | 175 | 3.847826 | 6.7336955 | Capsulimonadales bacterium | 2971800 | Bacteria | Bacteria | 85.5 | 2.62e-19 | NR | MDX1934163.1 | 2971800 | g25125 | i0 | 69.5 | 2.82857142857143 | 59 | 16 | 97.7 | 1 | 175 | 5 | 81 | 139 | MDX1934163.1 Hsp20/alpha crystallin family protein [Capsulimonadales bacterium] | diamond | 495 | 85.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadales bacterium | ||||
| 31092066 | 31092066 | PRJNA640143_S_NODE_19175_length_200_cov_4.527607_g18965_i0 | PRJNA640143 | 19175 | 200 | 4.527607 | 9.055214 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 60.5 | 8.18e-9 | NR | MBC8102044.1 | 2033014 | g18965 | i0 | 62.1 | 0.87 | 58 | 20 | 85.5 | 2 | 6 | 176 | 213 | 269 | MBC8102044.1 YsnF/AvaK domain-containing protein [Armatimonadota bacterium] | diamond | 174 | 60.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31281632 | 31281632 | PRJNA640143_S_NODE_32895_length_150_cov_1.185841_g32685_i0 | PRJNA640143 | 32895 | 150 | 1.185841 | 1.7787615 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47 | 5.42e-5 | NR | MES2463349.1 | 2033014 | g32685 | i0 | 95.8 | 0.48 | 24 | 1 | 48 | 0 | 77 | 148 | 1 | 24 | MES2463349.1 riboflavin synthase [Armatimonadota bacterium] | diamond | 72 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31692863 | 31692863 | PRJNA640143_S_NODE_32937_length_150_cov_1.035398_g32727_i0 | PRJNA640143 | 32937 | 150 | 1.035398 | 1.553097 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 76.6 | 1.01e-14 | NR | MES2460242.1 | 2033014 | g32727 | i0 | 87.5 | 0.8 | 40 | 5 | 80 | 0 | 31 | 150 | 1 | 40 | MES2460242.1 galactokinase [Armatimonadota bacterium] | diamond | 120 | 76.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31756153 | 31756153 | PRJNA640143_S_NODE_27937_length_165_cov_1.859375_g27727_i0 | PRJNA640143 | 27937 | 165 | 1.859375 | 3.06796875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 60.1 | 4.78e-9 | NR | MES2461252.1 | 2033014 | g27727 | i0 | 80.6 | 0.654545454545455 | 36 | 7 | 65.5 | 0 | 165 | 58 | 178 | 213 | MES2461252.1 SGNH/GDSL hydrolase family protein [Armatimonadota bacterium] | diamond | 108 | 60.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31882581 | 31882581 | PRJNA640143_S_NODE_32577_length_151_cov_1.026316_g32367_i0 | PRJNA640143 | 32577 | 151 | 1.026316 | 1.54973716 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 47.8 | 1.42e-5 | NR | HVK05285.1 | 2933160 | g32367 | i0 | 62.9 | 0.695364238410596 | 35 | 13 | 69.5 | 0 | 110 | 6 | 31 | 65 | HVK05285.1 hypothetical protein [Armatimonadaceae bacterium] | diamond | 105 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 32357574 | 32357574 | PRJNA640143_S_NODE_31099_length_155_cov_0.991525_g30889_i0 | PRJNA640143 | 31099 | 155 | 0.991525 | 1.53686375 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 66.6 | 2.33e-12 | NR | HVK02690.1 | 2933160 | g30889 | i0 | 81.6 | 1.50967741935484 | 38 | 7 | 73.5 | 0 | 155 | 42 | 84 | 121 | HVK02690.1 CbiX/SirB N-terminal domain-containing protein [Armatimonadaceae bacterium] | diamond | 234 | 66.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium |
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);;