contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13656954 | 13656954 | PRJNA928559_P_NODE_195531_length_250_cov_0.881356_g193962_i0 | PRJNA928559 | 195531 | 250 | 0.881356 | 2.20339 | Bradymonadaceae bacterium | 2740543 | Bacteria | Bacteria | 68.6 | 3.11e-11 | NR | MFU8805234.1 | 2740543 | g193962 | i0 | 51.3 | 0.936 | 78 | 38 | 93.6 | 0 | 9 | 242 | 11 | 88 | MFU8805234.1 two-component system sensor histidine kinase NtrB [Bradymonadaceae bacterium] | diamond | 234 | 68.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonadaceae bacterium | ||||
| 17481533 | 17481533 | PRJNA928559_P_NODE_204954_length_246_cov_0.901734_g203385_i0 | PRJNA928559 | 204954 | 246 | 0.901734 | 2.21826564 | Bradymonadales | 1779134 | Bacteria | Bacteria | 122 | 6.38e-31 | NR | WP_146958764.1 | 2600177 | g203385 | i0 | 81.2 | 3.3780487804878 | 69 | 13 | 84.1 | 0 | 208 | 2 | 1 | 69 | WP_146958764.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Microvenator marinus] | diamond | 831 | 122 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 17482918 | 17482918 | PRJNA928559_P_NODE_99854_length_357_cov_1.665493_g98285_i0 | PRJNA928559 | 99854 | 357 | 1.665493 | 5.94581001 | Bacteria | 2 | Bacteria | Bacteria | 114 | 5.15e-30 | NR | OGQ03968.1 | 1797856 | g98285 | i0 | 59.3 | 11.327731092437 | 113 | 40 | 95 | 2 | 341 | 3 | 1 | 107 | OGQ03968.1 MAG: 50S ribosomal protein L7/L12 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49] | diamond | 4044 | 115 | 0.991304347826087 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49 | ||||||
| 20379573 | 20379573 | PRJNA928559_P_NODE_94376_length_367_cov_1.326531_g92807_i0 | PRJNA928559 | 94376 | 367 | 1.326531 | 4.86836877 | Lujinxingia | 2653226 | Bacteria | Bacteria | 178 | 3.9e-54 | NR | WP_146981624.1 | 2600176 | g92807 | i0 | 69.2 | 4.89645776566757 | 120 | 37 | 98.1 | 0 | 362 | 3 | 77 | 196 | WP_146981624.1 30S ribosomal protein S4 [Lujinxingia vulgaris] | diamond | 1797 | 178 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia vulgaris | |||
| 25479645 | 25479645 | PRJNA928559_P_NODE_3580_length_1548_cov_3.755932_g2941_i0 | PRJNA928559 | 3580 | 1548 | 3.755932 | 58.14182736 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 305 | 1.46e-93 | NR | MBF0351506.1 | 2024889 | g2941 | i0 | 60.3 | 3.83720930232558 | 272 | 106 | 52.3 | 2 | 836 | 27 | 26 | 297 | MBF0351506.1 PfaD family polyunsaturated fatty acid/polyketide biosynthesis protein [SAR324 cluster bacterium] | diamond | 5940 | 308 | 0.99025974025974 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28130420 | 28130420 | PRJNA928559_P_NODE_214145_length_242_cov_1.384615_g212576_i0 | PRJNA928559 | 214145 | 242 | 1.384615 | 3.3507683 | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | 1973967 | Bacteria | Bacteria | 42.4 | 0.0499 | NR | PJB48263.1 | 1973967 | g212576 | i0 | 37.9 | 0.71900826446281 | 58 | 33 | 68.2 | 1 | 63 | 227 | 447 | 504 | PJB48263.1 MAG: hypothetical protein CO108_02650 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12] | diamond | 174 | 42.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | ||||||
| 28382816 | 28382816 | PRJNA928559_P_NODE_153786_length_284_cov_1.279621_g152217_i0 | PRJNA928559 | 153786 | 284 | 1.279621 | 3.63412364 | Lujinxingiaceae bacterium | 2946527 | Bacteria | Bacteria | 67.8 | 1.73e-12 | NR | MBA2660823.1 | 2946527 | g152217 | i0 | 42 | 0.855633802816901 | 81 | 46 | 85.6 | 1 | 276 | 34 | 8 | 87 | MBA2660823.1 KH domain-containing protein [Lujinxingiaceae bacterium] | diamond | 243 | 67.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingiaceae bacterium | ||||
| 28737390 | 28737390 | PRJNA928559_P_NODE_194387_length_250_cov_1.389831_g192818_i0 | PRJNA928559 | 194387 | 250 | 1.389831 | 3.4745775 | Bacteria | 2 | Bacteria | Bacteria | 53.9 | 4.3e-6 | NR | OGQ06361.1 | 1797856 | g192818 | i0 | 40.5 | 1.896 | 79 | 47 | 94.8 | 0 | 248 | 12 | 203 | 281 | OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49] | diamond | 474 | 53.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49 | ||||||
| 30182756 | 30182756 | PRJNA928559_P_NODE_179052_length_260_cov_1.331551_g177483_i0 | PRJNA928559 | 179052 | 260 | 1.331551 | 3.4620326 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 79 | 1.91e-15 | NR | WP_146957651.1 | 2600177 | g177483 | i0 | 52.3 | 3.09230769230769 | 86 | 41 | 99.2 | 0 | 2 | 259 | 170 | 255 | WP_146957651.1 PspA/IM30 family protein [Microvenator marinus] | diamond | 804 | 79 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 31763182 | 31763182 | PRJNA928559_P_NODE_47097_length_496_cov_2.482270_g45535_i0 | PRJNA928559 | 47097 | 496 | 2.48227 | 12.3120592 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 97.4 | 5.02e-20 | NR | PKN53796.1 | 2013741 | g45535 | i0 | 43 | 0.647177419354839 | 107 | 54 | 63.5 | 3 | 324 | 10 | 751 | 852 | PKN53796.1 MAG: hypothetical protein CVU56_29970 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 321 | 97.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 32142896 | 32142896 | PRJNA928559_P_NODE_197318_length_249_cov_0.886364_g195749_i0 | PRJNA928559 | 197318 | 249 | 0.886364 | 2.20704636 | Lujinxingiaceae bacterium | 2946527 | Bacteria | Bacteria | 107 | 1.85e-25 | NR | MBA2662702.1 | 2946527 | g195749 | i0 | 61 | 0.987951807228916 | 82 | 32 | 98.8 | 0 | 248 | 3 | 76 | 157 | MBA2662702.1 hypothetical protein [Lujinxingiaceae bacterium] | diamond | 246 | 107 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingiaceae bacterium | ||||
| 32522833 | 32522833 | PRJNA928559_P_NODE_214819_length_242_cov_0.923077_g213250_i0 | PRJNA928559 | 214819 | 242 | 0.923077 | 2.23384634 | Bradymonadaceae bacterium | 2740543 | Bacteria | Bacteria | 89.7 | 2.97e-20 | NR | MFU8805295.1 | 2740543 | g213250 | i0 | 48.6 | 0.892561983471074 | 72 | 37 | 89.3 | 0 | 217 | 2 | 91 | 162 | MFU8805295.1 hypothetical protein [Bradymonadaceae bacterium] | diamond | 216 | 89.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonadaceae 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);;