contig_metadata
28 rows where analysis = "diamond" and bioproject = "PRJNA314497"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16958014 | 16958014 | PRJNA314497_S_NODE_474_length_349_cov_8.743750_g451_i0 | PRJNA314497 | 474 | 349 | 8.74375 | 30.5156875 | Culicoides brevitarsis | 469753 | Arthropoda | Arthropoda | 187 | 1.84e-59 | NR | XP_063703218.1 | 469753 | g451 | i0 | 89.9 | 0.851002865329513 | 99 | 10 | 85.1 | 0 | 14 | 310 | 1 | 99 | XP_063703218.1 ATP synthase subunit g, mitochondrial [Culicoides brevitarsis] | diamond | 297 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Ceratopogonidae | Culicoides | Culicoides brevitarsis | |
| 23332624 | 23332624 | PRJNA314497_P_NODE_1199_length_512_cov_2.198758_g1061_i0 | PRJNA314497 | 1199 | 512 | 2.198758 | 11.25764096 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 367 | 1.28e-123 | NR | MBK6986222.1 | 1898104 | g1061 | i0 | 99.4 | 2.98828125 | 170 | 1 | 99.6 | 0 | 3 | 512 | 341 | 510 | MBK6986222.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Bacteroidota bacterium] | diamond | 1530 | 367 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 24606676 | 24606676 | PRJNA314497_S_NODE_20_length_1327_cov_7.984592_g15_i0 | PRJNA314497 | 20 | 1327 | 7.984592 | 105.95553584 | unclassified Undibacterium | 2630295 | Bacteria | Bacteria | 323 | 4.27e-100 | NR | WP_322119055.1 | 2630295 | g15 | i0 | 63.4 | 1.81763376036172 | 279 | 95 | 61.9 | 4 | 828 | 7 | 1 | 277 | WP_322119055.1 MULTISPECIES: chemotaxis protein CheA [unclassified Undibacterium] | diamond | 2412 | 323 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Oxalobacteraceae | Undibacterium | |||
| 26599186 | 26599186 | PRJNA314497_P_NODE_1281_length_492_cov_3.382289_g1142_i0 | PRJNA314497 | 1281 | 492 | 3.382289 | 16.64086188 | Elsinoe fawcettii | 40997 | Fungi | Fungi | 117 | 5.37e-27 | NR | KAF4547717.1 | 40997 | g1142 | i0 | 42 | 1.68292682926829 | 138 | 80 | 84.1 | 0 | 4 | 417 | 2349 | 2486 | KAF4547717.1 AMP-binding enzyme 2 [Elsinoe fawcettii] | diamond | 828 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Myriangiales | Elsinoaceae | Elsinoe | Elsinoe fawcettii | |
| 26599187 | 26599187 | PRJNA314497_P_NODE_2881_length_306_cov_2.267148_g2730_i0 | PRJNA314497 | 2881 | 306 | 2.267148 | 6.93747288 | Pasteurella skyensis | 97481 | Bacteria | Bacteria | 135 | 5.37e-37 | NR | WP_306400629.1 | 97481 | g2730 | i0 | 65.3 | 4.72549019607843 | 95 | 33 | 93.1 | 0 | 293 | 9 | 11 | 105 | WP_306400629.1 IS256 family transposase, variant Zn-binding type, partial [Pasteurella skyensis] | diamond | 1446 | 135 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Pasteurellales | Pasteurellaceae | Phocoenobacter | Phocoenobacter skyensis | ||
| 26631189 | 26631189 | PRJNA314497_S_NODE_1521_length_179_cov_2.480000_g1498_i0 | PRJNA314497 | 1521 | 179 | 2.48 | 4.4392 | Barbourula kalimantanensis | 877557 | Chordata | Chordata | 95.5 | 1.04e-22 | NR | ADW79448.1 | 877557 | g1498 | i0 | 97.9 | 904.206703910615 | 48 | 1 | 80.4 | 0 | 178 | 35 | 103 | 150 | ADW79448.1 cytochrome oxidase subunit I, partial [Barbourula kalimantanensis] | diamond | 161853 | 96.3 | 0.991692627206646 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Barbourula | Barbourula kalimantanensis | |
| 27516704 | 27516704 | PRJNA314497_S_NODE_1923_length_159_cov_1.923077_g1900_i0 | PRJNA314497 | 1923 | 159 | 1.923077 | 3.05769243 | Helicobacter pylori | 210 | Bacteria | Bacteria | 68.2 | 8.14e-14 | NR | GAA8554817.1 | 210 | g1900 | i0 | 80 | 0.754716981132076 | 40 | 8 | 75.5 | 0 | 122 | 3 | 4 | 43 | GAA8554817.1 hypothetical protein KYTH17_15160 [Helicobacter pylori] | diamond | 120 | 68.2 | 1 | Bacteria | Pseudomonadati | Campylobacterota | Epsilonproteobacteria | Campylobacterales | Helicobacteraceae | Helicobacter | Helicobacter pylori | ||
| 27579765 | 27579765 | PRJNA314497_P_NODE_3044_length_295_cov_3.338346_g2892_i0 | PRJNA314497 | 3044 | 295 | 3.338346 | 9.8481207 | Geminicoccus harenae | 2498453 | Bacteria | Bacteria | 52 | 1.91e-6 | NR | WP_222185125.1 | 2498453 | g2892 | i0 | 95.5 | 0.223728813559322 | 22 | 1 | 22.4 | 0 | 293 | 228 | 1 | 22 | WP_222185125.1 hypothetical protein, partial [Geminicoccus harenae] | diamond | 66 | 52 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Geminicoccales | Geminicoccaceae | Geminicoccus | Geminicoccus harenae | ||
| 28116508 | 28116508 | PRJNA314497_S_NODE_1225_length_205_cov_2.732955_g1202_i0 | PRJNA314497 | 1225 | 205 | 2.732955 | 5.60255775 | Lawsonella | 1847725 | Bacteria | Bacteria | 121 | 3.46e-33 | NR | WP_290595328.1 | 1847725 | g1202 | i0 | 100 | 0.878048780487805 | 60 | 0 | 87.8 | 0 | 205 | 26 | 99 | 158 | WP_290595328.1 MULTISPECIES: dUTP diphosphatase [Lawsonella] | diamond | 180 | 121 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | |||
| 28116509 | 28116509 | PRJNA314497_S_NODE_645_length_296_cov_6.209738_g622_i0 | PRJNA314497 | 645 | 296 | 6.209738 | 18.38082448 | Herbaspirillum rubrisubalbicans | 80842 | Bacteria | Bacteria | 60.1 | 3.48e-9 | NR | WP_237742021.1 | 80842 | g622 | i0 | 65.2 | 0.466216216216216 | 46 | 15 | 46.6 | 1 | 259 | 122 | 1 | 45 | WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] | diamond | 138 | 60.1 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Oxalobacteraceae | Herbaspirillum | Herbaspirillum rubrisubalbicans | ||
| 28242722 | 28242722 | PRJNA314497_S_NODE_2106_length_151_cov_2.344262_g2083_i0 | PRJNA314497 | 2106 | 151 | 2.344262 | 3.53983562 | Anaerococcus lactolyticus | 33032 | Bacteria | Bacteria | 93.6 | 1.32e-20 | NR | WP_004827534.1 | 33032 | g2083 | i0 | 87.8 | 0.973509933774834 | 49 | 6 | 97.4 | 0 | 150 | 4 | 3 | 51 | WP_004827534.1 heavy metal translocating P-type ATPase [Anaerococcus lactolyticus] | diamond | 147 | 93.6 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | Anaerococcus lactolyticus | ||
| 28274368 | 28274368 | PRJNA314497_S_NODE_126_length_621_cov_6.712838_g111_i0 | PRJNA314497 | 126 | 621 | 6.712838 | 41.68672398 | Mycena metata | 1033252 | Fungi | Fungi | 381 | 1.86e-131 | NR | KAJ7746270.1 | 1033252 | g111 | i0 | 97.4 | 0.927536231884058 | 192 | 5 | 92.8 | 0 | 2 | 577 | 105 | 296 | KAJ7746270.1 Arv1-like family-domain-containing protein [Mycena metata] | diamond | 576 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena metata | |
| 28621936 | 28621936 | PRJNA314497_S_NODE_507_length_338_cov_5.944984_g484_i0 | PRJNA314497 | 507 | 338 | 5.944984 | 20.09404592 | Herbaspirillum rubrisubalbicans | 80842 | Bacteria | Bacteria | 60.5 | 3.9e-9 | NR | WP_237742021.1 | 80842 | g484 | i0 | 67.9 | 0.470414201183432 | 53 | 15 | 47 | 1 | 106 | 264 | 2 | 52 | WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] | diamond | 159 | 60.5 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Oxalobacteraceae | Herbaspirillum | Herbaspirillum rubrisubalbicans | ||
| 29127229 | 29127229 | PRJNA314497_S_NODE_229_length_501_cov_7.108051_g208_i0 | PRJNA314497 | 229 | 501 | 7.108051 | 35.61133551 | bacterium | 1869227 | Bacteria | Bacteria | 97.4 | 1.27e-21 | NR | MFN9961035.1 | 1869227 | g208 | i0 | 62.1 | 0.395209580838323 | 66 | 25 | 39.5 | 0 | 303 | 500 | 1 | 66 | MFN9961035.1 hypothetical protein [bacterium] | diamond | 198 | 97.4 | 1 | Bacteria | bacterium | ||||||||
| 29348067 | 29348067 | PRJNA314497_P_NODE_3149_length_286_cov_2.190661_g2997_i0 | PRJNA314497 | 3149 | 286 | 2.190661 | 6.26529046 | Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14 | 1797697 | Bacteria | Bacteria | 89.4 | 2.64e-18 | NR | OGO93707.1 | 1797697 | g2997 | i0 | 44.4 | 13.4895104895105 | 99 | 51 | 99.7 | 1 | 285 | 1 | 382 | 480 | OGO93707.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpA [Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14] | diamond | 3858 | 89.4 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Legionellales | Coxiellaceae | Coxiella | Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14 | ||
| 29537383 | 29537383 | PRJNA314497_S_NODE_1770_length_165_cov_2.588235_g1747_i0 | PRJNA314497 | 1770 | 165 | 2.588235 | 4.27058775 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 105 | 1.43e-24 | NR | CAI9858976.1 | 3048757 | g1747 | i0 | 98.2 | 1 | 55 | 1 | 100 | 0 | 165 | 1 | 555 | 609 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 165 | 105 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 29916523 | 29916523 | PRJNA314497_P_NODE_3111_length_290_cov_1.854406_g2959_i0 | PRJNA314497 | 3111 | 290 | 1.854406 | 5.3777774 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47.8 | 9.46e-4 | NR | DAV81998.1 | 2832643 | g2959 | i0 | 35.6 | 0.755172413793103 | 73 | 46 | 74.5 | 1 | 282 | 67 | 15 | 87 | DAV81998.1 MAG TPA: anaerobic ribonucleoside triphosphate reductase [Caudoviricetes sp.] | diamond | 219 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30074176 | 30074176 | PRJNA314497_P_NODE_3992_length_209_cov_1.616667_g3840_i0 | PRJNA314497 | 3992 | 209 | 1.616667 | 3.37883403 | Quercus suber | 58331 | Plants | Plants | 55.8 | 5.24e-7 | NR | KAK7827634.1 | 58331 | g3840 | i0 | 74.2 | 2.22488038277512 | 31 | 5 | 40.2 | 1 | 3 | 86 | 295 | 325 | KAK7827634.1 basic form of pathogenesis-related protein 1 [Quercus suber] | diamond | 465 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus suber | |
| 30105808 | 30105808 | PRJNA314497_S_NODE_372_length_397_cov_6.013587_g349_i0 | PRJNA314497 | 372 | 397 | 6.013587 | 23.87394039 | Culicoides sonorensis | 179676 | Arthropoda | Arthropoda | 150 | 1.55e-44 | NR | AAU06505.1 | 179676 | g349 | i0 | 84.4 | 0.581863979848867 | 77 | 12 | 58.2 | 0 | 352 | 122 | 1 | 77 | AAU06505.1 unknown salivary protein [Culicoides sonorensis] | diamond | 231 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Ceratopogonidae | Culicoides | Culicoides sonorensis | |
| 30832585 | 30832585 | PRJNA314497_S_NODE_1834_length_162_cov_2.315789_g1811_i0 | PRJNA314497 | 1834 | 162 | 2.315789 | 3.75157818 | Peptoniphilus rhinitidis | 1175452 | Bacteria | Bacteria | 105 | 6.82e-25 | NR | WP_316715316.1 | 1175452 | g1811 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 161 | 3 | 467 | 519 | WP_316715316.1 preprotein translocase subunit SecA, partial [Peptoniphilus rhinitidis] | diamond | 159 | 105 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus rhinitidis | ||
| 31306593 | 31306593 | PRJNA314497_S_NODE_455_length_356_cov_6.348624_g432_i0 | PRJNA314497 | 455 | 356 | 6.348624 | 22.60110144 | Thrips palmi | 161013 | Arthropoda | Arthropoda | 48.1 | 0.00175 | NR | XP_034240145.1 | 161013 | g432 | i0 | 33.3 | 0.758426966292135 | 90 | 55 | 74.2 | 2 | 83 | 346 | 805 | 891 | XP_034240145.1 uncharacterized protein LOC117644643 [Thrips palmi] | diamond | 270 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Thysanoptera | Thripidae | Thrips | Thrips palmi | |
| 31703727 | 31703727 | PRJNA314497_S_NODE_1277_length_200_cov_2.736842_g1254_i0 | PRJNA314497 | 1277 | 200 | 2.736842 | 5.473684 | Chordata | 7711 | Chordata | Chordata | 99 | 2.81e-22 | NR | NP_033640.1 | 7748 | g1254 | i0 | 74.2 | 264.3 | 66 | 17 | 99 | 0 | 2 | 199 | 252 | 317 | NP_033640.1 cytochrome c oxidase subunit I [Lampetra fluviatilis] | diamond | 52860 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 31798394 | 31798394 | PRJNA314497_P_NODE_497_length_772_cov_5.759085_g406_i0 | PRJNA314497 | 497 | 772 | 5.759085 | 44.4601362 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.33e-22 | NR | XP_004367756.1 | 1257118 | g406 | i0 | 35.3 | 1.39507772020725 | 201 | 94 | 64.5 | 6 | 262 | 759 | 540 | 739 | XP_004367756.1 BAG domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 1077 | 109 | 0.990825688073395 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32097433 | 32097433 | PRJNA314497_P_NODE_3918_length_215_cov_1.682796_g3766_i0 | PRJNA314497 | 3918 | 215 | 1.682796 | 3.6180114 | Solanum lycopersicum | 4081 | Plants | Plants | 61.2 | 1.04e-9 | NR | XP_069148200.1 | 4081 | g3766 | i0 | 61.7 | 1.29767441860465 | 47 | 18 | 65.6 | 0 | 177 | 37 | 10 | 56 | XP_069148200.1 uncharacterized protein [Solanum lycopersicum] | diamond | 279 | 61.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 32192482 | 32192482 | PRJNA314497_S_NODE_1958_length_157_cov_2.234375_g1935_i0 | PRJNA314497 | 1958 | 157 | 2.234375 | 3.50796875 | Phyllosticta citricarpa | 55181 | Fungi | Fungi | 45.8 | 9.57e-4 | NR | KAK7540103.1 | 55181 | g1935 | i0 | 70.4 | 1.5477707006369399 | 27 | 8 | 51.6 | 0 | 2 | 82 | 569 | 595 | KAK7540103.1 hypothetical protein IWX46DRAFT_606636 [Phyllosticta citricarpa] | diamond | 243 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Phyllostictaceae | Phyllosticta | Phyllosticta citricarpa | |
| 32336708 | 32336708 | PRJNA314497_S_NODE_1519_length_179_cov_2.773333_g1496_i0 | PRJNA314497 | 1519 | 179 | 2.773333 | 4.96426607 | Marinobacter | 2742 | Bacteria | Bacteria | 117 | 5.57e-30 | NR | WP_273017580.1 | 83889 | g1496 | i0 | 91.5 | 4.94413407821229 | 59 | 5 | 98.9 | 0 | 2 | 178 | 74 | 132 | WP_273017580.1 MULTISPECIES: polysaccharide deacetylase family protein [unclassified Marinobacter] | diamond | 885 | 117 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Pseudomonadales | Marinobacteraceae | Marinobacter | |||
| 32666462 | 32666462 | PRJNA314497_P_NODE_4820_length_162_cov_1.654135_g4668_i0 | PRJNA314497 | 4820 | 162 | 1.654135 | 2.6796987 | Scheffersomyces stipitis | 4924 | Fungi | Fungi | 58.2 | 3.85e-8 | NR | KAG2732346.1 | 4924 | g4668 | i0 | 60 | 2.5 | 45 | 18 | 83.3 | 0 | 161 | 27 | 258 | 302 | KAG2732346.1 hypothetical protein G9P44_004763 [Scheffersomyces stipitis] | diamond | 405 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces stipitis | |
| 32760961 | 32760961 | PRJNA314497_S_NODE_980_length_236_cov_2.507246_g957_i0 | PRJNA314497 | 980 | 236 | 2.507246 | 5.91710056 | Eleutherodactylus atkinsi | 448426 | Chordata | Chordata | 88.6 | 2.32e-18 | NR | AGN71168.1 | 448426 | g957 | i0 | 97.5 | 14.7457627118644 | 40 | 1 | 50.8 | 0 | 102 | 221 | 410 | 449 | AGN71168.1 cytochrome c oxidase subunit I [Eleutherodactylus atkinsi] | diamond | 3480 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus atkinsi |
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);;