contig_metadata
8 rows where bioproject = "PRJNA393181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5514765 | 5514765 | PRJNA393181_S_NODE_805_length_907_cov_3.349425_g750_i0 | PRJNA393181 | 805 | 907 | 3.349425 | 30.37928475 | delta/epsilon subdivisions | 68525 | Bacteria | Bacteria | 261 | 1.03e-83 | NR | SBW10919.1 | 34034 | g750 | i0 | 67 | 9.35722160970232 | 203 | 64 | 66.2 | 1 | 602 | 3 | 2 | 204 | SBW10919.1 putative nucleotidyl transferase [uncultured delta proteobacterium] | diamond | 8487 | 261 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 8063332 | 8063332 | PRJNA393181_S_NODE_12027_length_348_cov_2.646302_g11921_i0 | PRJNA393181 | 12027 | 348 | 2.646302 | 9.20913096 | Pseudomonadota | 1224 | Bacteria | Bacteria | 131 | 1.7e-34 | NR | OGQ75385.1 | 1797892 | g11921 | i0 | 70 | 1.37931034482759 | 80 | 24 | 69 | 0 | 241 | 2 | 257 | 336 | OGQ75385.1 MAG: amino acid ABC transporter substrate-binding protein [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22] | diamond | 480 | 132 | 0.992424242424242 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22 | ||||||
| 13164763 | 13164763 | PRJNA393181_S_NODE_6671_length_457_cov_4.088095_g6565_i0 | PRJNA393181 | 6671 | 457 | 4.088095 | 18.68259415 | Pseudomonadota | 1224 | Bacteria | Bacteria | 208 | 6.320000000000001e-64 | NR | OGP63755.1 | 1797827 | g6565 | i0 | 75.6 | 2.42231947483589 | 123 | 30 | 80.7 | 0 | 3 | 371 | 197 | 319 | OGP63755.1 MAG: amino acid ABC transporter substrate-binding protein [Deltaproteobacteria bacterium RBG_13_49_15] | diamond | 1107 | 210 | 0.990476190476191 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_49_15 | ||||||
| 23363150 | 23363150 | PRJNA393181_S_NODE_8699_length_407_cov_2.324324_g8593_i0 | PRJNA393181 | 8699 | 407 | 2.324324 | 9.45999868 | Myxococcota | 2818505 | Bacteria | Bacteria | 116 | 2.39e-30 | NR | MCH9046007.1 | 2024889 | g8593 | i0 | 71.6 | 2.83046683046683 | 74 | 21 | 54.5 | 0 | 226 | 5 | 8 | 81 | MCH9046007.1 GFA family protein [SAR324 cluster bacterium] | diamond | 1152 | 116 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 27345170 | 27345170 | PRJNA393181_S_NODE_12223_length_345_cov_3.275974_g12117_i0 | PRJNA393181 | 12223 | 345 | 3.275974 | 11.3021103 | Bacteria | 2 | Bacteria | Bacteria | 113 | 1.29e-26 | NR | CAB1072383.1 | 334747 | g12117 | i0 | 49.1 | 4.78260869565217 | 110 | 56 | 95.7 | 0 | 344 | 15 | 116 | 225 | CAB1072383.1 hypothetical protein D1AOALGA4SA_1568 [Olavius algarvensis Delta 1 endosymbiont] | diamond | 1650 | 113 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Olavius algarvensis Delta 1 endosymbiont | ||||||
| 27612535 | 27612535 | PRJNA393181_S_NODE_21104_length_255_cov_2.669725_g20998_i0 | PRJNA393181 | 21104 | 255 | 2.669725 | 6.80779875 | Persicimonas sp. | 2766932 | Bacteria | Bacteria | 46.2 | 0.00253 | NR | MFP4599860.1 | 2766932 | g20998 | i0 | 65.6 | 0.376470588235294 | 32 | 11 | 37.6 | 0 | 2 | 97 | 543 | 574 | MFP4599860.1 tetratricopeptide repeat protein [Persicimonas sp.] | diamond | 96 | 46.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas sp. | |||
| 28607998 | 28607998 | PRJNA393181_S_NODE_14847_length_312_cov_3.127273_g14741_i0 | PRJNA393181 | 14847 | 312 | 3.127273 | 9.75709176 | Pseudomonadota | 1224 | Bacteria | Bacteria | 137 | 3.13e-39 | NR | OGQ84840.1 | 1797892 | g14741 | i0 | 75.8 | 1.75 | 91 | 22 | 87.5 | 0 | 311 | 39 | 45 | 135 | OGQ84840.1 MAG: hypothetical protein A3G40_05455 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22] | diamond | 546 | 137 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22 | ||||||
| 31672306 | 31672306 | PRJNA393181_S_NODE_5797_length_483_cov_3.959641_g5691_i0 | PRJNA393181 | 5797 | 483 | 3.959641 | 19.12506603 | Pseudomonadota | 1224 | Bacteria | Bacteria | 181 | 8.879999999999998e-55 | NR | MFI5399844.1 | 2024889 | g5691 | i0 | 66.7 | 3 | 120 | 40 | 74.5 | 0 | 483 | 124 | 75 | 194 | MFI5399844.1 mobile mystery protein B [SAR324 cluster bacterium] | diamond | 1449 | 182 | 0.994505494505495 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster 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);;