contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6399347 | 6399347 | PRJEB14664_P_NODE_1866_length_676_cov_1.962559_g1759_i0 | PRJEB14664 | 1866 | 676 | 1.962559 | 13.26689884 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 246 | 9.3e-80 | NR | MCB0370127.1 | 2053517 | g1759 | i0 | 87.9 | 0.625739644970414 | 141 | 17 | 62.6 | 0 | 456 | 34 | 30 | 170 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 423 | 246 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 7673494 | 7673494 | PRJEB14664_P_NODE_5967_length_340_cov_1.196721_g5837_i0 | PRJEB14664 | 5967 | 340 | 1.196721 | 4.0688514 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 189 | 2.6400000000000007e-59 | NR | MCB0369869.1 | 2053517 | g5837 | i0 | 81.3 | 0.988235294117647 | 112 | 21 | 98.8 | 0 | 336 | 1 | 1 | 112 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 336 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 8948291 | 8948291 | PRJEB14664_P_NODE_9688_length_247_cov_1.759434_g9558_i0 | PRJEB14664 | 9688 | 247 | 1.759434 | 4.34580198 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 103 | 4.68e-26 | NR | MCB0369389.1 | 2053517 | g9558 | i0 | 71 | 0.838056680161943 | 69 | 19 | 83.8 | 1 | 41 | 247 | 25 | 92 | MCB0369389.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 207 | 103 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26843402 | 26843402 | PRJEB14664_P_NODE_9501_length_251_cov_1.291667_g9371_i0 | PRJEB14664 | 9501 | 251 | 1.291667 | 3.24208417 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 3.829999999999999e-31 | NR | MCB0368309.1 | 2053517 | g9371 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 3 | 251 | 17 | 99 | MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28043794 | 28043794 | PRJEB14664_P_NODE_11725_length_216_cov_2.038674_g11595_i0 | PRJEB14664 | 11725 | 216 | 2.038674 | 4.40353584 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 94 | 1.48e-22 | NR | MCB0368309.1 | 2053517 | g11595 | i0 | 70.4 | 0.986111111111111 | 71 | 21 | 98.6 | 0 | 214 | 2 | 29 | 99 | MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 213 | 94 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29464217 | 29464217 | PRJEB14664_P_NODE_4670_length_400_cov_1.884932_g4540_i0 | PRJEB14664 | 4670 | 400 | 1.884932 | 7.539728 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 223 | 1.6299999999999998e-72 | NR | MCB0369869.1 | 2053517 | g4540 | i0 | 84.1 | 0.99 | 132 | 21 | 99 | 0 | 397 | 2 | 1 | 132 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 396 | 223 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29622060 | 29622060 | PRJEB14664_P_NODE_6090_length_335_cov_2.266667_g5960_i0 | PRJEB14664 | 6090 | 335 | 2.266667 | 7.59333445 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.8 | 0.00914 | NR | MCB0348069.1 | 2053517 | g5960 | i0 | 48 | 0.447761194029851 | 50 | 23 | 44.8 | 1 | 153 | 302 | 409 | 455 | MCB0348069.1 PKD domain-containing protein [Bdellovibrionales bacterium] | diamond | 150 | 45.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29780346 | 29780346 | PRJEB14664_P_NODE_16691_length_170_cov_1.481481_g16561_i0 | PRJEB14664 | 16691 | 170 | 1.481481 | 2.5185177 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 85.9 | 1.23e-19 | NR | MCB0370359.1 | 2053517 | g16561 | i0 | 80.9 | 0.829411764705882 | 47 | 9 | 82.9 | 0 | 30 | 170 | 18 | 64 | MCB0370359.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium] | diamond | 141 | 85.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29906835 | 29906835 | PRJEB14664_P_NODE_15571_length_178_cov_1.958042_g15441_i0 | PRJEB14664 | 15571 | 178 | 1.958042 | 3.48531476 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 97.4 | 4.319999999999999e-24 | NR | MCB0370715.1 | 2053517 | g15441 | i0 | 79.7 | 0.99438202247191 | 59 | 12 | 99.4 | 0 | 2 | 178 | 84 | 142 | MCB0370715.1 fibrillarin-like rRNA/tRNA 2'-O-methyltransferase [Bdellovibrionales bacterium] | diamond | 177 | 97.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31518510 | 31518510 | PRJEB14664_P_NODE_9976_length_242_cov_1.913043_g9846_i0 | PRJEB14664 | 9976 | 242 | 1.913043 | 4.62956406 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 119 | 4.72e-32 | NR | MCB0369646.1 | 2053517 | g9846 | i0 | 66.7 | 1.07851239669421 | 87 | 22 | 99.2 | 1 | 240 | 1 | 10 | 96 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 261 | 119 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31644769 | 31644769 | PRJEB14664_P_NODE_9377_length_253_cov_1.467890_g9247_i0 | PRJEB14664 | 9377 | 253 | 1.46789 | 3.7137617 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 143 | 3.07e-42 | NR | MCB0370921.1 | 2053517 | g9247 | i0 | 79.5 | 0.984189723320158 | 83 | 17 | 98.4 | 0 | 3 | 251 | 6 | 88 | MCB0370921.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 249 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;