contig_metadata
14 rows where analysis = "diamond" and bioproject = "PRJNA727760"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4541063 | 4541063 | PRJNA727760_S_NODE_1704_length_351_cov_1.687050_g1676_i0 | PRJNA727760 | 1704 | 351 | 1.68705 | 5.9215455 | Porphyrobacter sp. GA68 | 2883480 | Bacteria | Bacteria | 96.7 | 1.18e-20 | NR | WP_228244238.1 | 2883480 | g1676 | i0 | 96.2 | 0.452991452991453 | 53 | 2 | 45.3 | 0 | 44 | 202 | 5 | 57 | WP_228244238.1 alpha/beta fold hydrolase [Porphyrobacter sp. GA68] | diamond | 159 | 96.7 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Sphingomonadales | Erythrobacteraceae | Porphyrobacter | Porphyrobacter sp. GA68 | ||
| 27716103 | 27716103 | PRJNA727760_S_NODE_2544_length_285_cov_1.561321_g2516_i0 | PRJNA727760 | 2544 | 285 | 1.561321 | 4.44976485 | Malassezia restricta CBS 7877 | 425264 | Fungi | Fungi | 118 | 6.229999999999999e-31 | NR | AYO44820.1 | 425264 | g2516 | i0 | 71.1 | 0.947368421052632 | 90 | 26 | 94.7 | 0 | 283 | 14 | 61 | 150 | AYO44820.1 heat shock protein GrpE [Malassezia restricta CBS 7877] | diamond | 270 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28104746 | 28104746 | PRJNA727760_S_NODE_2505_length_288_cov_0.934884_g2477_i0 | PRJNA727760 | 2505 | 288 | 0.934884 | 2.69246592 | Microbotryomycetes | 162481 | Fungi | Fungi | 60.5 | 6.06e-9 | NR | GAA5898551.1 | 183962 | g2477 | i0 | 75.5 | 2.86458333333333 | 49 | 4 | 44.8 | 3 | 286 | 158 | 110 | 156 | GAA5898551.1 hypothetical protein JCM6883_003349 [Sporobolomyces salmoneus] | diamond | 825 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmoneus | |
| 28189059 | 28189059 | PRJNA727760_S_NODE_3246_length_256_cov_1.704918_g3218_i0 | PRJNA727760 | 3246 | 256 | 1.704918 | 4.36459008 | Eolophus roseicapilla | 176039 | Chordata | Chordata | 55.5 | 1.36e-6 | NR | NXD65386.1 | 176039 | g3218 | i0 | 52.5 | 0.71484375 | 61 | 29 | 71.5 | 0 | 254 | 72 | 288 | 348 | NXD65386.1 IDHP dehydrogenase [Eolophus roseicapilla] | diamond | 183 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Cacatuidae | Eolophus | Eolophus roseicapilla | |
| 29052270 | 29052270 | PRJNA727760_S_NODE_1428_length_385_cov_6.169872_g1400_i0 | PRJNA727760 | 1428 | 385 | 6.169872 | 23.7540072 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 4.16e-5 | NR | GBN61280.1 | 182803 | g1400 | i0 | 50.9 | 3.8025974025974 | 53 | 26 | 41.3 | 0 | 269 | 111 | 1136 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 1464 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 29262618 | 29262618 | PRJNA727760_S_NODE_2669_length_279_cov_1.893204_g2641_i0 | PRJNA727760 | 2669 | 279 | 1.893204 | 5.28203916 | Sarocladium strictum | 5046 | Fungi | Fungi | 58.9 | 1.08e-7 | NR | KAL2213322.1 | 5046 | g2641 | i0 | 47.8 | 0.741935483870968 | 69 | 25 | 67.7 | 2 | 12 | 200 | 325 | 388 | KAL2213322.1 concanavalin A-like lectin/glucanase [Sarocladium strictum] | diamond | 207 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29714814 | 29714814 | PRJNA727760_S_NODE_3610_length_246_cov_1.381503_g3582_i0 | PRJNA727760 | 3610 | 246 | 1.381503 | 3.39849738 | synthetic construct | 32630 | Root_unresolved | Root_unresolved | 90.1 | 7.59e-19 | NR | QPD90060.1 | 32630 | g3582 | i0 | 72.6 | 11.5243902439024 | 62 | 17 | 75.6 | 0 | 1 | 186 | 186 | 247 | QPD90060.1 G-GESS [synthetic construct] | diamond | 2835 | 90.1 | 1 | synthetic construct | |||||||||
| 29767924 | 29767924 | PRJNA727760_S_NODE_2491_length_288_cov_1.813953_g2463_i0 | PRJNA727760 | 2491 | 288 | 1.813953 | 5.22418464 | Knufia fluminis | 191047 | Fungi | Fungi | 80.1 | 7.77e-17 | NR | KAK5953335.1 | 191047 | g2463 | i0 | 62.8 | 0.8125 | 78 | 21 | 72.9 | 1 | 287 | 78 | 53 | 130 | KAK5953335.1 hypothetical protein OHC33_005903 [Knufia fluminis] | diamond | 234 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia fluminis | |
| 29926095 | 29926095 | PRJNA727760_S_NODE_1631_length_361_cov_1.083333_g1603_i0 | PRJNA727760 | 1631 | 361 | 1.083333 | 3.91083213 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 68.9 | 9.7e-11 | NR | XP_018181215.1 | 33203 | g1603 | i0 | 89.1 | 0.914127423822715 | 55 | 6 | 45.7 | 0 | 361 | 197 | 813 | 867 | XP_018181215.1 translation initiation factor 3 subunit c [Purpureocillium lilacinum] | diamond | 330 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 30431873 | 30431873 | PRJNA727760_S_NODE_1193_length_429_cov_1.558989_g1165_i0 | PRJNA727760 | 1193 | 429 | 1.558989 | 6.68806281 | Sarocladium strictum | 5046 | Fungi | Fungi | 137 | 6.74e-39 | NR | KAK0385092.1 | 5046 | g1165 | i0 | 95.3 | 0.741258741258741 | 106 | 2 | 72 | 1 | 429 | 121 | 17 | 122 | KAK0385092.1 hypothetical protein NLU13_7570 [Sarocladium strictum] | diamond | 318 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31157796 | 31157796 | PRJNA727760_S_NODE_3375_length_252_cov_1.284916_g3347_i0 | PRJNA727760 | 3375 | 252 | 1.284916 | 3.23798832 | Talaromyces marneffei | 37727 | Fungi | Fungi | 57 | 1.65e-8 | NR | XP_054121538.1 | 37727 | g3347 | i0 | 46.4 | 0.821428571428571 | 69 | 34 | 82.1 | 1 | 252 | 46 | 8 | 73 | XP_054121538.1 uncharacterized protein EYB26_006287 [Talaromyces marneffei] | diamond | 207 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 31664041 | 31664041 | PRJNA727760_S_NODE_3637_length_246_cov_0.901734_g3609_i0 | PRJNA727760 | 3637 | 246 | 0.901734 | 2.21826564 | Malassezia psittaci | 1821823 | Fungi | Fungi | 60.5 | 7.19e-9 | NR | WFD42247.1 | 1821823 | g3609 | i0 | 43 | 0.963414634146341 | 79 | 32 | 80.5 | 2 | 5 | 202 | 119 | 197 | WFD42247.1 hypothetical protein MPSI1_000888 [Malassezia psittaci] | diamond | 237 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia psittaci | |
| 31822168 | 31822168 | PRJNA727760_S_NODE_2557_length_284_cov_3.322275_g2529_i0 | PRJNA727760 | 2557 | 284 | 3.322275 | 9.435261 | Sarocladium strictum | 5046 | Fungi | Fungi | 92 | 3.8e-21 | NR | KAK0386860.1 | 5046 | g2529 | i0 | 86.4 | 0.623239436619718 | 59 | 8 | 62.3 | 0 | 280 | 104 | 107 | 165 | KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum] | diamond | 177 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 32297313 | 32297313 | PRJNA727760_S_NODE_1659_length_357_cov_4.971831_g1631_i0 | PRJNA727760 | 1659 | 357 | 4.971831 | 17.74943667 | Pseudomonas syringae group genomosp. 7 | 251699 | Bacteria | Bacteria | 43.9 | 0.0117 | NR | WP_395587240.1 | 251699 | g1631 | i0 | 48.7 | 0.65546218487395 | 78 | 22 | 58.8 | 8 | 115 | 324 | 4 | 71 | WP_395587240.1 hypothetical protein [Pseudomonas syringae group genomosp. 7] | diamond | 234 | 43.9 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Pseudomonadales | Pseudomonadaceae | Pseudomonas | Pseudomonas syringae group genomosp. 7 |
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);;