contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26602526 | 26602526 | PRJNA532380_P_NODE_3741_length_532_cov_1.184265_g3421_i0 | PRJNA532380 | 3741 | 532 | 1.184265 | 6.3002898 | uncultured Arthrobacter sp. | 114050 | Bacteria | Bacteria | 130 | 1.1499999999999999e-32 | NR | WP_346925879.1 | 114050 | g3421 | i0 | 41.5 | 0.992481203007519 | 176 | 101 | 99.2 | 1 | 2 | 529 | 13 | 186 | WP_346925879.1 hypothetical protein [uncultured Arthrobacter sp.] | diamond | 528 | 130 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | uncultured Arthrobacter sp. | ||
| 27140460 | 27140460 | PRJNA532380_P_NODE_32982_length_162_cov_1.221239_g32657_i0 | PRJNA532380 | 32982 | 162 | 1.221239 | 1.97840718 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 42.7 | 0.0127 | NR | MDP1547840.1 | 2073117 | g32657 | i0 | 44.7 | 0.703703703703704 | 38 | 21 | 70.4 | 0 | 37 | 150 | 87 | 124 | MDP1547840.1 hypothetical protein [Anaerolineales bacterium] | diamond | 114 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27409002 | 27409002 | PRJNA532380_P_NODE_16423_length_222_cov_2.508671_g16098_i0 | PRJNA532380 | 16423 | 222 | 2.508671 | 5.56924962 | Bacteria | 2 | Bacteria | Bacteria | 42.4 | 0.0396 | NR | NLE27748.1 | 1898204 | g16098 | i0 | 47.1 | 0.918918918918919 | 34 | 18 | 45.9 | 0 | 195 | 94 | 333 | 366 | NLE27748.1 transposase [Clostridiaceae bacterium] | diamond | 204 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridiaceae bacterium | |||
| 27583024 | 27583024 | PRJNA532380_P_NODE_26484_length_172_cov_1.349593_g26159_i0 | PRJNA532380 | 26484 | 172 | 1.349593 | 2.32129996 | Streptomyces luteolus | 3043615 | Bacteria | Bacteria | 41.2 | 0.0469 | NR | WP_282533273.1 | 3043615 | g26159 | i0 | 47.9 | 0.837209302325581 | 48 | 22 | 83.7 | 2 | 145 | 2 | 25 | 69 | WP_282533273.1 hypothetical protein [Streptomyces luteolus] | diamond | 144 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces luteolus | ||
| 27930427 | 27930427 | PRJNA532380_P_NODE_25365_length_177_cov_0.968750_g25040_i0 | PRJNA532380 | 25365 | 177 | 0.96875 | 1.7146875 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 42.7 | 0.0106 | NR | HET8664776.1 | 35761 | g25040 | i0 | 38.5 | 0.88135593220339 | 52 | 32 | 88.1 | 0 | 19 | 174 | 85 | 136 | HET8664776.1 Rv3235 family protein [Nocardioides sp.] | diamond | 156 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 28025207 | 28025207 | PRJNA532380_P_NODE_22385_length_190_cov_0.929078_g22060_i0 | PRJNA532380 | 22385 | 190 | 0.929078 | 1.7652482 | Nonomuraea corallina | 2989783 | Bacteria | Bacteria | 44.3 | 0.00527 | NR | WP_270156369.1 | 2989783 | g22060 | i0 | 51.9 | 0.852631578947368 | 54 | 21 | 78.9 | 3 | 17 | 166 | 182 | 234 | WP_270156369.1 acyltransferase family protein [Nonomuraea corallina] | diamond | 162 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea corallina | ||
| 28088158 | 28088158 | PRJNA532380_P_NODE_26225_length_173_cov_1.395161_g25900_i0 | PRJNA532380 | 26225 | 173 | 1.395161 | 2.41362853 | Rubrobacteraceae bacterium | 2740537 | Bacteria | Bacteria | 40 | 0.0457 | NR | MBA3491742.1 | 2740537 | g25900 | i0 | 47.4 | 0.658959537572254 | 38 | 17 | 65.9 | 1 | 29 | 142 | 67 | 101 | MBA3491742.1 AI-2E family transporter [Rubrobacteraceae bacterium] | diamond | 114 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacteraceae bacterium | |||
| 28277543 | 28277543 | PRJNA532380_P_NODE_28486_length_168_cov_0.873950_g28161_i0 | PRJNA532380 | 28486 | 168 | 0.87395 | 1.468236 | Aliterella atlantica | 1827278 | Bacteria | Bacteria | 112 | 1.09e-29 | NR | WP_045056150.1 | 1827278 | g28161 | i0 | 98.1 | 0.946428571428571 | 53 | 1 | 94.6 | 0 | 160 | 2 | 1 | 53 | WP_045056150.1 Dps family protein [Aliterella atlantica] | diamond | 159 | 112 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Aliterellaceae | Aliterella | Aliterella atlantica | |
| 29035700 | 29035700 | PRJNA532380_P_NODE_19828_length_202_cov_1.359477_g19503_i0 | PRJNA532380 | 19828 | 202 | 1.359477 | 2.74614354 | Aceticella autotrophica | 2755338 | Bacteria | Bacteria | 81.3 | 5.63e-16 | NR | WP_284680459.1 | 2755338 | g19503 | i0 | 56.1 | 0.98019801980198 | 66 | 29 | 98 | 0 | 3 | 200 | 702 | 767 | WP_284680459.1 endopeptidase La [Aceticella autotrophica] | diamond | 198 | 81.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Thermoanaerobacterales | Thermoanaerobacteraceae | Aceticella | Aceticella autotrophica | ||
| 29951234 | 29951234 | PRJNA532380_P_NODE_11351_length_273_cov_1.294643_g11026_i0 | PRJNA532380 | 11351 | 273 | 1.294643 | 3.53437539 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 43.1 | 0.0375 | NR | MFA4835409.1 | 2026734 | g11026 | i0 | 41.3 | 0.505494505494505 | 46 | 22 | 50.5 | 1 | 38 | 175 | 287 | 327 | MFA4835409.1 preprotein translocase subunit SecY [Dehalococcoidia bacterium] | diamond | 138 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30172293 | 30172293 | PRJNA532380_P_NODE_32972_length_162_cov_1.292035_g32647_i0 | PRJNA532380 | 32972 | 162 | 1.292035 | 2.0930967 | Cohnella thailandensis | 557557 | Bacteria | Bacteria | 63.2 | 6.06e-10 | NR | WP_185120179.1 | 557557 | g32647 | i0 | 50 | 1.07407407407407 | 58 | 25 | 100 | 1 | 1 | 162 | 240 | 297 | WP_185120179.1 fumarylacetoacetate hydrolase family protein [Cohnella thailandensis] | diamond | 174 | 63.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Cohnella | Cohnella thailandensis | ||
| 30425564 | 30425564 | PRJNA532380_P_NODE_12613_length_256_cov_1.574879_g12288_i0 | PRJNA532380 | 12613 | 256 | 1.574879 | 4.03169024 | Streptomyces sp. NRRL F-5727 | 1463871 | Bacteria | Bacteria | 43.9 | 0.0162 | NR | WP_051716732.1 | 1463871 | g12288 | i0 | 45.1 | 1.1953125 | 51 | 26 | 59.8 | 1 | 224 | 72 | 322 | 370 | WP_051716732.1 MATE family efflux transporter [Streptomyces sp. NRRL F-5727] | diamond | 306 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NRRL F-5727 | ||
| 30551381 | 30551381 | PRJNA532380_P_NODE_33313_length_162_cov_0.920354_g32988_i0 | PRJNA532380 | 33313 | 162 | 0.920354 | 1.49097348 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 90.5 | 2.64e-20 | NR | MBX3084320.1 | 2052143 | g32988 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 160 | 2 | 9 | 61 | MBX3084320.1 DUF2085 domain-containing protein [Anaerolineae bacterium] | diamond | 159 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31278182 | 31278182 | PRJNA532380_P_NODE_31815_length_164_cov_0.904348_g31490_i0 | PRJNA532380 | 31815 | 164 | 0.904348 | 1.48313072 | Cohnella cellulosilytica | 986710 | Bacteria | Bacteria | 63.5 | 4.29e-10 | NR | WP_378045396.1 | 986710 | g31490 | i0 | 51.7 | 3.18292682926829 | 58 | 24 | 98.8 | 1 | 164 | 3 | 227 | 284 | WP_378045396.1 fumarylacetoacetate hydrolase family protein [Cohnella cellulosilytica] | diamond | 522 | 63.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Cohnella | Cohnella cellulosilytica | ||
| 31563204 | 31563204 | PRJNA532380_P_NODE_19156_length_206_cov_0.993631_g18831_i0 | PRJNA532380 | 19156 | 206 | 0.993631 | 2.04687986 | Piscicoccus intestinalis | 746033 | Bacteria | Bacteria | 42 | 0.0418 | NR | WP_068430052.1 | 746033 | g18831 | i0 | 47.5 | 0.58252427184466 | 40 | 21 | 58.3 | 0 | 87 | 206 | 205 | 244 | WP_068430052.1 universal stress protein [Piscicoccus intestinalis] | diamond | 120 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermatophilaceae | Piscicoccus | Piscicoccus intestinalis | ||
| 31609720 | 31609720 | PRJNA532380_P_NODE_29356_length_167_cov_0.881356_g29031_i0 | PRJNA532380 | 29356 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 78.6 | 2.53e-15 | NR | WP_294182474.1 | 1485 | g29031 | i0 | 71.7 | 12.4491017964072 | 53 | 15 | 95.2 | 0 | 9 | 167 | 282 | 334 | WP_294182474.1 MULTISPECIES: dihydrolipoamide acetyltransferase family protein [Clostridium] | diamond | 2079 | 78.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | |||
| 31957556 | 31957556 | PRJNA532380_P_NODE_13837_length_243_cov_2.520619_g13512_i0 | PRJNA532380 | 13837 | 243 | 2.520619 | 6.12510417 | Conexibacter | 191494 | Bacteria | Bacteria | 88.6 | 9.72e-19 | NR | HMJ02477.1 | 1929289 | g13512 | i0 | 61.1 | 2.81481481481481 | 72 | 26 | 88.9 | 1 | 240 | 25 | 227 | 296 | HMJ02477.1 malate dehydrogenase [Conexibacter sp.] | diamond | 684 | 88.6 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter sp. |
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);;