contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26662126 | 26662126 | PRJNA193544_S_NODE_1141_length_239_cov_5.390476_g1126_i0 | PRJNA193544 | 1141 | 239 | 5.390476 | 12.88323764 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 50.4 | 2.5e-5 | NR | EIW67481.1 | 578456 | g1126 | i0 | 63.9 | 0.451882845188285 | 36 | 13 | 45.2 | 0 | 122 | 229 | 125 | 160 | EIW67481.1 hypothetical protein TREMEDRAFT_33574 [Tremella mesenterica DSM 1558] | diamond | 108 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica | |
| 26947288 | 26947288 | PRJNA193544_S_NODE_1742_length_202_cov_6.560694_g1727_i0 | PRJNA193544 | 1742 | 202 | 6.560694 | 13.25260188 | Elysia crispata | 231223 | Mollusca | Mollusca | 52 | 7.76e-6 | NR | KAK3745166.1 | 231223 | g1727 | i0 | 58.5 | 0.608910891089109 | 41 | 17 | 60.9 | 0 | 4 | 126 | 95 | 135 | KAK3745166.1 hypothetical protein RRG08_062993 [Elysia crispata] | diamond | 123 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 27629014 | 27629014 | PRJNA193544_S_NODE_2284_length_181_cov_7.736842_g2269_i0 | PRJNA193544 | 2284 | 181 | 7.736842 | 14.00368402 | Onchocercidae | 6296 | Nematoda | Nematoda | 69.7 | 4.22e-12 | NR | MCP9265034.1 | 6287 | g2269 | i0 | 69.4 | 4.92265193370166 | 49 | 15 | 81.2 | 0 | 33 | 179 | 63 | 111 | MCP9265034.1 Alpha-l1 nicotinic acetyl choline receptor [Dirofilaria immitis] | diamond | 891 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 28400391 | 28400391 | PRJNA193544_S_NODE_2126_length_186_cov_570.751592_g2111_i0 | PRJNA193544 | 2126 | 186 | 570.751592 | 1061.59796112 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 48.1 | 1.14e-5 | NR | RKP19416.1 | 988480 | g2111 | i0 | 66.7 | 0.532258064516129 | 33 | 11 | 53.2 | 0 | 68 | 166 | 8 | 40 | RKP19416.1 hypothetical protein ROZALSC1DRAFT_14013, partial [Rozella allomycis CSF55] | diamond | 99 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28653009 | 28653009 | PRJNA193544_S_NODE_467_length_323_cov_14.707483_g452_i0 | PRJNA193544 | 467 | 323 | 14.707483 | 47.50517009 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 63.2 | 8.69e-10 | NR | VDM04658.1 | 70667 | g452 | i0 | 59.6 | 0.947368421052632 | 52 | 18 | 48.3 | 1 | 134 | 289 | 76 | 124 | VDM04658.1 unnamed protein product [Schistocephalus solidus] | diamond | 306 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 30249951 | 30249951 | PRJNA193544_S_NODE_2152_length_185_cov_15.910256_g2137_i0 | PRJNA193544 | 2152 | 185 | 15.910256 | 29.4339736 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 40.4 | 0.041 | NR | KAA3673245.1 | 34504 | g2137 | i0 | 69 | 2.05945945945946 | 29 | 9 | 47 | 0 | 87 | 1 | 46 | 74 | KAA3673245.1 uncharacterized protein DEA37_0011152 [Paragonimus westermani] | diamond | 381 | 40.8 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 30295524 | 30295524 | PRJNA193544_S_NODE_3272_length_154_cov_16.336000_g3257_i0 | PRJNA193544 | 3272 | 154 | 16.336 | 25.15744 | Thermothelomyces fergusii | 2588716 | Fungi | Fungi | 52 | 2.11e-6 | NR | KAL2161104.1 | 2588716 | g3257 | i0 | 50.9 | 5.31818181818182 | 53 | 24 | 99.4 | 1 | 153 | 1 | 48 | 100 | KAL2161104.1 hypothetical protein VTH06DRAFT_8817 [Thermothelomyces fergusii] | diamond | 819 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothelomyces | Thermothelomyces fergusii | |
| 30927220 | 30927220 | PRJNA193544_S_NODE_1134_length_240_cov_5.393365_g1119_i0 | PRJNA193544 | 1134 | 240 | 5.393365 | 12.944076 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 58.5 | 3.88e-9 | NR | KAH8175438.1 | 1610689 | g1119 | i0 | 49.4 | 1.0125 | 81 | 34 | 97.5 | 3 | 7 | 240 | 5 | 81 | KAH8175438.1 hypothetical protein LIA77_03856 [Sarocladium implicatum] | diamond | 243 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 31071329 | 31071329 | PRJNA193544_S_NODE_3195_length_156_cov_4.535433_g3180_i0 | PRJNA193544 | 3195 | 156 | 4.535433 | 7.07527548 | Elysia | 71493 | Mollusca | Mollusca | 42 | 0.0208 | NR | RUS72982.1 | 188477 | g3180 | i0 | 61.3 | 2.38461538461538 | 31 | 12 | 59.6 | 0 | 62 | 154 | 144 | 174 | RUS72982.1 hypothetical protein EGW08_019265, partial [Elysia chlorotica] | diamond | 372 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 31085016 | 31085016 | PRJNA193544_S_NODE_995_length_251_cov_19.842342_g980_i0 | PRJNA193544 | 995 | 251 | 19.842342 | 49.80427842 | Linnemannia gamsii | 64522 | Fungi | Fungi | 42 | 0.0336 | NR | KAG0283656.1 | 64522 | g980 | i0 | 31.8 | 0.788844621513944 | 66 | 40 | 78.9 | 2 | 1 | 198 | 66 | 126 | KAG0283656.1 hypothetical protein BGZ97_008457, partial [Linnemannia gamsii] | diamond | 198 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia gamsii | |
| 31432739 | 31432739 | PRJNA193544_S_NODE_1056_length_246_cov_13.760369_g1041_i0 | PRJNA193544 | 1056 | 246 | 13.760369 | 33.85050774 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 54.7 | 2.07e-7 | NR | KAL1914197.1 | 911321 | g1041 | i0 | 53.4 | 0.707317073170732 | 58 | 26 | 70.7 | 1 | 243 | 70 | 9 | 65 | KAL1914197.1 hypothetical protein VTP21DRAFT_9681 [Calcarisporiella thermophila] | diamond | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 32065390 | 32065390 | PRJNA193544_S_NODE_1798_length_200_cov_3.508772_g1783_i0 | PRJNA193544 | 1798 | 200 | 3.508772 | 7.017544 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 44.7 | 0.00276 | NR | KAL1932413.1 | 4840 | g1783 | i0 | 54.8 | 0.63 | 42 | 19 | 63 | 0 | 47 | 172 | 103 | 144 | KAL1932413.1 hypothetical protein VTP01DRAFT_9469 [Rhizomucor pusillus] | diamond | 126 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 32571901 | 32571901 | PRJNA193544_S_NODE_239_length_380_cov_10.467236_g224_i0 | PRJNA193544 | 239 | 380 | 10.467236 | 39.7754968 | Claviceps pusilla | 123648 | Fungi | Fungi | 62.4 | 1.02e-9 | NR | KAG5993183.1 | 123648 | g224 | i0 | 43.3 | 0.710526315789474 | 90 | 49 | 71.1 | 1 | 111 | 380 | 12 | 99 | KAG5993183.1 hypothetical protein E4U43_003579, partial [Claviceps pusilla] | diamond | 270 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Claviceps | Claviceps pusilla | |
| 32778195 | 32778195 | PRJNA193544_S_NODE_660_length_293_cov_8.943182_g645_i0 | PRJNA193544 | 660 | 293 | 8.943182 | 26.20352326 | Penicillium | 5073 | Fungi | Fungi | 55.8 | 2.79e-7 | NR | KAJ5598932.1 | 94218 | g645 | i0 | 49.3 | 1.45392491467577 | 71 | 36 | 72.7 | 0 | 38 | 250 | 32 | 102 | KAJ5598932.1 hypothetical protein N7510_011882, partial [Penicillium lagena] | diamond | 426 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium lagena |
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);;