contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA734313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22394215 | 22394215 | PRJNA734313_S_NODE_10338_length_292_cov_1.232653_g10225_i0 | PRJNA734313 | 10338 | 292 | 1.232653 | 3.59934676 | root | 1 | Root_unresolved | Root_unresolved | 106 | 9.19e-27 | NR | EGT45232.1 | 135651 | g10225 | i0 | 75 | 7.92123287671233 | 64 | 16 | 65.8 | 0 | 291 | 100 | 108 | 171 | EGT45232.1 CBN-CYN-7 protein [Caenorhabditis brenneri] | diamond | 2313 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 22394226 | 22394226 | PRJNA734313_S_NODE_13298_length_258_cov_1.052133_g13185_i0 | PRJNA734313 | 13298 | 258 | 1.052133 | 2.71450314 | Ustilaginaceae | 5268 | Fungi | Fungi | 61.6 | 1.02e-8 | NR | CDS02184.1 | 49012 | g13185 | i0 | 41.5 | 5.63953488372093 | 65 | 38 | 75.6 | 0 | 33 | 227 | 1829 | 1893 | CDS02184.1 hypothetical protein [Sporisorium scitamineum] | diamond | 1455 | 62 | 0.993548387096774 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium scitamineum | |
| 26619405 | 26619405 | PRJNA734313_S_NODE_29301_length_170_cov_3.357724_g29188_i0 | PRJNA734313 | 29301 | 170 | 3.357724 | 5.7081308 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.00759 | NR | XP_062756889.1 | 173218 | g29188 | i0 | 54.3 | 1.18235294117647 | 35 | 16 | 61.8 | 0 | 7 | 111 | 1097 | 1131 | XP_062756889.1 uncharacterized protein Triagg1_4382 [Trichoderma aggressivum f. europaeum] | diamond | 201 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma aggressivum | |
| 26650847 | 26650847 | PRJNA734313_S_NODE_6481_length_359_cov_1.839744_g6368_i0 | PRJNA734313 | 6481 | 359 | 1.839744 | 6.60468096 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 6.05e-5 | NR | KUI67785.1 | 578113 | g6368 | i0 | 42.4 | 6.5933147632312 | 59 | 34 | 49.3 | 0 | 339 | 163 | 994 | 1052 | KUI67785.1 Protein MGA2 [Cytospora mali] | diamond | 2367 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cytosporaceae | Cytospora | Cytospora mali | |
| 26767579 | 26767579 | PRJNA734313_S_NODE_7921_length_329_cov_6.914894_g7808_i0 | PRJNA734313 | 7921 | 329 | 6.914894 | 22.75000126 | Chelonoidis abingdonii | 106734 | Chordata | Chordata | 43.9 | 0.0405 | NR | XP_032649260.1 | 106734 | g7808 | i0 | 38.7 | 0.683890577507599 | 75 | 40 | 62.9 | 1 | 33 | 239 | 1266 | 1340 | XP_032649260.1 zinc finger protein 804B isoform X1 [Chelonoidis abingdonii] | diamond | 225 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Testudinidae | Chelonoidis | Chelonoidis abingdonii | ||
| 26799168 | 26799168 | PRJNA734313_S_NODE_25521_length_184_cov_0.956204_g25408_i0 | PRJNA734313 | 25521 | 184 | 0.956204 | 1.75941536 | Mirounga angustirostris | 9716 | Chordata | Chordata | 45.4 | 0.00192 | NR | XP_064426076.1 | 9716 | g25408 | i0 | 67.7 | 0.505434782608696 | 31 | 10 | 50.5 | 0 | 93 | 1 | 30 | 60 | XP_064426076.1 protein ENTREP2 isoform X1 [Mirounga angustirostris] | diamond | 93 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga angustirostris | |
| 27062588 | 27062588 | PRJNA734313_S_NODE_16482_length_231_cov_1.663043_g16369_i0 | PRJNA734313 | 16482 | 231 | 1.663043 | 3.84162933 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.9 | 3.65e-6 | NR | ARX80207.1 | 35630 | g16369 | i0 | 46.2 | 2.06493506493507 | 52 | 28 | 67.5 | 0 | 8 | 163 | 728 | 779 | ARX80207.1 notch-a [Hydractinia echinata] | diamond | 477 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia echinata | |
| 27084049 | 27084049 | PRJNA734313_S_NODE_17962_length_221_cov_1.172414_g17849_i0 | PRJNA734313 | 17962 | 221 | 1.172414 | 2.59103494 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 57 | 2.59e-7 | NR | RWS31390.1 | 299467 | g17849 | i0 | 45 | 0.81447963800905 | 60 | 31 | 78.7 | 1 | 219 | 46 | 364 | 423 | RWS31390.1 uncharacterized protein B4U80_02538 [Leptotrombidium deliense] | diamond | 180 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 27210250 | 27210250 | PRJNA734313_S_NODE_9802_length_300_cov_1.584980_g9689_i0 | PRJNA734313 | 9802 | 300 | 1.58498 | 4.75494 | Patella caerulea | 87958 | Mollusca | Mollusca | 56.2 | 2.12e-7 | NR | KAK6168675.1 | 87958 | g9689 | i0 | 39.6 | 1.74 | 91 | 51 | 90 | 2 | 278 | 9 | 34 | 121 | KAK6168675.1 hypothetical protein SNE40_019866 [Patella caerulea] | diamond | 522 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 27347273 | 27347273 | PRJNA734313_S_NODE_26523_length_180_cov_1.150376_g26410_i0 | PRJNA734313 | 26523 | 180 | 1.150376 | 2.0706768 | Araneidae | 6913 | Arthropoda | Arthropoda | 90.9 | 7.61e-20 | NR | XP_055941438.1 | 94029 | g26410 | i0 | 62.7 | 3.93333333333333 | 59 | 22 | 98.3 | 0 | 2 | 178 | 300 | 358 | XP_055941438.1 protein SSUH2 homolog [Argiope bruennichi] | diamond | 708 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 28094713 | 28094713 | PRJNA734313_S_NODE_8965_length_313_cov_2.187970_g8852_i0 | PRJNA734313 | 8965 | 313 | 2.18797 | 6.8483461 | Leptopilina boulardi | 63433 | Arthropoda | Arthropoda | 55.8 | 2.13e-6 | NR | XP_051173332.1 | 63433 | g8852 | i0 | 29.7 | 0.87220447284345 | 91 | 55 | 87.2 | 2 | 312 | 40 | 38 | 119 | XP_051173332.1 ankyrin-1-like [Leptopilina boulardi] | diamond | 273 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Figitidae | Leptopilina | Leptopilina boulardi | |
| 29178585 | 29178585 | PRJNA734313_S_NODE_16589_length_230_cov_2.229508_g16476_i0 | PRJNA734313 | 16589 | 230 | 2.229508 | 5.1278684 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.9 | 2.01e-7 | NR | KAK2720597.1 | 6661 | g16476 | i0 | 37.3 | 2.60869565217391 | 67 | 42 | 87.4 | 0 | 230 | 30 | 10 | 76 | KAK2720597.1 hypothetical protein QYM36_004472 [Artemia franciscana] | diamond | 600 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 29357721 | 29357721 | PRJNA734313_S_NODE_32549_length_163_cov_1.318966_g32436_i0 | PRJNA734313 | 32549 | 163 | 1.318966 | 2.14991458 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 56.2 | 2.1e-7 | NR | CAH3029810.1 | 104178 | g32436 | i0 | 72.2 | 0.662576687116564 | 36 | 9 | 64.4 | 1 | 161 | 57 | 397 | 432 | CAH3029810.1 unnamed protein product [Porites evermanni] | diamond | 108 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 29452047 | 29452047 | PRJNA734313_S_NODE_10650_length_288_cov_1.481328_g10537_i0 | PRJNA734313 | 10650 | 288 | 1.481328 | 4.26622464 | Argiope bruennichi | 94029 | Arthropoda | Arthropoda | 117 | 2.9299999999999993e-28 | NR | XP_055928046.1 | 94029 | g10537 | i0 | 52.2 | 5.76041666666667 | 92 | 44 | 95.8 | 0 | 286 | 11 | 485 | 576 | XP_055928046.1 macrophage mannose receptor 1-like [Argiope bruennichi] | diamond | 1659 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 29494183 | 29494183 | PRJNA734313_S_NODE_20370_length_207_cov_0.956250_g20257_i0 | PRJNA734313 | 20370 | 207 | 0.95625 | 1.9794375 | Metazoa | 33208 | Arthropoda | Arthropoda | 62 | 3.85e-9 | NR | CAD7232757.1 | 163714 | g20257 | i0 | 46.4 | 2 | 69 | 36 | 98.6 | 1 | 4 | 207 | 55 | 123 | CAD7232757.1 unnamed protein product [Cyprideis torosa] | diamond | 414 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Cytherideidae | Cyprideis | Cyprideis torosa | |
| 29515324 | 29515324 | PRJNA734313_S_NODE_22070_length_198_cov_1.927152_g21957_i0 | PRJNA734313 | 22070 | 198 | 1.927152 | 3.81576096 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 60.5 | 1.19e-8 | NR | XP_070532596.1 | 63121 | g21957 | i0 | 50 | 1.45454545454545 | 48 | 24 | 72.7 | 0 | 1 | 144 | 122 | 169 | XP_070532596.1 uncharacterized abhydrolase domain-containing protein DDB_G0269086-like isoform X5 [Ptychodera flava] | diamond | 288 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 29704549 | 29704549 | PRJNA734313_S_NODE_22830_length_195_cov_1.033784_g22717_i0 | PRJNA734313 | 22830 | 195 | 1.033784 | 2.0158788 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 42 | 0.0374 | NR | CAF0712133.1 | 104777 | g22717 | i0 | 40.9 | 0.676923076923077 | 44 | 23 | 66.2 | 2 | 138 | 10 | 220 | 261 | CAF0712133.1 unnamed protein product [Brachionus calyciflorus] | diamond | 132 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29936360 | 29936360 | PRJNA734313_S_NODE_27811_length_175_cov_2.414062_g27698_i0 | PRJNA734313 | 27811 | 175 | 2.414062 | 4.2246085 | Eukaryota | 2759 | Fungi | Fungi | 79 | 2.59e-15 | NR | QID88496.1 | 27292 | g27698 | i0 | 66.1 | 3.87428571428571 | 56 | 19 | 96 | 0 | 4 | 171 | 537 | 592 | QID88496.1 glycyl-tRNA synthase [Saccharomyces pastorianus] | diamond | 678 | 79.7 | 0.991217063989962 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces pastorianus | |
| 29989242 | 29989242 | PRJNA734313_S_NODE_19951_length_209_cov_1.259259_g19838_i0 | PRJNA734313 | 19951 | 209 | 1.259259 | 2.63185131 | Capra hircus | 9925 | Chordata | Chordata | 55.8 | 5.73e-7 | NR | XDB48057.1 | 9925 | g19838 | i0 | 65.2 | 0.990430622009569 | 69 | 23 | 97.6 | 1 | 4 | 207 | 717 | 785 | XDB48057.1 hypothetical protein ABFV05_001673 [Capra hircus] | diamond | 207 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 29989248 | 29989248 | PRJNA734313_S_NODE_9631_length_303_cov_1.578125_g9518_i0 | PRJNA734313 | 9631 | 303 | 1.578125 | 4.78171875 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 110 | 1.31e-28 | NR | XP_033454825.1 | 1314786 | g9518 | i0 | 65.6 | 0.920792079207921 | 93 | 32 | 92.1 | 0 | 2 | 280 | 28 | 120 | XP_033454825.1 uncharacterized protein K489DRAFT_385514 [Dissoconium aciculare CBS 342.82] | diamond | 279 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 30463573 | 30463573 | PRJNA734313_S_NODE_3233_length_454_cov_12.825553_g3125_i0 | PRJNA734313 | 3233 | 454 | 12.825553 | 58.22801062 | Uroleucon formosanum | 796250 | Arthropoda | Arthropoda | 47.4 | 0.00703 | NR | KAL4119326.1 | 796250 | g3125 | i0 | 29.4 | 0.786343612334802 | 119 | 72 | 73.3 | 5 | 103 | 435 | 3 | 117 | KAL4119326.1 hypothetical protein QTP88_012147 [Uroleucon formosanum] | diamond | 357 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Uroleucon | Uroleucon formosanum | |
| 30726084 | 30726084 | PRJNA734313_S_NODE_35174_length_159_cov_2.276786_g35061_i0 | PRJNA734313 | 35174 | 159 | 2.276786 | 3.62008974 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 7.07e-7 | NR | KAJ8321611.1 | 220873 | g35061 | i0 | 48.1 | 3.69811320754717 | 52 | 27 | 98.1 | 0 | 2 | 157 | 219 | 270 | KAJ8321611.1 hypothetical protein KUTeg_000082 [Tegillarca granosa] | diamond | 588 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 31000355 | 31000355 | PRJNA734313_S_NODE_16554_length_230_cov_7.442623_g16441_i0 | PRJNA734313 | 16554 | 230 | 7.442623 | 17.1180329 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0417 | NR | KAA3676573.1 | 34504 | g16441 | i0 | 41.1 | 0.730434782608696 | 56 | 31 | 73 | 1 | 174 | 7 | 276 | 329 | KAA3676573.1 solute carrier family 39 (zinc transporter), member 11 [Paragonimus westermani] | diamond | 168 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31537946 | 31537946 | PRJNA734313_S_NODE_8856_length_314_cov_13.588015_g8743_i0 | PRJNA734313 | 8856 | 314 | 13.588015 | 42.6663671 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 57.4 | 6.13e-7 | NR | CAI9150999.1 | 3082113 | g8743 | i0 | 96.8 | 0.296178343949045 | 31 | 1 | 29.6 | 0 | 312 | 220 | 499 | 529 | CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] | diamond | 93 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 31885626 | 31885626 | PRJNA734313_S_NODE_7857_length_331_cov_1.257042_g7744_i0 | PRJNA734313 | 7857 | 331 | 1.257042 | 4.16080902 | Cercospora kikuchii | 84275 | Fungi | Fungi | 165 | 3.61e-46 | NR | XP_044652522.1 | 84275 | g7744 | i0 | 88 | 0.75226586102719 | 83 | 10 | 75.2 | 0 | 330 | 82 | 409 | 491 | XP_044652522.1 uncharacterized protein CKM354_000146200 [Cercospora kikuchii] | diamond | 249 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora kikuchii | |
| 32613172 | 32613172 | PRJNA734313_S_NODE_34640_length_160_cov_1.353982_g34527_i0 | PRJNA734313 | 34640 | 160 | 1.353982 | 2.1663712 | Monosporozyma servazzii | 27293 | Fungi | Fungi | 54.7 | 6.57e-7 | NR | CAL9733221.1 | 27293 | g34527 | i0 | 50 | 0.975 | 52 | 26 | 97.5 | 0 | 158 | 3 | 120 | 171 | CAL9733221.1 ras-like protein 2 [Monosporozyma servazzii] | diamond | 156 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Monosporozyma | Monosporozyma servazzii | |
| 32707612 | 32707612 | PRJNA734313_S_NODE_34900_length_160_cov_0.902655_g34787_i0 | PRJNA734313 | 34900 | 160 | 0.902655 | 1.444248 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 90.5 | 3.3700000000000003e-22 | NR | CAF1621987.1 | 1234261 | g34787 | i0 | 90.4 | 2.925 | 52 | 5 | 97.5 | 0 | 3 | 158 | 25 | 76 | CAF1621987.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 468 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;