contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9057074 | 9057074 | PRJEB64798_P_NODE_92648_length_212_cov_5.269939_g90882_i0 | PRJEB64798 | 92648 | 212 | 5.269939 | 11.17227068 | Pseudomonadota | 1224 | Bacteria | Bacteria | 68.6 | 1.66e-11 | NR | OPL08758.1 | 1775671 | g90882 | i0 | 60 | 16.5 | 60 | 20 | 84.9 | 1 | 33 | 212 | 206 | 261 | OPL08758.1 MAG: 3-isopropylmalate dehydrogenase [delta proteobacterium ML8_F1] | diamond | 3498 | 68.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | delta proteobacterium ML8_F1 | ||||||
| 26773723 | 26773723 | PRJEB64798_P_NODE_77661_length_218_cov_7.035503_g75895_i0 | PRJEB64798 | 77661 | 218 | 7.035503 | 15.33739654 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 84 | 3.29e-17 | NR | PKN06070.1 | 2013757 | g75895 | i0 | 65.2 | 11.5183486238532 | 69 | 23 | 95 | 1 | 7 | 213 | 41 | 108 | PKN06070.1 MAG: glutamine synthetase type III, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7] | diamond | 2511 | 84 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7 | ||||||
| 27697600 | 27697600 | PRJEB64798_P_NODE_211744_length_164_cov_3.634783_g209978_i0 | PRJEB64798 | 211744 | 164 | 3.634783 | 5.96104412 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 46.6 | 5.35e-5 | NR | ADI18017.1 | 710831 | g209978 | i0 | 82.1 | 0.51219512195122 | 28 | 5 | 51.2 | 0 | 97 | 14 | 41 | 68 | ADI18017.1 hypothetical protein [uncultured delta proteobacterium HF0200_19J16] | diamond | 84 | 46.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0200_19J16 | ||||||
| 28296911 | 28296911 | PRJEB64798_P_NODE_131486_length_197_cov_18.864865_g129720_i0 | PRJEB64798 | 131486 | 197 | 18.864865000000002 | 37.16378405 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 63.9 | 1.22e-10 | NR | MCH2285384.1 | 2024889 | g129720 | i0 | 82.4 | 0.517766497461929 | 34 | 6 | 51.8 | 0 | 107 | 6 | 16 | 49 | MCH2285384.1 peptide-methionine (S)-S-oxide reductase MsrA [SAR324 cluster bacterium] | diamond | 102 | 63.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28423682 | 28423682 | PRJEB64798_P_NODE_97726_length_212_cov_3.588957_g95960_i0 | PRJEB64798 | 97726 | 212 | 3.588957 | 7.60858884 | Deltaproteobacteria bacterium GWA2_38_16 | 1797802 | Bacteria | Bacteria | 55.8 | 5.53e-7 | NR | OGP06050.1 | 1797802 | g95960 | i0 | 71.9 | 2.40566037735849 | 32 | 9 | 45.3 | 0 | 113 | 208 | 5 | 36 | OGP06050.1 MAG: hypothetical protein A2Z91_05665 [Deltaproteobacteria bacterium GWA2_38_16] | diamond | 510 | 55.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWA2_38_16 | ||||||
| 28676162 | 28676162 | PRJEB64798_P_NODE_238007_length_156_cov_2.373832_g236241_i0 | PRJEB64798 | 238007 | 156 | 2.373832 | 3.70317792 | Deltaproteobacteria bacterium DG_8 | 1703397 | Bacteria | Bacteria | 42.7 | 0.0111 | NR | KPJ58876.1 | 1703397 | g236241 | i0 | 45.8 | 0.923076923076923 | 48 | 26 | 92.3 | 0 | 152 | 9 | 137 | 184 | KPJ58876.1 MAG: hypothetical protein AMJ42_02475 [Deltaproteobacteria bacterium DG_8] | diamond | 144 | 42.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium DG_8 | ||||||
| 28865369 | 28865369 | PRJEB64798_P_NODE_187728_length_171_cov_3.918033_g185962_i0 | PRJEB64798 | 187728 | 171 | 3.918033 | 6.69983643 | Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12 | 1797850 | Bacteria | Bacteria | 68.2 | 9.43e-12 | NR | OGQ01437.1 | 1797850 | g185962 | i0 | 61.1 | 1.91228070175439 | 54 | 21 | 94.7 | 0 | 166 | 5 | 151 | 204 | OGQ01437.1 MAG: hypothetical protein A2026_09115 [Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12] | diamond | 327 | 68.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12 | ||||||
| 30033892 | 30033892 | PRJEB64798_P_NODE_230851_length_158_cov_6.027523_g229085_i0 | PRJEB64798 | 230851 | 158 | 6.027523 | 9.52348634 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 54.3 | 9.65e-7 | NR | MDX2470893.1 | 2024889 | g229085 | i0 | 75 | 1.87974683544304 | 32 | 8 | 60.8 | 0 | 98 | 3 | 157 | 188 | MDX2470893.1 NTP transferase domain-containing protein [SAR324 cluster bacterium] | diamond | 297 | 54.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 30539320 | 30539320 | PRJEB64798_P_NODE_242093_length_154_cov_6.400000_g240327_i0 | PRJEB64798 | 242093 | 154 | 6.4 | 9.856 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 44.3 | 7.96e-4 | NR | ADI16622.1 | 710820 | g240327 | i0 | 56.4 | 0.75974025974026 | 39 | 17 | 76 | 0 | 123 | 7 | 44 | 82 | ADI16622.1 hypothetical protein [uncultured delta proteobacterium HF0010_01J10] | diamond | 117 | 44.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 30627029 | 30627029 | PRJEB64798_P_NODE_220473_length_162_cov_1.946903_g218707_i0 | PRJEB64798 | 220473 | 162 | 1.946903 | 3.15398286 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 3.01e-4 | NR | OGQ89419.1 | 1797895 | g218707 | i0 | 40.4 | 2.87037037037037 | 52 | 28 | 96.3 | 2 | 7 | 162 | 1203 | 1251 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 465 | 47.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 31006272 | 31006272 | PRJEB64798_P_NODE_156734_length_185_cov_2.588235_g154968_i0 | PRJEB64798 | 156734 | 185 | 2.588235 | 4.78823475 | Pseudomonadota | 1224 | Bacteria | Bacteria | 50.8 | 2.42e-5 | NR | OGR07127.1 | 1797902 | g154968 | i0 | 37.3 | 6.76216216216216 | 59 | 37 | 95.7 | 0 | 185 | 9 | 531 | 589 | OGR07127.1 MAG: hypothetical protein A2511_11255 [Deltaproteobacteria bacterium RIFOXYD12_FULL_50_9] | diamond | 1251 | 50.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYD12_FULL_50_9 | ||||||
| 31076490 | 31076490 | PRJEB64798_P_NODE_157875_length_184_cov_7.162963_g156109_i0 | PRJEB64798 | 157875 | 184 | 7.162963 | 13.17985192 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 41.6 | 0.0427 | NR | PKN57799.1 | 2013741 | g156109 | i0 | 42.1 | 0.929347826086957 | 57 | 31 | 89.7 | 1 | 14 | 178 | 152 | 208 | PKN57799.1 MAG: di-trans,poly-cis-decaprenylcistransferase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 171 | 41.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 31076499 | 31076499 | PRJEB64798_P_NODE_163875_length_181_cov_10.242424_g162109_i0 | PRJEB64798 | 163875 | 181 | 10.242424 | 18.53878744 | Deltaproteobacteria bacterium RBG_16_48_1 | 2026735 | Bacteria | Bacteria | 51.2 | 8.38e-6 | NR | OGP89063.1 | 1797839 | g162109 | i0 | 44.6 | 0.92817679558011 | 56 | 30 | 91.2 | 1 | 16 | 180 | 42 | 97 | OGP89063.1 MAG: hypothetical protein A2156_12750 [Deltaproteobacteria bacterium RBG_16_48_10] | diamond | 168 | 51.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_16_48_10 | ||||||
| 31132418 | 31132418 | PRJEB64798_P_NODE_85575_length_213_cov_3.140244_g83809_i0 | PRJEB64798 | 85575 | 213 | 3.140244 | 6.68871972 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 1.11e-13 | NR | OGP63352.1 | 1797831 | g83809 | i0 | 93.9 | 12.1830985915493 | 33 | 2 | 46.5 | 0 | 209 | 111 | 108 | 140 | OGP63352.1 MAG: S-adenosylmethionine-binding protein [Deltaproteobacteria bacterium RBG_13_53_10] | diamond | 2595 | 73.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_53_10 | ||||||
| 31354075 | 31354075 | PRJEB64798_P_NODE_164836_length_181_cov_3.204545_g163070_i0 | PRJEB64798 | 164836 | 181 | 3.204545 | 5.80022645 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.00791 | NR | ADI17622.1 | 710828 | g163070 | i0 | 41.8 | 2.20441988950276 | 55 | 17 | 66.3 | 1 | 170 | 51 | 104 | 158 | ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] | diamond | 399 | 43.5 | 0.990804597701149 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0130_19C20 | ||||||
| 31961931 | 31961931 | PRJEB64798_P_NODE_237478_length_156_cov_3.224299_g235712_i0 | PRJEB64798 | 237478 | 156 | 3.224299 | 5.02990644 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 40 | 0.0236 | NR | MCH2300911.1 | 2024889 | g235712 | i0 | 42.2 | 0.865384615384615 | 45 | 26 | 86.5 | 0 | 22 | 156 | 29 | 73 | MCH2300911.1 glutathione S-transferase family protein [SAR324 cluster bacterium] | diamond | 135 | 40 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 31962031 | 31962031 | PRJEB64798_P_NODE_93178_length_212_cov_5.024540_g91412_i0 | PRJEB64798 | 93178 | 212 | 5.02454 | 10.6520248 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 45.1 | 0.00355 | NR | MFA5623885.1 | 2099667 | g91412 | i0 | 37.8 | 1.16037735849057 | 82 | 25 | 79.2 | 1 | 14 | 181 | 6 | 87 | MFA5623885.1 methyltransferase domain-containing protein [Bradymonadales bacterium] | diamond | 246 | 45.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 32183450 | 32183450 | PRJEB64798_P_NODE_129918_length_198_cov_5.395973_g128152_i0 | PRJEB64798 | 129918 | 198 | 5.395973 | 10.68402654 | uncultured delta proteobacterium HF4 | 34034 | Bacteria | Bacteria | 76.6 | 1.4e-15 | NR | ADI18416.1 | 710836 | g128152 | i0 | 67.3 | 0.833333333333333 | 55 | 17 | 81.8 | 1 | 29 | 190 | 28 | 82 | ADI18416.1 hypothetical protein [uncultured delta proteobacterium HF4000_08N17] | diamond | 165 | 76.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF4000_08N17 | ||||||
| 32215190 | 32215190 | PRJEB64798_P_NODE_226598_length_160_cov_3.216216_g224832_i0 | PRJEB64798 | 226598 | 160 | 3.216216 | 5.1459456 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 65.5 | 1.11e-10 | NR | MBS7381833.1 | 2099667 | g224832 | i0 | 58 | 0.9375 | 50 | 21 | 93.8 | 0 | 158 | 9 | 374 | 423 | MBS7381833.1 TonB family protein [Bradymonadales bacterium] | diamond | 150 | 65.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 32808092 | 32808092 | PRJEB64798_P_NODE_214260_length_163_cov_15.271930_g212494_i0 | PRJEB64798 | 214260 | 163 | 15.27193 | 24.8932459 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 1.25e-6 | NR | MDX2469788.1 | 2024889 | g212494 | i0 | 43.1 | 1.73006134969325 | 51 | 29 | 93.9 | 0 | 159 | 7 | 188 | 238 | MDX2469788.1 lipase family protein [SAR324 cluster bacterium] | diamond | 282 | 54.3 | 0.992633517495396 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 32877868 | 32877868 | PRJEB64798_P_NODE_114220_length_209_cov_4.531250_g112454_i0 | PRJEB64798 | 114220 | 209 | 4.53125 | 9.4703125 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 46.6 | 0.00103 | NR | TVQ80660.1 | 2099667 | g112454 | i0 | 68.8 | 1.9377990430622 | 32 | 10 | 45.9 | 0 | 205 | 110 | 217 | 248 | TVQ80660.1 MAG: UDP-glucose/GDP-mannose dehydrogenase family protein [Bradymonadales bacterium] | diamond | 405 | 46.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales 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);;