contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7821678 | 7821678 | PRJNA1035005_P_NODE_71287_length_247_cov_0.896552_g70881_i0 | PRJNA1035005 | 71287 | 247 | 0.896552 | 2.21448344 | Desulfovermiculus sp. | 2821143 | Bacteria | Bacteria | 120 | 2.18e-30 | NR | MBS3780561.1 | 2821143 | g70881 | i0 | 90.6 | 2.31983805668016 | 64 | 6 | 77.7 | 0 | 56 | 247 | 171 | 234 | MBS3780561.1 DEAD/DEAH box helicase [Desulfovermiculus sp.] | diamond | 573 | 120 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfovermiculus | Desulfovermiculus sp. | ||
| 26678730 | 26678730 | PRJNA1035005_P_NODE_62641_length_250_cov_0.881356_g62235_i0 | PRJNA1035005 | 62641 | 250 | 0.881356 | 2.20339 | Desulfobacterales | 213118 | Bacteria | Bacteria | 59.3 | 5.67e-8 | NR | ETR68999.1 | 890399 | g62235 | i0 | 43.9 | 3.048 | 82 | 42 | 98.4 | 2 | 3 | 248 | 296 | 373 | ETR68999.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetoglobus multicellularis str. Araruama] | diamond | 762 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Candidatus Magnetoglobus | Candidatus Magnetoglobus multicellularis | ||
| 27919540 | 27919540 | PRJNA1035005_P_NODE_43785_length_264_cov_3.094241_g43379_i0 | PRJNA1035005 | 43785 | 264 | 3.094241 | 8.16879624 | Caldimicrobium sp. | 2024963 | Bacteria | Bacteria | 42.7 | 0.0457 | NR | MCS7200316.1 | 2024963 | g43379 | i0 | 63.3 | 0.340909090909091 | 30 | 11 | 34.1 | 0 | 164 | 75 | 329 | 358 | MCS7200316.1 class I SAM-dependent rRNA methyltransferase [Caldimicrobium sp.] | diamond | 90 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Caldimicrobium | Caldimicrobium sp. | ||
| 28511515 | 28511515 | PRJNA1035005_P_NODE_72807_length_246_cov_1.427746_g72401_i0 | PRJNA1035005 | 72807 | 246 | 1.427746 | 3.51225516 | Bacteria | 2 | Bacteria | Bacteria | 67.8 | 3.9e-11 | NR | WP_297955979.1 | 239745 | g72401 | i0 | 42 | 7.89024390243902 | 81 | 41 | 98.8 | 1 | 245 | 3 | 125 | 199 | WP_297955979.1 ketopantoate reductase family protein [uncultured Desulfobulbus sp.] | diamond | 1941 | 68.2 | 0.994134897360704 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | uncultured Desulfobulbus sp. | ||
| 28985427 | 28985427 | PRJNA1035005_P_NODE_85608_length_242_cov_0.923077_g85202_i0 | PRJNA1035005 | 85608 | 242 | 0.923077 | 2.23384634 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 136 | 7.14e-40 | NR | WP_008868611.1 | 488939 | g85202 | i0 | 77.3 | 4.59917355371901 | 75 | 17 | 93 | 0 | 237 | 13 | 13 | 87 | WP_008868611.1 DUF2442 domain-containing protein [Desulfonatronospira thiodismutans] | diamond | 1113 | 137 | 0.992700729927007 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronospira | Desulfonatronospira thiodismutans | ||
| 29214383 | 29214383 | PRJNA1035005_P_NODE_42069_length_267_cov_1.309278_g41663_i0 | PRJNA1035005 | 42069 | 267 | 1.309278 | 3.49577226 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 165 | 2.89e-50 | NR | MEF8942522.1 | 2683721 | g41663 | i0 | 89.9 | 1 | 89 | 9 | 100 | 0 | 1 | 267 | 26 | 114 | MEF8942522.1 type II toxin-antitoxin system antitoxin SocA domain-containing protein [Desulfohalobiaceae bacterium] | diamond | 267 | 165 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 29466365 | 29466365 | PRJNA1035005_P_NODE_80710_length_244_cov_0.883041_g80304_i0 | PRJNA1035005 | 80710 | 244 | 0.883041 | 2.15462004 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 43.5 | 0.0209 | NR | MCF8079870.1 | 2044940 | g80304 | i0 | 43.1 | 1.77049180327869 | 65 | 37 | 79.9 | 0 | 5 | 199 | 907 | 971 | MCF8079870.1 AAA family ATPase [Desulfobacterales bacterium] | diamond | 432 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32216542 | 32216542 | PRJNA1035005_P_NODE_15018_length_323_cov_1.708000_g14612_i0 | PRJNA1035005 | 15018 | 323 | 1.708 | 5.51684 | Candidatus Magnetoglobus multicellularis str. Araruama | 890399 | Bacteria | Bacteria | 143 | 1.75e-37 | NR | ETR68999.1 | 890399 | g14612 | i0 | 62.4 | 0.938080495356037 | 101 | 38 | 93.8 | 0 | 6 | 308 | 135 | 235 | ETR68999.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetoglobus multicellularis str. Araruama] | diamond | 303 | 143 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Candidatus Magnetoglobus | Candidatus Magnetoglobus multicellularis | ||
| 32501495 | 32501495 | PRJNA1035005_P_NODE_68199_length_248_cov_0.891429_g67793_i0 | PRJNA1035005 | 68199 | 248 | 0.891429 | 2.21074392 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 70.1 | 9.27e-12 | NR | MCM2357034.1 | 2282154 | g67793 | i0 | 51.9 | 2.9758064516129 | 81 | 36 | 94.4 | 2 | 235 | 2 | 575 | 655 | MCM2357034.1 Ig-like domain repeat protein [Geobacteraceae bacterium] | diamond | 738 | 70.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae 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);;