contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA235310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 367384 | 367384 | PRJNA235310_P_NODE_541_length_519_cov_6.912766_g517_i0 | PRJNA235310 | 541 | 519 | 6.912766 | 35.87725554 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 1.32e-38 | NR | CAB3265748.1 | 59560 | g517 | i0 | 49 | 10.3352601156069 | 143 | 63 | 82.7 | 1 | 33 | 461 | 5 | 137 | CAB3265748.1 40S ribosomal protein S12-like [Phallusia mammillata] | diamond | 5364 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 2918001 | 2918001 | PRJNA235310_P_NODE_5123_length_168_cov_0.873950_g5097_i0 | PRJNA235310 | 5123 | 168 | 0.87395 | 1.468236 | Petaurus breviceps papuanus | 3040969 | Chordata | Chordata | 83.2 | 3.72e-17 | NR | XP_068943861.1 | 3040969 | g5097 | i0 | 67.3 | 6.875 | 55 | 18 | 98.2 | 0 | 165 | 1 | 161 | 215 | XP_068943861.1 procathepsin L-like [Petaurus breviceps papuanus] | diamond | 1155 | 83.6 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Petauridae | Petaurus | Petaurus breviceps | |
| 6745080 | 6745080 | PRJNA235310_P_NODE_886_length_422_cov_1.627346_g860_i0 | PRJNA235310 | 886 | 422 | 1.627346 | 6.86740012 | Oikopleura dioica | 34765 | Chordata | Chordata | 117 | 1.38e-30 | NR | CAG5105686.1 | 34765 | g860 | i0 | 52 | 1.39336492890995 | 98 | 47 | 69.7 | 0 | 87 | 380 | 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 | |
| 12535241 | 12535241 | PRJNA235310_P_NODE_6390_length_162_cov_0.920354_g6364_i0 | PRJNA235310 | 6390 | 162 | 0.920354 | 1.49097348 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 72 | 5.98e-13 | NR | NP_001279969.1 | 7868 | g6364 | i0 | 60.8 | 6.25925925925926 | 51 | 20 | 94.4 | 0 | 153 | 1 | 7 | 57 | NP_001279969.1 T-complex protein 1 subunit theta [Callorhinchus milii] | diamond | 1014 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 26694076 | 26694076 | PRJNA235310_P_NODE_6121_length_163_cov_0.912281_g6095_i0 | PRJNA235310 | 6121 | 163 | 0.912281 | 1.48701803 | Styela clava | 7725 | Chordata | Chordata | 55.1 | 3.36e-7 | NR | XP_039261475.1 | 7725 | g6095 | i0 | 50.9 | 2.09815950920245 | 53 | 26 | 97.5 | 0 | 1 | 159 | 15 | 67 | XP_039261475.1 glutathione S-transferase 2-like [Styela clava] | diamond | 342 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 27534132 | 27534132 | PRJNA235310_P_NODE_743_length_456_cov_14.238329_g717_i0 | PRJNA235310 | 743 | 456 | 14.238329 | 64.92678024 | Opisthokonta | 33154 | Chordata | Chordata | 168 | 9.13e-51 | NR | XP_035667477.1 | 7739 | g717 | i0 | 69.5 | 40.0460526315789 | 118 | 36 | 77.6 | 0 | 20 | 373 | 1 | 118 | XP_035667477.1 40S ribosomal protein S17 [Branchiostoma floridae] | diamond | 18261 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 28923247 | 28923247 | PRJNA235310_P_NODE_2048_length_274_cov_1.777778_g2022_i0 | PRJNA235310 | 2048 | 274 | 1.777778 | 4.87111172 | Metazoa | 33208 | Chordata | Chordata | 97.1 | 2.1699999999999998e-23 | NR | XP_070727999.1 | 55135 | g2022 | i0 | 55.4 | 12.470802919708 | 92 | 39 | 98.5 | 1 | 3 | 272 | 30 | 121 | XP_070727999.1 histone H2B-like [Pristiophorus japonicus] | diamond | 3417 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Pristiophoridae | Pristiophorus | Pristiophorus japonicus | ||
| 29063612 | 29063612 | PRJNA235310_P_NODE_5628_length_166_cov_0.888889_g5602_i0 | PRJNA235310 | 5628 | 166 | 0.888889 | 1.47555574 | Ranitomeya imitator | 111125 | Chordata | Chordata | 42 | 0.0245 | NR | CAJ0956274.1 | 111125 | g5602 | i0 | 56.7 | 1.10240963855422 | 30 | 13 | 54.2 | 0 | 76 | 165 | 1 | 30 | CAJ0956274.1 unnamed protein product [Ranitomeya imitator] | diamond | 183 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29239206 | 29239206 | PRJNA235310_P_NODE_2769_length_229_cov_1.666667_g2743_i0 | PRJNA235310 | 2769 | 229 | 1.666667 | 3.81666743 | Chondrichthyes | 7777 | Chordata | Chordata | 69.3 | 1.29e-11 | NR | XP_007895161.1 | 7868 | g2743 | i0 | 47.4 | 9.13100436681223 | 78 | 37 | 96.9 | 2 | 227 | 6 | 555 | 632 | XP_007895161.1 neutral ceramidase [Callorhinchus milii] | diamond | 2091 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 29649190 | 29649190 | PRJNA235310_P_NODE_2130_length_268_cov_1.671233_g2104_i0 | PRJNA235310 | 2130 | 268 | 1.671233 | 4.47890444 | root | 1 | Root_unresolved | Root_unresolved | 74.7 | 1.21e-14 | NR | CAH1273121.1 | 7740 | g2104 | i0 | 49.3 | 5.31716417910448 | 69 | 35 | 77.2 | 0 | 3 | 209 | 78 | 146 | CAH1273121.1 MGST1 [Branchiostoma lanceolatum] | diamond | 1425 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 29680821 | 29680821 | PRJNA235310_P_NODE_4830_length_169_cov_1.150000_g4804_i0 | PRJNA235310 | 4830 | 169 | 1.15 | 1.9435 | Opisthokonta | 33154 | Chordata | Chordata | 84.7 | 3.18e-18 | NR | XP_035682653.1 | 7739 | g4804 | i0 | 72.7 | 18.5502958579882 | 55 | 15 | 97.6 | 0 | 167 | 3 | 143 | 197 | XP_035682653.1 V-type proton ATPase subunit D-like [Branchiostoma floridae] | diamond | 3135 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30105475 | 30105475 | PRJNA235310_P_NODE_2972_length_221_cov_1.127907_g2946_i0 | PRJNA235310 | 2972 | 221 | 1.127907 | 2.49267447 | Rhincodon typus | 259920 | Chordata | Chordata | 57.8 | 1.4e-7 | NR | XP_048461938.1 | 259920 | g2946 | i0 | 40 | 1.95475113122172 | 70 | 40 | 92.3 | 1 | 219 | 16 | 554 | 623 | XP_048461938.1 vacuolar protein sorting-associated protein 35 [Rhincodon typus] | diamond | 432 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Rhincodontidae | Rhincodon | Rhincodon typus | |
| 30674198 | 30674198 | PRJNA235310_P_NODE_1733_length_305_cov_1.015625_g1707_i0 | PRJNA235310 | 1733 | 305 | 1.015625 | 3.09765625 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 94.7 | 3.94e-20 | NR | XP_019616203.1 | 7741 | g1707 | i0 | 50 | 2.84262295081967 | 96 | 46 | 93.4 | 2 | 296 | 12 | 31 | 125 | XP_019616203.1 PREDICTED: cAMP-regulated D2 protein-like [Branchiostoma belcheri] | diamond | 867 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31496296 | 31496296 | PRJNA235310_P_NODE_4956_length_169_cov_0.866667_g4930_i0 | PRJNA235310 | 4956 | 169 | 0.866667 | 1.46466723 | Branchiostoma floridae | 7739 | Chordata | Chordata | 43.9 | 0.0052 | NR | XP_035697787.1 | 7739 | g4930 | i0 | 40.5 | 1.24260355029586 | 37 | 22 | 65.7 | 0 | 55 | 165 | 12 | 48 | XP_035697787.1 EEF1A lysine methyltransferase 4-like [Branchiostoma floridae] | diamond | 210 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31735119 | 31735119 | PRJNA235310_P_NODE_1117_length_379_cov_1.839394_g1091_i0 | PRJNA235310 | 1117 | 379 | 1.839394 | 6.97130326 | Chordata | 7711 | Chordata | Chordata | 119 | 1.71e-28 | NR | XP_064412939.1 | 7897 | g1091 | i0 | 58.8 | 44.5250659630607 | 97 | 39 | 76 | 1 | 291 | 4 | 382 | 478 | XP_064412939.1 cytochrome b-245 heavy chain [Latimeria chalumnae] | diamond | 16875 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 32002240 | 32002240 | PRJNA235310_P_NODE_558_length_513_cov_2.209052_g534_i0 | PRJNA235310 | 558 | 513 | 2.209052 | 11.33243676 | Callorhinchus milii | 7868 | Chordata | Chordata | 78.2 | 1.99e-13 | NR | XP_007905810.2 | 7868 | g534 | i0 | 40 | 2.66666666666667 | 115 | 61 | 66.1 | 3 | 511 | 173 | 278 | 386 | XP_007905810.2 retinol dehydrogenase 12 isoform X1 [Callorhinchus milii] | diamond | 1368 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 32368291 | 32368291 | PRJNA235310_P_NODE_5459_length_166_cov_1.085470_g5433_i0 | PRJNA235310 | 5459 | 166 | 1.08547 | 1.8018802 | Metazoa | 33208 | Chordata | Chordata | 72 | 6.280000000000002e-13 | NR | XP_008118474.2 | 28377 | g5433 | i0 | 61.8 | 92.4397590361446 | 55 | 21 | 99.4 | 0 | 165 | 1 | 972 | 1026 | XP_008118474.2 eukaryotic translation initiation factor 5B [Anolis carolinensis] | diamond | 15345 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dactyloidae | Anolis | Anolis carolinensis | |
| 32508737 | 32508737 | PRJNA235310_P_NODE_4699_length_171_cov_1.278689_g4673_i0 | PRJNA235310 | 4699 | 171 | 1.278689 | 2.18655819 | Fukomys damarensis | 885580 | Chordata | Chordata | 52.4 | 5.54e-6 | NR | KFO21940.1 | 885580 | g4673 | i0 | 43.9 | 5 | 57 | 30 | 96.5 | 2 | 170 | 6 | 592 | 648 | KFO21940.1 Rho GTPase-activating protein 29 [Fukomys damarensis] | diamond | 855 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Fukomys | Fukomys damarensis | |
| 32540346 | 32540346 | PRJNA235310_P_NODE_2879_length_225_cov_0.886364_g2853_i0 | PRJNA235310 | 2879 | 225 | 0.886364 | 1.994319 | Ranitomeya imitator | 111125 | Chordata | Chordata | 43.5 | 0.0155 | NR | CAJ0953929.1 | 111125 | g2853 | i0 | 35.2 | 3.66666666666667 | 54 | 35 | 72 | 0 | 163 | 2 | 59 | 112 | CAJ0953929.1 unnamed protein product [Ranitomeya imitator] | diamond | 825 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator |
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);;