contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3546068 | 3546068 | PRJEB73599_P_NODE_2543_length_462_cov_2.789838_g2271_i0 | PRJEB73599 | 2543 | 462 | 2.789838 | 12.88905156 | Metazoa | 33208 | Arthropoda | Arthropoda | 108 | 1.13e-26 | NR | XP_055694015.1 | 7200 | g2271 | i0 | 74.2 | 3.06493506493507 | 66 | 17 | 42.9 | 0 | 430 | 233 | 5 | 70 | XP_055694015.1 60S ribosomal protein L27a-like [Lutzomyia longipalpis] | diamond | 1416 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Psychodidae | Lutzomyia | Lutzomyia longipalpis | |
| 3961255 | 3961255 | PRJEB73599_P_NODE_1784_length_555_cov_3.891635_g1548_i0 | PRJEB73599 | 1784 | 555 | 3.891635 | 21.59857425 | Opisthokonta | 33154 | Chordata | Chordata | 305 | 3.9999999999999993e-103 | NR | XP_035672114.1 | 7739 | g1548 | i0 | 85.4 | 16.8972972972973 | 164 | 24 | 88.6 | 0 | 528 | 37 | 37 | 200 | XP_035672114.1 peptidyl-prolyl cis-trans isomerase-like [Branchiostoma floridae] | diamond | 9378 | 308 | 0.99025974025974 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 12888700 | 12888700 | PRJEB73599_P_NODE_1531_length_601_cov_5.304196_g1313_i0 | PRJEB73599 | 1531 | 601 | 5.304196 | 31.87821796 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 151 | 1.14e-39 | NR | XP_013397972.1 | 7574 | g1313 | i0 | 47.6 | 2.60565723793677 | 170 | 84 | 83.4 | 5 | 502 | 2 | 183 | 350 | XP_013397972.1 cathepsin L isoform X2 [Lingula anatina] | diamond | 1566 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 12888723 | 12888723 | PRJEB73599_P_NODE_3391_length_387_cov_3.865922_g3105_i0 | PRJEB73599 | 3391 | 387 | 3.865922 | 14.96111814 | Phoronis muelleri | 478209 | Phoronida | other_Eukaryota | 85.1 | 1.62e-18 | NR | ACD65187.1 | 478209 | g3105 | i0 | 53.6 | 1.36434108527132 | 110 | 51 | 85.3 | 0 | 27 | 356 | 1 | 110 | ACD65187.1 putative 60S ribosomal protein RPLP1 [Phoronis muelleri] | diamond | 528 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Phoronida | Phoronidae | Phoronis | Phoronis muelleri | |||
| 15023407 | 15023407 | PRJEB73599_P_NODE_3412_length_386_cov_2.644258_g3126_i0 | PRJEB73599 | 3412 | 386 | 2.644258 | 10.20683588 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 132 | 1.55e-36 | NR | XP_024506763.1 | 34506 | g3126 | i0 | 48.6 | 4.51554404145078 | 146 | 41 | 87 | 2 | 27 | 362 | 2 | 147 | XP_024506763.1 60S ribosomal protein L27a [Strongyloides ratti] | diamond | 1743 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 21811943 | 21811943 | PRJEB73599_P_NODE_3758_length_360_cov_5.942598_g3472_i0 | PRJEB73599 | 3758 | 360 | 5.942598 | 21.3933528 | Opisthokonta | 33154 | Chordata | Chordata | 161 | 6.69e-46 | NR | XP_021036129.1 | 10089 | g3472 | i0 | 78.9 | 564.5 | 109 | 21 | 89.2 | 1 | 2 | 322 | 230 | 338 | XP_021036129.1 uncharacterized protein LOC110308115 [Mus caroli] | diamond | 203220 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus caroli | |
| 27413636 | 27413636 | PRJEB73599_P_NODE_8743_length_176_cov_1.469388_g8456_i0 | PRJEB73599 | 8743 | 176 | 1.469388 | 2.58612288 | Meganyctiphanes norvegica | 48144 | Arthropoda | Arthropoda | 65.5 | 1.46e-11 | NR | CAL4060158.1 | 48144 | g8456 | i0 | 61.4 | 0.971590909090909 | 57 | 22 | 97.2 | 0 | 173 | 3 | 60 | 116 | CAL4060158.1 unnamed protein product [Meganyctiphanes norvegica] | diamond | 171 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Euphausiacea | Euphausiidae | Meganyctiphanes | Meganyctiphanes norvegica | |
| 28076331 | 28076331 | PRJEB73599_P_NODE_345_length_1239_cov_2.834711_g269_i0 | PRJEB73599 | 345 | 1239 | 2.834711 | 35.12206929 | Ciona intestinalis | 7719 | Chordata | Chordata | 282 | 1.3299999999999995e-82 | NR | XP_026693114.1 | 7719 | g269 | i0 | 43.3 | 1.34140435835351 | 277 | 156 | 67.1 | 1 | 187 | 1017 | 561 | 836 | XP_026693114.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Ciona intestinalis] | diamond | 1662 | 282 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 28265692 | 28265692 | PRJEB73599_P_NODE_7366_length_207_cov_6.359551_g7079_i0 | PRJEB73599 | 7366 | 207 | 6.359551 | 13.16427057 | Idotea baltica | 82763 | Arthropoda | Arthropoda | 49.3 | 5.81e-6 | NR | MCL4129530.1 | 82763 | g7079 | i0 | 65 | 0.579710144927536 | 40 | 10 | 52.2 | 1 | 109 | 2 | 9 | 48 | MCL4129530.1 hypothetical protein [Idotea baltica] | diamond | 120 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 28392187 | 28392187 | PRJEB73599_P_NODE_3986_length_346_cov_4.482650_g3699_i0 | PRJEB73599 | 3986 | 346 | 4.48265 | 15.509969 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 52.8 | 3e-5 | NR | VDO09905.1 | 102285 | g3699 | i0 | 39.7 | 2.03757225433526 | 78 | 41 | 66.8 | 3 | 73 | 303 | 208 | 280 | VDO09905.1 unnamed protein product [Rodentolepis nana] | diamond | 705 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29048176 | 29048176 | PRJEB73599_P_NODE_1208_length_683_cov_2.463303_g1017_i0 | PRJEB73599 | 1208 | 683 | 2.463303 | 16.82435949 | Mammalia | 40674 | Chordata | Chordata | 153 | 2.5899999999999998e-42 | NR | XP_045843934.1 | 9662 | g1017 | i0 | 50.3 | 27.1581259150805 | 155 | 77 | 68.1 | 0 | 550 | 86 | 63 | 217 | XP_045843934.1 60S ribosomal protein L13a isoform X1 [Meles meles] | diamond | 18549 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 29111322 | 29111322 | PRJEB73599_P_NODE_6008_length_251_cov_2.063063_g5721_i0 | PRJEB73599 | 6008 | 251 | 2.063063 | 5.17828813 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 1.49e-4 | NR | KAK3779016.1 | 231223 | g5721 | i0 | 39.8 | 2.92828685258964 | 83 | 50 | 99.2 | 0 | 1 | 249 | 790 | 872 | KAK3779016.1 hypothetical protein RRG08_034274 [Elysia crispata] | diamond | 735 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 29869006 | 29869006 | PRJEB73599_P_NODE_4011_length_345_cov_2.420886_g3724_i0 | PRJEB73599 | 4011 | 345 | 2.420886 | 8.3520567 | Cervidae | 9850 | Chordata | Chordata | 187 | 9.019999999999998e-56 | NR | OWK11568.1 | 46360 | g3724 | i0 | 70.4 | 12.0869565217391 | 125 | 25 | 98.3 | 1 | 341 | 3 | 68 | 192 | OWK11568.1 hypothetical protein Celaphus_00003504 [Cervus elaphus hippelaphus] | diamond | 4170 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 29907926 | 29907926 | PRJEB73599_P_NODE_351_length_1230_cov_2.837635_g269_i1 | PRJEB73599 | 351 | 1230 | 2.837635 | 34.9029105 | Ciona intestinalis | 7719 | Chordata | Chordata | 282 | 1.2099999999999999e-82 | NR | XP_026693114.1 | 7719 | g269 | i1 | 43.3 | 1.35121951219512 | 277 | 156 | 67.6 | 1 | 1011 | 181 | 561 | 836 | XP_026693114.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Ciona intestinalis] | diamond | 1662 | 282 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 29939517 | 29939517 | PRJEB73599_P_NODE_4211_length_333_cov_2.305921_g3924_i0 | PRJEB73599 | 4211 | 333 | 2.305921 | 7.67871693 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 2.24e-9 | NR | CAI9620946.1 | 386267 | g3924 | i0 | 70.3 | 0.333333333333333 | 37 | 11 | 33.3 | 0 | 135 | 245 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30002693 | 30002693 | PRJEB73599_P_NODE_9231_length_167_cov_1.471014_g8944_i0 | PRJEB73599 | 9231 | 167 | 1.471014 | 2.45659338 | Aplysia californica | 6500 | Mollusca | Mollusca | 76.3 | 2.02e-14 | NR | XP_005094744.1 | 6500 | g8944 | i0 | 61.8 | 0.988023952095808 | 55 | 21 | 98.8 | 0 | 3 | 167 | 189 | 243 | XP_005094744.1 long-chain-fatty-acid--CoA ligase 5 isoform X4 [Aplysia californica] | diamond | 165 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30248324 | 30248324 | PRJEB73599_P_NODE_3472_length_381_cov_6.508523_g3186_i0 | PRJEB73599 | 3472 | 381 | 6.508523 | 24.79747263 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 52.8 | 4.1e-5 | NR | CDS37392.1 | 6211 | g3186 | i0 | 41 | 1.80314960629921 | 78 | 34 | 58.3 | 4 | 80 | 301 | 206 | 275 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 687 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 30950599 | 30950599 | PRJEB73599_P_NODE_1374_length_637_cov_2.468750_g1017_i1 | PRJEB73599 | 1374 | 637 | 2.46875 | 15.7259375 | Capra hircus | 9925 | Chordata | Chordata | 157 | 1.53e-41 | NR | XDB60276.1 | 9925 | g1017 | i1 | 42.8 | 17.1522762951334 | 194 | 93 | 82.9 | 1 | 25 | 552 | 296 | 489 | XDB60276.1 hypothetical protein ABFV05_013892 [Capra hircus] | diamond | 10926 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 31582882 | 31582882 | PRJEB73599_P_NODE_6456_length_236_cov_1.908213_g6169_i0 | PRJEB73599 | 6456 | 236 | 1.908213 | 4.50338268 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 45.4 | 0.00379 | NR | XP_071501170.1 | 105358 | g6169 | i0 | 37.5 | 1.6271186440678 | 64 | 36 | 77.5 | 2 | 187 | 5 | 25 | 87 | XP_071501170.1 uncharacterized protein [Diadema antillarum] | diamond | 384 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31670351 | 31670351 | PRJEB73599_P_NODE_1957_length_530_cov_2.127745_g1707_i0 | PRJEB73599 | 1957 | 530 | 2.127745 | 11.2770485 | Metazoa | 33208 | Mollusca | Mollusca | 136 | 1.69e-35 | NR | CAG5124857.1 | 100452 | g1707 | i0 | 65.1 | 1.92452830188679 | 86 | 30 | 48.7 | 0 | 260 | 3 | 241 | 326 | CAG5124857.1 unnamed protein product [Candidula unifasciata] | diamond | 1020 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 32049998 | 32049998 | PRJEB73599_P_NODE_8718_length_176_cov_2.312925_g8431_i0 | PRJEB73599 | 8718 | 176 | 2.312925 | 4.070748 | Chironomus | 7150 | Arthropoda | Arthropoda | 67.4 | 3.05e-11 | NR | XP_070493817.1 | 113505 | g8431 | i0 | 59.3 | 6.61363636363636 | 54 | 22 | 92 | 0 | 1 | 162 | 139 | 192 | XP_070493817.1 fatty acid synthase-like [Chironomus tepperi] | diamond | 1164 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus tepperi | |
| 32240115 | 32240115 | PRJEB73599_P_NODE_7298_length_210_cov_2.055249_g7011_i0 | PRJEB73599 | 7298 | 210 | 2.055249 | 4.3160229 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 2.41e-12 | NR | XP_035687608.1 | 7739 | g7011 | i0 | 43.8 | 5.82857142857143 | 73 | 34 | 95.7 | 2 | 5 | 205 | 197 | 268 | XP_035687608.1 EGF-like repeat and discoidin I-like domain-containing protein 3 [Branchiostoma floridae] | diamond | 1224 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae |
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);;