contig_metadata
11 rows where bioproject = "PRJNA575566", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19686661 | 19686661 | PRJNA575566_P_NODE_28156_length_203_cov_1.352113_g27959_i0 | PRJNA575566 | 28156 | 203 | 1.352113 | 2.74478939 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 152 | 1.7e-32 | NTclustered | gi|161158851|emb|AM746676.1| | 448385 | g27959 | i0 | 81.522 | 1.89655172413793 | 184 | 34 | 91 | 0 | 6 | 189 | 2828605 | 2828788 | Sorangium cellulosum 'So ce 56' complete genome | blastn | 385 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 27851093 | 27851093 | PRJNA575566_P_NODE_18904_length_242_cov_1.060773_g18707_i0 | PRJNA575566 | 18904 | 242 | 1.060773 | 2.56707066 | root | 1 | Root_unresolved | Root_unresolved | 81.3 | 9.83e-16 | NR | WP_181197707.1 | 215803 | g18707 | i0 | 41.3 | 3.94214876033058 | 80 | 47 | 99.2 | 0 | 2 | 241 | 261 | 340 | WP_181197707.1 aldehyde dehydrogenase family protein [Enhygromyxa salina] | diamond | 954 | 81.6 | 0.996323529411765 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 27977471 | 27977471 | PRJNA575566_P_NODE_26965_length_205_cov_0.888889_g26768_i0 | PRJNA575566 | 26965 | 205 | 0.888889 | 1.82222245 | Myxococcota | 2818505 | Bacteria | Bacteria | 53.9 | 2.6e-6 | NR | MCZ6806551.1 | 2026735 | g26768 | i0 | 41.9 | 2.73658536585366 | 62 | 36 | 90.7 | 0 | 192 | 7 | 191 | 252 | MCZ6806551.1 long-chain fatty acid--CoA ligase [Deltaproteobacteria bacterium] | diamond | 561 | 54.3 | 0.992633517495396 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29146116 | 29146116 | PRJNA575566_P_NODE_1369_length_876_cov_1.666258_g1209_i0 | PRJNA575566 | 1369 | 876 | 1.666258 | 14.59642008 | Bacteria | 2 | Bacteria | Bacteria | 75.9 | 3.03e-11 | NR | MBM4342325.1 | 2026735 | g1209 | i0 | 30.1 | 3.64383561643836 | 302 | 174 | 98.3 | 12 | 6 | 866 | 515 | 794 | MBM4342325.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 3192 | 76.3 | 0.99475753604194 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30142381 | 30142381 | PRJNA575566_P_NODE_8552_length_358_cov_2.360269_g8355_i0 | PRJNA575566 | 8552 | 358 | 2.360269 | 8.44976302 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42.7 | 0.0123 | NR | MEZ4266528.1 | 2818507 | g8355 | i0 | 66.7 | 0.201117318435754 | 24 | 8 | 20.1 | 0 | 354 | 283 | 12 | 35 | MEZ4266528.1 hypothetical protein [Myxococcota bacterium] | diamond | 72 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30743013 | 30743013 | PRJNA575566_P_NODE_27954_length_204_cov_0.895105_g27757_i0 | PRJNA575566 | 27954 | 204 | 0.895105 | 1.8260142 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 90.1 | 3.09e-19 | NR | MCB9557455.1 | 2026735 | g27757 | i0 | 67.1 | 1.02941176470588 | 70 | 20 | 98.5 | 1 | 202 | 2 | 290 | 359 | MCB9557455.1 2-isopropylmalate synthase [Deltaproteobacteria bacterium] | diamond | 210 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31438293 | 31438293 | PRJNA575566_P_NODE_28116_length_203_cov_1.802817_g27919_i0 | PRJNA575566 | 28116 | 203 | 1.802817 | 3.65971851 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 107 | 1.93e-25 | NR | MSP61786.1 | 2026763 | g27919 | i0 | 77.6 | 0.990147783251232 | 67 | 15 | 99 | 0 | 3 | 203 | 109 | 175 | MSP61786.1 argininosuccinate lyase [Myxococcales bacterium] | diamond | 201 | 107 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31515501 | 31515501 | PRJNA575566_P_NODE_9036_length_348_cov_1.114983_g8839_i0 | PRJNA575566 | 9036 | 348 | 1.114983 | 3.88014084 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 54.7 | 7.94e-6 | NR | MBM4352288.1 | 2026735 | g8839 | i0 | 43.1 | 2.20689655172414 | 65 | 33 | 55.2 | 3 | 346 | 155 | 205 | 266 | MBM4352288.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 768 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31722961 | 31722961 | PRJNA575566_P_NODE_12077_length_302_cov_1.062241_g11880_i0 | PRJNA575566 | 12077 | 302 | 1.062241 | 3.20796782 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0294 | NR | MBM4355836.1 | 2026735 | g11880 | i0 | 51.3 | 0.387417218543046 | 39 | 19 | 38.7 | 0 | 290 | 174 | 491 | 529 | MBM4355836.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 117 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31786115 | 31786115 | PRJNA575566_P_NODE_15917_length_264_cov_2.197044_g15720_i0 | PRJNA575566 | 15917 | 264 | 2.197044 | 5.80019616 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.0143 | NR | MBI5607392.1 | 2026735 | g15720 | i0 | 41 | 0.693181818181818 | 61 | 29 | 61.4 | 1 | 231 | 70 | 474 | 534 | MBI5607392.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 183 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31894768 | 31894768 | PRJNA575566_P_NODE_9737_length_335_cov_1.167883_g9540_i0 | PRJNA575566 | 9737 | 335 | 1.167883 | 3.91240805 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 0.00323 | NR | HBQ12409.1 | 2026763 | g9540 | i0 | 47.6 | 0.743283582089552 | 42 | 20 | 35.8 | 1 | 14 | 133 | 81 | 122 | HBQ12409.1 hypothetical protein [Myxococcales bacterium] | diamond | 249 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;