contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA278119" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9986799 | 9986799 | PRJNA278119_P_NODE_13068_length_311_cov_1.167939_g12820_i0 | PRJNA278119 | 13068 | 311 | 1.167939 | 3.63229029 | Metazoa | 33208 | Chordata | Chordata | 90.1 | 9.63e-20 | NR | XP_026694101.1 | 7719 | g12820 | i0 | 64.8 | 29.4694533762058 | 71 | 23 | 67.5 | 2 | 102 | 311 | 10 | 79 | XP_026694101.1 GTP-binding nuclear protein Ran-like [Ciona intestinalis] | diamond | 9165 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 22047883 | 22047883 | PRJNA278119_P_NODE_38958_length_167_cov_0.881356_g38709_i0 | PRJNA278119 | 38958 | 167 | 0.881356 | 1.47186452 | Oikopleura dioica | 34765 | Chordata | Chordata | 88.2 | 6.93e-19 | NR | CAG5086348.1 | 34765 | g38709 | i0 | 82.4 | 2.8562874251497 | 51 | 9 | 91.6 | 0 | 10 | 162 | 14 | 64 | CAG5086348.1 Oidioi.mRNA.OKI2018_I69.PAR.g11184.t1.cds [Oikopleura dioica] | diamond | 477 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 23323578 | 23323578 | PRJNA278119_P_NODE_6079_length_483_cov_2.668203_g5833_i0 | PRJNA278119 | 6079 | 483 | 2.668203 | 12.88742049 | Sciurus carolinensis | 30640 | Chordata | Chordata | 158 | 4.88e-45 | NR | MBZ3878477.1 | 30640 | g5833 | i0 | 53 | 1.04347826086957 | 168 | 67 | 98.8 | 3 | 482 | 6 | 62 | 226 | MBZ3878477.1 60S ribosomal protein L15 [Sciurus carolinensis] | diamond | 504 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 23323610 | 23323610 | PRJNA278119_P_NODE_8199_length_414_cov_2.104110_g7952_i0 | PRJNA278119 | 8199 | 414 | 2.10411 | 8.7110154 | Oikopleura dioica | 34765 | Chordata | Chordata | 117 | 9.08e-31 | NR | CAG5105686.1 | 34765 | g7952 | i0 | 52 | 1.42028985507246 | 98 | 47 | 71 | 0 | 336 | 43 | 12 | 109 | CAG5105686.1 Oidioi.mRNA.OKI2018_I69.chr1.g2360.t1.cds [Oikopleura dioica] | diamond | 588 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 27154571 | 27154571 | PRJNA278119_P_NODE_18402_length_238_cov_1.000000_g18153_i0 | PRJNA278119 | 18402 | 238 | 1 | 2.38 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 1.07e-27 | NR | CAB3264621.1 | 59560 | g18153 | i0 | 71.6 | 7.43697478991597 | 74 | 21 | 93.3 | 0 | 9 | 230 | 7 | 80 | CAB3264621.1 polyadenylate-binding protein 4-like [Phallusia mammillata] | diamond | 1770 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 28495387 | 28495387 | PRJNA278119_P_NODE_20307_length_222_cov_0.901734_g20058_i0 | PRJNA278119 | 20307 | 222 | 0.901734 | 2.00184948 | Struthio camelus | 8801 | Chordata | Chordata | 43.5 | 0.00955 | NR | XP_009674880.2 | 8801 | g20058 | i0 | 39.6 | 2.01351351351351 | 53 | 29 | 67.6 | 1 | 190 | 41 | 55 | 107 | XP_009674880.2 placenta-specific gene 8 protein isoform X3 [Struthio camelus] | diamond | 447 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Struthioniformes | Struthionidae | Struthio | Struthio camelus | |
| 28860134 | 28860134 | PRJNA278119_P_NODE_15868_length_267_cov_2.142202_g15619_i0 | PRJNA278119 | 15868 | 267 | 2.142202 | 5.71967934 | Metazoa | 33208 | Chordata | Chordata | 84.7 | 1.69e-19 | NR | TFK03063.1 | 55544 | g15619 | i0 | 60.6 | 2.9438202247191 | 66 | 22 | 69.7 | 1 | 257 | 72 | 1 | 66 | TFK03063.1 40S ribosomal protein S29 [Platysternon megacephalum] | diamond | 786 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Platysternidae | Platysternon | Platysternon megacephalum | ||
| 29207742 | 29207742 | PRJNA278119_P_NODE_16129_length_264_cov_1.451163_g15880_i0 | PRJNA278119 | 16129 | 264 | 1.451163 | 3.83107032 | Metazoa | 33208 | Chordata | Chordata | 117 | 5.01e-30 | NR | XP_039268154.1 | 7725 | g15880 | i0 | 63.9 | 19.9545454545455 | 83 | 30 | 94.3 | 0 | 1 | 249 | 175 | 257 | XP_039268154.1 40S ribosomal protein S4, Y-like [Styela clava] | diamond | 5268 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 29333877 | 29333877 | PRJNA278119_P_NODE_36489_length_168_cov_0.873950_g36240_i0 | PRJNA278119 | 36489 | 168 | 0.87395 | 1.468236 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 8.25e-4 | NR | XP_028597743.1 | 64176 | g36240 | i0 | 52.3 | 3.32142857142857 | 44 | 20 | 78.6 | 1 | 153 | 22 | 32 | 74 | XP_028597743.1 probable protein phosphatase 1N isoform X2 [Podarcis muralis] | diamond | 558 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis muralis | |
| 29523321 | 29523321 | PRJNA278119_P_NODE_46150_length_162_cov_1.840708_g45901_i0 | PRJNA278119 | 46150 | 162 | 1.840708 | 2.98194696 | Squamata | 8509 | Chordata | Chordata | 90.1 | 5.33e-21 | NR | XP_015266013.1 | 146911 | g45901 | i0 | 69.8 | 10.7222222222222 | 53 | 16 | 98.1 | 0 | 160 | 2 | 114 | 166 | XP_015266013.1 PREDICTED: sulfiredoxin-1 [Gekko japonicus] | diamond | 1737 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 29631614 | 29631614 | PRJNA278119_P_NODE_29470_length_182_cov_1.563910_g29221_i0 | PRJNA278119 | 29470 | 182 | 1.56391 | 2.8463162 | Phallusia mammillata | 59560 | Chordata | Chordata | 60.8 | 9.16e-10 | NR | CAB3265748.1 | 59560 | g29221 | i0 | 54.5 | 2.15934065934066 | 44 | 20 | 72.5 | 0 | 3 | 134 | 94 | 137 | CAB3265748.1 40S ribosomal protein S12-like [Phallusia mammillata] | diamond | 393 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 29744060 | 29744060 | PRJNA278119_P_NODE_33030_length_173_cov_1.088710_g32781_i0 | PRJNA278119 | 33030 | 173 | 1.08871 | 1.8834683 | root | 1 | Root_unresolved | Root_unresolved | 123 | 5.6e-32 | NR | XP_036010302.1 | 10090 | g32781 | i0 | 100 | 14.8265895953757 | 57 | 0 | 98.8 | 0 | 1 | 171 | 45 | 101 | XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus] | diamond | 2565 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 30123229 | 30123229 | PRJNA278119_P_NODE_15772_length_269_cov_1.277273_g15523_i0 | PRJNA278119 | 15772 | 269 | 1.277273 | 3.43586437 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.7 | 7.64e-19 | NR | XP_028676068.1 | 27687 | g15523 | i0 | 49.4 | 12.6133828996283 | 87 | 44 | 97 | 0 | 8 | 268 | 196 | 282 | XP_028676068.1 actin, cytoplasmic 2-like [Erpetoichthys calabaricus] | diamond | 3393 | 90.5 | 0.991160220994475 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 30408039 | 30408039 | PRJNA278119_P_NODE_11693_length_336_cov_1.811847_g11445_i0 | PRJNA278119 | 11693 | 336 | 1.811847 | 6.08780592 | Opisthokonta | 33154 | Chordata | Chordata | 119 | 5.989999999999999e-32 | NR | Q8ISN9.1 | 7741 | g11445 | i0 | 65.6 | 3.39285714285714 | 96 | 33 | 85.7 | 0 | 16 | 303 | 13 | 108 | Q8ISN9.1 RecName: Full=Small ribosomal subunit protein eS25; AltName: Full=40S ribosomal protein S25 [Branchiostoma belcheri] | diamond | 1140 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 30611072 | 30611072 | PRJNA278119_P_NODE_19853_length_225_cov_1.017045_g19604_i0 | PRJNA278119 | 19853 | 225 | 1.017045 | 2.28835125 | Eleutherodactylus coqui | 57060 | Chordata | Chordata | 117 | 1.32e-30 | NR | KAG9489525.1 | 57060 | g19604 | i0 | 72.2 | 3.84 | 72 | 20 | 96 | 0 | 217 | 2 | 67 | 138 | KAG9489525.1 hypothetical protein GDO78_005484 [Eleutherodactylus coqui] | diamond | 864 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 30800650 | 30800650 | PRJNA278119_P_NODE_27994_length_187_cov_1.130435_g27745_i0 | PRJNA278119 | 27994 | 187 | 1.130435 | 2.11391345 | Pristiophorus japonicus | 55135 | Chordata | Chordata | 54.7 | 9.67e-7 | NR | XP_070720711.1 | 55135 | g27745 | i0 | 43.4 | 7.52406417112299 | 53 | 26 | 85 | 1 | 17 | 175 | 131 | 179 | XP_070720711.1 cytosolic 5'-nucleotidase 3A-like [Pristiophorus japonicus] | diamond | 1407 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Pristiophoridae | Pristiophorus | Pristiophorus japonicus | ||
| 30990487 | 30990487 | PRJNA278119_P_NODE_21354_length_215_cov_1.253012_g21105_i0 | PRJNA278119 | 21354 | 215 | 1.253012 | 2.6939758 | Protobothrops mucrosquamatus | 103944 | Chordata | Chordata | 57.8 | 1.37e-8 | NR | XP_015686127.1 | 103944 | g21105 | i0 | 45.6 | 3.57209302325581 | 68 | 37 | 94.9 | 0 | 206 | 3 | 2 | 69 | XP_015686127.1 stress-induced-phosphoprotein 1-like, partial [Protobothrops mucrosquamatus] | diamond | 768 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Protobothrops | Protobothrops mucrosquamatus | |
| 31355883 | 31355883 | PRJNA278119_P_NODE_5856_length_493_cov_1.389640_g5610_i0 | PRJNA278119 | 5856 | 493 | 1.38964 | 6.8509252 | Chordata | 7711 | Chordata | Chordata | 184 | 3.78e-56 | NR | XP_069480798.1 | 8296 | g5610 | i0 | 77.2 | 40.3569979716024 | 123 | 28 | 74.8 | 0 | 472 | 104 | 57 | 179 | XP_069480798.1 small ribosomal subunit protein eS17 [Ambystoma mexicanum] | diamond | 19896 | 185 | 0.994594594594595 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31527939 | 31527939 | PRJNA278119_P_NODE_42976_length_164_cov_1.356522_g42727_i0 | PRJNA278119 | 42976 | 164 | 1.356522 | 2.22469608 | Balaenoptera physalus | 9770 | Chordata | Chordata | 57.8 | 2.61e-8 | NR | KAB0406035.1 | 9770 | g42727 | i0 | 76.2 | 0.768292682926829 | 42 | 10 | 76.8 | 0 | 128 | 3 | 42 | 83 | KAB0406035.1 hypothetical protein E2I00_012731, partial [Balaenoptera physalus] | diamond | 126 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 32065539 | 32065539 | PRJNA278119_P_NODE_9978_length_370_cov_1.834891_g9731_i0 | PRJNA278119 | 9978 | 370 | 1.834891 | 6.7890967 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 71.6 | 1.08e-11 | NR | CAH1249033.1 | 7740 | g9731 | i0 | 54.8 | 1.00540540540541 | 62 | 27 | 49.5 | 1 | 6 | 188 | 340 | 401 | CAH1249033.1 LYG2, partial [Branchiostoma lanceolatum] | diamond | 372 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 32209893 | 32209893 | PRJNA278119_P_NODE_15778_length_269_cov_1.181818_g15529_i0 | PRJNA278119 | 15778 | 269 | 1.181818 | 3.17909042 | Metazoa | 33208 | Chordata | Chordata | 104 | 1.4500000000000002e-26 | NR | XP_032814458.1 | 7757 | g15529 | i0 | 67.4 | 19.8513011152416 | 89 | 28 | 99.3 | 1 | 3 | 269 | 5 | 92 | XP_032814458.1 60S ribosomal protein L35 isoform X2 [Petromyzon marinus] | diamond | 5340 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 32540454 | 32540454 | PRJNA278119_P_NODE_35719_length_169_cov_0.866667_g35470_i0 | PRJNA278119 | 35719 | 169 | 0.866667 | 1.46466723 | Suncus etruscus | 109475 | Chordata | Chordata | 48.9 | 9.07e-5 | NR | XP_049636708.1 | 109475 | g35470 | i0 | 50 | 2.66272189349112 | 52 | 23 | 92.3 | 2 | 13 | 168 | 252 | 300 | XP_049636708.1 7-methylguanosine phosphate-specific 5'-nucleotidase [Suncus etruscus] | diamond | 450 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 32620884 | 32620884 | PRJNA278119_P_NODE_45160_length_163_cov_0.912281_g44911_i0 | PRJNA278119 | 45160 | 163 | 0.912281 | 1.48701803 | Mammalia | 40674 | Chordata | Chordata | 53.9 | 1.45e-6 | NR | XP_028923842.1 | 9258 | g44911 | i0 | 97.1 | 3.16564417177914 | 34 | 1 | 62.6 | 0 | 108 | 7 | 435 | 468 | XP_028923842.1 tetratricopeptide repeat protein 14 isoform X1 [Ornithorhynchus anatinus] | diamond | 516 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus | |
| 32872744 | 32872744 | PRJNA278119_P_NODE_46580_length_162_cov_1.159292_g46331_i0 | PRJNA278119 | 46580 | 162 | 1.159292 | 1.87805304 | Chordata | 7711 | Chordata | Chordata | 63.2 | 5.32e-10 | NR | XP_063138878.1 | 10116 | g46331 | i0 | 56.5 | 8.98148148148148 | 46 | 20 | 85.2 | 0 | 7 | 144 | 72 | 117 | XP_063138878.1 transmembrane emp24 domain-containing protein 2-like [Rattus norvegicus] | diamond | 1455 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus |
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);;