contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_phylum = "Elusimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23619947 | 23619947 | PRJNA688655_P_NODE_13199_length_245_cov_0.895349_g13134_i0 | PRJNA688655 | 13199 | 245 | 0.895349 | 2.19360505 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 155 | 2.7899999999999998e-42 | NR | NLE92078.1 | 2030800 | g13134 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 244 | 2 | 89 | 169 | NLE92078.1 elongation factor 4 [Elusimicrobiota bacterium] | diamond | 243 | 155 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 27018984 | 27018984 | PRJNA688655_P_NODE_16382_length_241_cov_0.916667_g16317_i0 | PRJNA688655 | 16382 | 241 | 0.916667 | 2.20916747 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 152 | 3.36e-44 | NR | MDD5022075.1 | 2775028 | g16317 | i0 | 93.8 | 0.995850622406639 | 80 | 5 | 99.6 | 0 | 240 | 1 | 97 | 176 | MDD5022075.1 1-(5-phosphoribosyl)-5-[(5-phosphoribosylamino)methylideneamino]imidazole-4-carboxamide isomerase [Endomicrobiaceae bacterium] | diamond | 240 | 152 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 27271882 | 27271882 | PRJNA688655_P_NODE_11123_length_247_cov_0.885057_g11058_i0 | PRJNA688655 | 11123 | 247 | 0.885057 | 2.18609079 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 79.7 | 1.15e-16 | NR | MEA5000299.1 | 2775028 | g11058 | i0 | 62.7 | 1.4331983805668 | 59 | 22 | 71.7 | 0 | 70 | 246 | 1 | 59 | MEA5000299.1 superoxide dismutase [Ni] [Endomicrobiaceae bacterium] | diamond | 354 | 79.7 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 27271899 | 27271899 | PRJNA688655_P_NODE_4943_length_296_cov_1.381166_g4878_i0 | PRJNA688655 | 4943 | 296 | 1.381166 | 4.08825136 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 185 | 6.619999999999998e-54 | NR | MEA5000297.1 | 2775028 | g4878 | i0 | 92.9 | 0.993243243243243 | 98 | 7 | 99.3 | 0 | 295 | 2 | 261 | 358 | MEA5000297.1 phytoene desaturase family protein [Endomicrobiaceae bacterium] | diamond | 294 | 185 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 27461640 | 27461640 | PRJNA688655_P_NODE_5103_length_293_cov_1.400000_g5038_i0 | PRJNA688655 | 5103 | 293 | 1.4 | 4.102 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 73.9 | 7.36e-13 | NR | MDD3730728.1 | 2775028 | g5038 | i0 | 67 | 1.98634812286689 | 97 | 32 | 99.3 | 0 | 293 | 3 | 8 | 104 | MDD3730728.1 hypothetical protein [Endomicrobiaceae bacterium] | diamond | 582 | 73.9 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 28661362 | 28661362 | PRJNA688655_P_NODE_11987_length_246_cov_0.890173_g11922_i0 | PRJNA688655 | 11987 | 246 | 0.890173 | 2.18982558 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 118 | 8.640000000000001e-29 | NR | MEA5000596.1 | 2775028 | g11922 | i0 | 100 | 0.75609756097561 | 62 | 0 | 75.6 | 0 | 186 | 1 | 1 | 62 | MEA5000596.1 OmpA family protein [Endomicrobiaceae bacterium] | diamond | 186 | 118 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 28787394 | 28787394 | PRJNA688655_P_NODE_14807_length_243_cov_0.905882_g14742_i0 | PRJNA688655 | 14807 | 243 | 0.905882 | 2.20129326 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 108 | 3.68e-25 | NR | MBO7431801.1 | 2030800 | g14742 | i0 | 64.2 | 1 | 81 | 29 | 100 | 0 | 1 | 243 | 2208 | 2288 | MBO7431801.1 hypothetical protein [Elusimicrobiota bacterium] | diamond | 243 | 108 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 28945690 | 28945690 | PRJNA688655_P_NODE_10948_length_247_cov_0.885057_g10883_i0 | PRJNA688655 | 10948 | 247 | 0.885057 | 2.18609079 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 170 | 1.05e-48 | NR | MEA5000534.1 | 2775028 | g10883 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 1 | 246 | 41 | 122 | MEA5000534.1 monomeric [FeFe] hydrogenase [Endomicrobiaceae bacterium] | diamond | 246 | 170 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 29071920 | 29071920 | PRJNA688655_P_NODE_15448_length_242_cov_0.911243_g15383_i0 | PRJNA688655 | 15448 | 242 | 0.911243 | 2.20520806 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 155 | 1.37e-44 | NR | NLE91347.1 | 2030800 | g15383 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 133 | 212 | NLE91347.1 4-hydroxy-tetrahydrodipicolinate synthase [Elusimicrobiota bacterium] | diamond | 240 | 155 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 30113750 | 30113750 | PRJNA688655_P_NODE_10872_length_247_cov_0.885057_g10807_i0 | PRJNA688655 | 10872 | 247 | 0.885057 | 2.18609079 | Elusimicrobiaceae bacterium | 2735568 | Bacteria | Bacteria | 115 | 1.8e-30 | NR | MBR2081805.1 | 2735568 | g10807 | i0 | 81 | 3.87449392712551 | 79 | 15 | 96 | 0 | 242 | 6 | 40 | 118 | MBR2081805.1 hypothetical protein [Elusimicrobiaceae bacterium] | diamond | 957 | 115 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobia | Elusimicrobiales | Elusimicrobiaceae | Elusimicrobiaceae bacterium | |||
| 30176933 | 30176933 | PRJNA688655_P_NODE_13032_length_245_cov_0.895349_g12967_i0 | PRJNA688655 | 13032 | 245 | 0.895349 | 2.19360505 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 167 | 6.03e-46 | NR | MDD3730019.1 | 2775028 | g12967 | i0 | 98.8 | 1.98367346938776 | 81 | 1 | 99.2 | 0 | 243 | 1 | 1522 | 1602 | MDD3730019.1 hypothetical protein [Endomicrobiaceae bacterium] | diamond | 486 | 167 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 30220134 | 30220134 | PRJNA688655_P_NODE_15672_length_242_cov_0.911243_g15607_i0 | PRJNA688655 | 15672 | 242 | 0.911243 | 2.20520806 | Bacteria | 2 | Bacteria | Bacteria | 140 | 1.02e-38 | NR | MFA6614369.1 | 2660713 | g15607 | i0 | 93.8 | 1.98347107438017 | 80 | 5 | 99.2 | 0 | 242 | 3 | 219 | 298 | MFA6614369.1 efflux RND transporter permease subunit [Endomicrobiia bacterium] | diamond | 480 | 140 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiia bacterium | |||||
| 30461851 | 30461851 | PRJNA688655_P_NODE_8173_length_251_cov_0.865169_g8108_i0 | PRJNA688655 | 8173 | 251 | 0.865169 | 2.17157419 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 144 | 5.68e-38 | NR | MDD3065311.1 | 2775028 | g8108 | i0 | 91.6 | 1.9840637450199201 | 83 | 7 | 99.2 | 0 | 2 | 250 | 451 | 533 | MDD3065311.1 hypothetical protein [Endomicrobiaceae bacterium] | diamond | 498 | 144 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 30473082 | 30473082 | PRJNA688655_P_NODE_16433_length_241_cov_0.916667_g16368_i0 | PRJNA688655 | 16433 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 5.88e-13 | NR | MFA6613520.1 | 2660713 | g16368 | i0 | 50 | 3.63485477178423 | 68 | 34 | 84.6 | 0 | 18 | 221 | 255 | 322 | MFA6613520.1 O-antigen ligase family protein [Endomicrobiia bacterium] | diamond | 876 | 73.2 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiia bacterium | |||||
| 30587630 | 30587630 | PRJNA688655_P_NODE_15013_length_243_cov_0.905882_g14948_i0 | PRJNA688655 | 15013 | 243 | 0.905882 | 2.20129326 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 126 | 5.05e-33 | NR | MDD3730313.1 | 2775028 | g14948 | i0 | 100 | 1.48148148148148 | 60 | 0 | 74.1 | 0 | 180 | 1 | 1 | 60 | MDD3730313.1 U32 family peptidase [Endomicrobiaceae bacterium] | diamond | 360 | 126 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 30587635 | 30587635 | PRJNA688655_P_NODE_16513_length_241_cov_0.916667_g16448_i0 | PRJNA688655 | 16513 | 241 | 0.916667 | 2.20916747 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 143 | 1.74e-37 | NR | MDD3065606.1 | 2775028 | g16448 | i0 | 97.5 | 2.95020746887967 | 79 | 2 | 98.3 | 0 | 239 | 3 | 897 | 975 | MDD3065606.1 hypothetical protein [Endomicrobiaceae bacterium] | diamond | 711 | 143 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 30998588 | 30998588 | PRJNA688655_P_NODE_3314_length_336_cov_0.798479_g3249_i0 | PRJNA688655 | 3314 | 336 | 0.798479 | 2.68288944 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 186 | 1.14e-53 | NR | MDD3064906.1 | 2775028 | g3249 | i0 | 93.3 | 0.9375 | 105 | 7 | 93.8 | 0 | 22 | 336 | 1 | 105 | MDD3064906.1 radical SAM protein [Endomicrobiaceae bacterium] | diamond | 315 | 186 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 31030387 | 31030387 | PRJNA688655_P_NODE_8695_length_250_cov_0.870056_g8630_i0 | PRJNA688655 | 8695 | 250 | 0.870056 | 2.17514 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 153 | 1.74e-41 | NR | MDD4166853.1 | 2775028 | g8630 | i0 | 100 | 2.988 | 83 | 0 | 99.6 | 0 | 249 | 1 | 551 | 633 | MDD4166853.1 hypothetical protein [Endomicrobiaceae bacterium] | diamond | 747 | 153 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae bacterium | |||
| 31377969 | 31377969 | PRJNA688655_P_NODE_6136_length_274_cov_1.532338_g6071_i0 | PRJNA688655 | 6136 | 274 | 1.532338 | 4.19860612 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 53.9 | 5.01e-6 | NR | MEW6557198.1 | 2030800 | g6071 | i0 | 39 | 0.897810218978102 | 82 | 45 | 85.4 | 2 | 235 | 2 | 180 | 260 | MEW6557198.1 ATP-binding protein [Elusimicrobiota bacterium] | diamond | 246 | 53.9 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 31536199 | 31536199 | PRJNA688655_P_NODE_12036_length_246_cov_0.890173_g11971_i0 | PRJNA688655 | 12036 | 246 | 0.890173 | 2.18982558 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 164 | 1.55e-47 | NR | NLE91701.1 | 2030800 | g11971 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 194 | 274 | NLE91701.1 FAD-dependent oxidoreductase [Elusimicrobiota bacterium] | diamond | 243 | 164 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 31852164 | 31852164 | PRJNA688655_P_NODE_11917_length_246_cov_0.890173_g11852_i0 | PRJNA688655 | 11917 | 246 | 0.890173 | 2.18982558 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 157 | 3.88e-45 | NR | NLE91700.1 | 2030800 | g11852 | i0 | 98.8 | 0.98780487804878 | 81 | 1 | 98.8 | 0 | 2 | 244 | 212 | 292 | NLE91700.1 UDP-glucose 4-epimerase GalE [Elusimicrobiota bacterium] | diamond | 243 | 157 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 31978790 | 31978790 | PRJNA688655_P_NODE_15138_length_242_cov_0.911243_g15073_i0 | PRJNA688655 | 15138 | 242 | 0.911243 | 2.20520806 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 135 | 4.74e-38 | NR | NLE91785.1 | 2030800 | g15073 | i0 | 100 | 1.68595041322314 | 68 | 0 | 84.3 | 0 | 240 | 37 | 134 | 201 | NLE91785.1 penicillin-binding protein activator LpoB [Elusimicrobiota bacterium] | diamond | 408 | 135 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 32042166 | 32042166 | PRJNA688655_P_NODE_14558_length_243_cov_0.905882_g14493_i0 | PRJNA688655 | 14558 | 243 | 0.905882 | 2.20129326 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 99.4 | 4.42e-22 | NR | MCG3203663.1 | 2030800 | g14493 | i0 | 72.1 | 0.839506172839506 | 68 | 19 | 84 | 0 | 232 | 29 | 192 | 259 | MCG3203663.1 Elongation factor 4 [Elusimicrobiota bacterium] | diamond | 204 | 99.4 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 32674231 | 32674231 | PRJNA688655_P_NODE_7920_length_251_cov_0.865169_g7855_i0 | PRJNA688655 | 7920 | 251 | 0.865169 | 2.17157419 | Endomicrobiaceae bacterium | 2775028 | Bacteria | Bacteria | 108 | 2.29e-25 | NR | MDD3064943.1 | 2775028 | g7855 | i0 | 98.2 | 0.669322709163347 | 56 | 1 | 66.9 | 0 | 168 | 1 | 1 | 56 | MDD3064943.1 S1 RNA-binding domain-containing protein [Endomicrobiaceae bacterium] | diamond | 168 | 108 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Endomicrobiia | Endomicrobiales | Endomicrobiaceae | Endomicrobiaceae 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);;