contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Parcubacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26725310 | 26725310 | PRJNA168635_P_NODE_23801_length_172_cov_1.536585_g23385_i0 | PRJNA168635 | 23801 | 172 | 1.536585 | 2.6429262 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 99.4 | 1.6700000000000001e-22 | NR | MEY4731727.1 | 2762014 | g23385 | i0 | 86 | 0.994186046511628 | 57 | 8 | 99.4 | 0 | 1 | 171 | 584 | 640 | MEY4731727.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 171 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28273916 | 28273916 | PRJNA168635_P_NODE_29166_length_165_cov_0.896552_g28750_i0 | PRJNA168635 | 29166 | 165 | 0.896552 | 1.4793108 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 74.7 | 6.09e-14 | NR | MCG2685873.1 | 2762014 | g28750 | i0 | 63 | 1.96363636363636 | 54 | 20 | 98.2 | 0 | 3 | 164 | 152 | 205 | MCG2685873.1 DNA polymerase III subunit gamma/tau [Candidatus Parcubacteria bacterium] | diamond | 324 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 28337226 | 28337226 | PRJNA168635_P_NODE_27746_length_166_cov_1.760684_g27330_i0 | PRJNA168635 | 27746 | 166 | 1.760684 | 2.92273544 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 93.2 | 9.98e-21 | NR | MEA2715371.1 | 2762014 | g27330 | i0 | 77.8 | 2.85542168674699 | 54 | 12 | 97.6 | 0 | 5 | 166 | 38 | 91 | MEA2715371.1 cysteinyl-tRNA synthetase [Candidatus Parcubacteria bacterium] | diamond | 474 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29473587 | 29473587 | PRJNA168635_P_NODE_17850_length_190_cov_1.460993_g17434_i0 | PRJNA168635 | 17850 | 190 | 1.460993 | 2.7758867 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 42.4 | 0.0249 | NR | RJQ33899.1 | 2762014 | g17434 | i0 | 47.1 | 0.805263157894737 | 51 | 27 | 80.5 | 0 | 30 | 182 | 551 | 601 | RJQ33899.1 MAG: hypothetical protein C4568_03800 [Candidatus Parcubacteria bacterium] | diamond | 153 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29694566 | 29694566 | PRJNA168635_P_NODE_31910_length_162_cov_0.920354_g31494_i0 | PRJNA168635 | 31910 | 162 | 0.920354 | 1.49097348 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 47.4 | 1.65e-4 | NR | MCK5061739.1 | 2762014 | g31494 | i0 | 44.4 | 1 | 54 | 26 | 92.6 | 1 | 9 | 158 | 68 | 121 | MCK5061739.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 162 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 29820957 | 29820957 | PRJNA168635_P_NODE_34691_length_154_cov_2.590476_g34275_i0 | PRJNA168635 | 34691 | 154 | 2.590476 | 3.98933304 | Parcubacteria bacterium C7867- | 2762014 | Bacteria | Bacteria | 70.9 | 1.28e-12 | NR | KND48200.1 | 1659200 | g34275 | i0 | 97.1 | 0.662337662337662 | 34 | 1 | 66.2 | 0 | 1 | 102 | 43 | 76 | KND48200.1 MAG: threonine--tRNA ligase [Parcubacteria bacterium C7867-006] | diamond | 102 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-006 | ||||||
| 30010881 | 30010881 | PRJNA168635_P_NODE_26531_length_168_cov_0.873950_g26115_i0 | PRJNA168635 | 26531 | 168 | 0.87395 | 1.468236 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 106 | 4.3e-25 | NR | MBX4209607.1 | 2762014 | g26115 | i0 | 78.6 | 3 | 56 | 12 | 100 | 0 | 1 | 168 | 47 | 102 | MBX4209607.1 O-antigen ligase family protein [Candidatus Parcubacteria bacterium] | diamond | 504 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria bacterium | ||||||
| 30990331 | 30990331 | PRJNA168635_P_NODE_26174_length_168_cov_0.873950_g25758_i0 | PRJNA168635 | 26174 | 168 | 0.87395 | 1.468236 | Parcubacteria bacterium C7867- | 2762014 | Bacteria | Bacteria | 84.7 | 2.13e-17 | NR | KND48325.1 | 1659197 | g25758 | i0 | 73.6 | 1.85714285714286 | 53 | 14 | 94.6 | 0 | 160 | 2 | 2138 | 2190 | KND48325.1 MAG: hypothetical protein AB198_01235, partial [Parcubacteria bacterium C7867-003] | diamond | 312 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Parcubacteria bacterium C7867-003 | ||||||
| 32033810 | 32033810 | PRJNA168635_P_NODE_13818_length_217_cov_7.505952_g13402_i0 | PRJNA168635 | 13818 | 217 | 7.505952 | 16.28791584 | Candidatus Parcubacteria bacterium | 2762014 | Bacteria | Bacteria | 121 | 1.04e-32 | NR | MEN9412989.1 | 2762014 | g13402 | i0 | 83.1 | 0.981566820276498 | 71 | 12 | 98.2 | 0 | 215 | 3 | 12 | 82 | MEN9412989.1 hypothetical protein [Candidatus Parcubacteria bacterium] | diamond | 213 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Parcubacteria | Candidatus Parcubacteria 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);;