contig_metadata
17 rows where bioproject = "PRJNA565584", tax_clade = "delta/epsilon subdivisions" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1133698 | 1133698 | PRJNA565584_P_NODE_105961_length_291_cov_1.059633_g104809_i0 | PRJNA565584 | 105961 | 291 | 1.059633 | 3.08353203 | Bacteria | 2 | Bacteria | Bacteria | 296 | 1.13e-75 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g104809 | i0 | 85.315 | 234.034364261168 | 286 | 42 | 98 | 0 | 6 | 291 | 12580 | 12865 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 68104 | 298 | 0.993288590604027 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 20959251 | 20959251 | PRJNA565584_P_NODE_49937_length_421_cov_1.353448_g48786_i0 | PRJNA565584 | 49937 | 421 | 1.353448 | 5.69801608 | uncultured delta proteobacterium HF0070_10I02 | 710824 | Bacteria | Bacteria | 339 | 2.7799999999999997e-88 | NTclustered | gi|297181000|gb|GU474857.1| | 710824 | g48786 | i0 | 81.818 | 111.676959619952 | 429 | 55 | 99 | 22 | 1 | 417 | 6349 | 6766 | Uncultured delta proteobacterium HF0070_10I02 genomic sequence | blastn | 47016 | 339 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 | ||||||
| 27395636 | 27395636 | PRJNA565584_P_NODE_148143_length_263_cov_2.142105_g146991_i0 | PRJNA565584 | 148143 | 263 | 2.142105 | 5.63373615 | Lujinxingia vulgaris | 2600176 | Bacteria | Bacteria | 78.2 | 1.65e-14 | NR | WP_146981867.1 | 2600176 | g146991 | i0 | 45.7 | 1.04942965779468 | 92 | 43 | 97 | 1 | 260 | 6 | 381 | 472 | WP_146981867.1 hypothetical protein [Lujinxingia vulgaris] | diamond | 276 | 78.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia vulgaris | |||
| 27553024 | 27553024 | PRJNA565584_P_NODE_108704_length_289_cov_1.282407_g107552_i0 | PRJNA565584 | 108704 | 289 | 1.282407 | 3.70615623 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 112 | 2.96e-26 | NR | PKN56954.1 | 2013741 | g107552 | i0 | 67.5 | 0.86159169550173 | 83 | 24 | 86.2 | 1 | 281 | 33 | 1109 | 1188 | PKN56954.1 MAG: hypothetical protein CVU56_13495 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 249 | 112 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 27648276 | 27648276 | PRJNA565584_P_NODE_65724_length_366_cov_2.419795_g64573_i0 | PRJNA565584 | 65724 | 366 | 2.419795 | 8.8564497 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 150 | 8.72e-44 | NR | HJL95153.1 | 2024889 | g64573 | i0 | 60.3 | 2.99180327868852 | 121 | 46 | 97.5 | 1 | 364 | 8 | 15 | 135 | HJL95153.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 1095 | 150 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 27806147 | 27806147 | PRJNA565584_P_NODE_46944_length_435_cov_2.116022_g45793_i0 | PRJNA565584 | 46944 | 435 | 2.116022 | 9.2046957 | Deltaproteobacteria bacterium ADurb.Bin2 | 2026735 | Bacteria | Bacteria | 49.3 | 0.00147 | NR | OQB17778.1 | 1852869 | g45793 | i0 | 30.3 | 1.04827586206897 | 152 | 79 | 96.6 | 8 | 434 | 15 | 752 | 888 | OQB17778.1 MAG: hypothetical protein BWY17_00775 [Deltaproteobacteria bacterium ADurb.Bin207] | diamond | 456 | 49.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin207 | ||||||
| 27963721 | 27963721 | PRJNA565584_P_NODE_130605_length_275_cov_1.396040_g129453_i0 | PRJNA565584 | 130605 | 275 | 1.39604 | 3.83911 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 63.2 | 3.66e-9 | NR | WP_146963142.1 | 2600177 | g129453 | i0 | 40.9 | 1.88727272727273 | 93 | 43 | 91.6 | 5 | 275 | 24 | 133 | 222 | WP_146963142.1 hypothetical protein [Microvenator marinus] | diamond | 519 | 63.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 28721654 | 28721654 | PRJNA565584_P_NODE_186207_length_247_cov_0.885057_g185055_i0 | PRJNA565584 | 186207 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium GWA2_57_13 | 1797811 | Bacteria | Bacteria | 111 | 5.61e-27 | NR | OGP30523.1 | 1797811 | g185055 | i0 | 69.1 | 0.983805668016194 | 81 | 25 | 98.4 | 0 | 3 | 245 | 210 | 290 | OGP30523.1 MAG: hypothetical protein A2038_12305 [Deltaproteobacteria bacterium GWA2_57_13] | diamond | 243 | 111 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWA2_57_13 | ||||||
| 29952963 | 29952963 | PRJNA565584_P_NODE_144951_length_265_cov_2.390625_g143799_i0 | PRJNA565584 | 144951 | 265 | 2.390625 | 6.33515625 | Deltaproteobacteria bacterium RBG_16_54_18 | 1797843 | Bacteria | Bacteria | 92 | 2.16e-19 | NR | OGP95017.1 | 1797843 | g143799 | i0 | 53.2 | 4.47169811320755 | 79 | 37 | 89.4 | 0 | 3 | 239 | 310 | 388 | OGP95017.1 MAG: translation elongation factor G [Deltaproteobacteria bacterium RBG_16_54_18] | diamond | 1185 | 92 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_16_54_18 | ||||||
| 30458986 | 30458986 | PRJNA565584_P_NODE_40533_length_471_cov_1.824121_g39382_i0 | PRJNA565584 | 40533 | 471 | 1.824121 | 8.59160991 | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | 1797895 | Bacteria | Bacteria | 112 | 7.07e-29 | NR | OGQ88263.1 | 1797895 | g39382 | i0 | 58.4 | 0.56687898089172 | 89 | 37 | 56.7 | 0 | 81 | 347 | 5 | 93 | OGQ88263.1 MAG: RNA-binding protein [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 267 | 112 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 30490116 | 30490116 | PRJNA565584_P_NODE_122653_length_280_cov_1.487923_g121501_i0 | PRJNA565584 | 122653 | 280 | 1.487923 | 4.1661844 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 58.5 | 1.58e-7 | NR | MBL7035920.1 | 2024889 | g121501 | i0 | 38.2 | 0.814285714285714 | 76 | 40 | 78.2 | 2 | 61 | 279 | 361 | 432 | MBL7035920.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 228 | 58.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 30521666 | 30521666 | PRJNA565584_P_NODE_142573_length_267_cov_1.567010_g141421_i0 | PRJNA565584 | 142573 | 267 | 1.56701 | 4.1839167 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 101 | 9.069999999999999e-24 | NR | WP_141197554.1 | 2292766 | g141421 | i0 | 60.2 | 2.79775280898876 | 83 | 33 | 93.3 | 0 | 250 | 2 | 43 | 125 | WP_141197554.1 2-oxo acid dehydrogenase subunit E2 [Persicimonas caeni] | diamond | 747 | 101 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 31564997 | 31564997 | PRJNA565584_P_NODE_193216_length_246_cov_0.890173_g192064_i0 | PRJNA565584 | 193216 | 246 | 0.890173 | 2.18982558 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 95.5 | 1.01e-20 | NR | MBF0236561.1 | 2024889 | g192064 | i0 | 57 | 0.963414634146341 | 79 | 34 | 96.3 | 0 | 239 | 3 | 485 | 563 | MBF0236561.1 long-chain-acyl-CoA synthetase [SAR324 cluster bacterium] | diamond | 237 | 95.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 31691322 | 31691322 | PRJNA565584_P_NODE_82817_length_327_cov_0.909449_g81665_i0 | PRJNA565584 | 82817 | 327 | 0.909449 | 2.97389823 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 101 | 5.16e-23 | NR | MBN1947766.1 | 2099667 | g81665 | i0 | 46.3 | 0.990825688073395 | 108 | 54 | 99.1 | 2 | 324 | 1 | 29 | 132 | MBN1947766.1 CDP-alcohol phosphatidyltransferase family protein [Bradymonadales bacterium] | diamond | 324 | 101 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 31722838 | 31722838 | PRJNA565584_P_NODE_211617_length_241_cov_5.982143_g210465_i0 | PRJNA565584 | 211617 | 241 | 5.982143 | 14.41696463 | Deltaproteobacteria bacterium RBG_13_43_22 | 1797825 | Bacteria | Bacteria | 83.6 | 3.48e-17 | NR | OGP50875.1 | 1797825 | g210465 | i0 | 50 | 3.02489626556017 | 80 | 40 | 99.6 | 0 | 241 | 2 | 183 | 262 | OGP50875.1 MAG: DNA-formamidopyrimidine glycosylase [Deltaproteobacteria bacterium RBG_13_43_22] | diamond | 729 | 83.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_43_22 | ||||||
| 32021321 | 32021321 | PRJNA565584_P_NODE_114438_length_285_cov_1.853774_g113286_i0 | PRJNA565584 | 114438 | 285 | 1.853774 | 5.2832559 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 91.7 | 1.8899999999999998e-20 | NR | OGR14076.1 | 1797899 | g113286 | i0 | 57.9 | 4.87368421052632 | 76 | 32 | 80 | 0 | 284 | 57 | 108 | 183 | OGR14076.1 MAG: adenylate kinase [Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9] | diamond | 1389 | 92 | 0.996739130434783 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYB12_FULL_58_9 | ||||||
| 32292735 | 32292735 | PRJNA565584_P_NODE_157519_length_257_cov_1.771739_g156367_i0 | PRJNA565584 | 157519 | 257 | 1.771739 | 4.55336923 | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | 1973967 | Bacteria | Bacteria | 44.3 | 0.0128 | NR | PJB41402.1 | 1973967 | g156367 | i0 | 34.4 | 0.712062256809339 | 61 | 33 | 63 | 1 | 226 | 65 | 194 | 254 | PJB41402.1 MAG: hypothetical protein CO108_13165 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12] | diamond | 183 | 44.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 |
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);;