contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA474426" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10025130 | 10025130 | PRJNA474426_P_NODE_19808_length_225_cov_1.164773_g19603_i0 | PRJNA474426 | 19808 | 225 | 1.164773 | 2.62073925 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 54.7 | 1.77e-6 | NR | XP_006812811.1 | 10224 | g19603 | i0 | 40.9 | 0.88 | 66 | 39 | 88 | 0 | 23 | 220 | 9 | 74 | XP_006812811.1 PREDICTED: protein unc-45 homolog B-like, partial [Saccoglossus kowalevskii] | diamond | 198 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 25323150 | 25323150 | PRJNA474426_P_NODE_30860_length_172_cov_1.260163_g30655_i0 | PRJNA474426 | 30860 | 172 | 1.260163 | 2.16748036 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.62e-13 | NR | XP_069107631.1 | 31199 | g30655 | i0 | 57.9 | 3.97674418604651 | 57 | 24 | 99.4 | 0 | 1 | 171 | 302 | 358 | XP_069107631.1 tyrosine--tRNA ligase, mitochondrial-like [Argopecten irradians] | diamond | 684 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27550085 | 27550085 | PRJNA474426_P_NODE_18684_length_233_cov_1.358696_g18479_i0 | PRJNA474426 | 18684 | 233 | 1.358696 | 3.16576168 | Toxocara canis | 6265 | Nematoda | Nematoda | 43.5 | 0.0178 | NR | VDM41077.1 | 6265 | g18479 | i0 | 58.1 | 0.399141630901288 | 31 | 13 | 39.9 | 0 | 140 | 232 | 136 | 166 | VDM41077.1 unnamed protein product [Toxocara canis] | diamond | 93 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 27613510 | 27613510 | PRJNA474426_P_NODE_7484_length_395_cov_1.656069_g7280_i0 | PRJNA474426 | 7484 | 395 | 1.656069 | 6.54147255 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 132 | 1.4299999999999996e-34 | NR | XP_051791274.1 | 27687 | g7280 | i0 | 77.8 | 6.2126582278481 | 90 | 19 | 67.6 | 1 | 15 | 281 | 115 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2454 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27676753 | 27676753 | PRJNA474426_P_NODE_9764_length_344_cov_1.745763_g9559_i0 | PRJNA474426 | 9764 | 344 | 1.745763 | 6.00542472 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 48.5 | 3.57e-4 | NR | KAK3889318.1 | 88211 | g9559 | i0 | 33 | 0.793604651162791 | 91 | 47 | 76.7 | 5 | 48 | 311 | 16 | 95 | KAK3889318.1 hypothetical protein Pcinc_006668 [Petrolisthes cinctipes] | diamond | 273 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 27724544 | 27724544 | PRJNA474426_P_NODE_27404_length_185_cov_1.500000_g27199_i0 | PRJNA474426 | 27404 | 185 | 1.5 | 2.775 | Metazoa | 33208 | Mollusca | Mollusca | 49.7 | 6.2e-5 | NR | XP_055860289.1 | 6526 | g27199 | i0 | 47.7 | 2.85405405405405 | 44 | 23 | 71.4 | 0 | 182 | 51 | 606 | 649 | XP_055860289.1 uncharacterized protein LOC129921730 [Biomphalaria glabrata] | diamond | 528 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27929153 | 27929153 | PRJNA474426_P_NODE_35065_length_164_cov_0.895652_g34860_i0 | PRJNA474426 | 35065 | 164 | 0.895652 | 1.46886928 | Armadillidium nasatum | 96803 | Arthropoda | Arthropoda | 44.3 | 0.0036 | NR | KAB7501538.1 | 96803 | g34860 | i0 | 42.6 | 0.98780487804878 | 54 | 28 | 95.1 | 2 | 158 | 3 | 86 | 138 | KAB7501538.1 hypothetical protein Anas_13330 [Armadillidium nasatum] | diamond | 162 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Armadillidiidae | Armadillidium | Armadillidium nasatum | |
| 28229121 | 28229121 | PRJNA474426_P_NODE_9686_length_346_cov_1.680135_g9481_i0 | PRJNA474426 | 9686 | 346 | 1.680135 | 5.8132671 | Insecta | 50557 | Arthropoda | Arthropoda | 85.1 | 1.82e-16 | NR | XP_014225606.1 | 7493 | g9481 | i0 | 42.6 | 5.70520231213873 | 108 | 60 | 93.6 | 1 | 331 | 8 | 123 | 228 | XP_014225606.1 protein mini spindles isoform X2 [Trichogramma pretiosum] | diamond | 1974 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Trichogrammatidae | Trichogramma | Trichogramma pretiosum | |
| 29539255 | 29539255 | PRJNA474426_P_NODE_33110_length_167_cov_0.838983_g32905_i0 | PRJNA474426 | 33110 | 167 | 0.838983 | 1.40110161 | Condylostylus longicornis | 2530218 | Arthropoda | Arthropoda | 94.4 | 1.1e-22 | NR | XP_055380919.1 | 2530218 | g32905 | i0 | 78.2 | 1.95808383233533 | 55 | 12 | 98.8 | 0 | 167 | 3 | 6 | 60 | XP_055380919.1 J domain-containing protein [Condylostylus longicornis] | diamond | 327 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Dolichopodidae | Condylostylus | Condylostylus longicornis | |
| 29791798 | 29791798 | PRJNA474426_P_NODE_26631_length_188_cov_1.359712_g26426_i0 | PRJNA474426 | 26631 | 188 | 1.359712 | 2.55625856 | Gracilinanus agilis | 191870 | Chordata | Chordata | 44.3 | 0.00525 | NR | XP_044526686.1 | 191870 | g26426 | i0 | 42.9 | 3.25531914893617 | 49 | 28 | 78.2 | 0 | 2 | 148 | 1372 | 1420 | XP_044526686.1 zinc finger protein 142 isoform X1 [Gracilinanus agilis] | diamond | 612 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Didelphimorphia | Didelphidae | Gracilinanus | Gracilinanus agilis | |
| 30329535 | 30329535 | PRJNA474426_P_NODE_14352_length_275_cov_0.889381_g14147_i0 | PRJNA474426 | 14352 | 275 | 0.889381 | 2.44579775 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 48.1 | 6.98e-4 | NR | CAK5069761.1 | 390850 | g14147 | i0 | 33.3 | 1.89818181818182 | 87 | 52 | 93.8 | 3 | 7 | 264 | 728 | 809 | CAK5069761.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 522 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30661068 | 30661068 | PRJNA474426_P_NODE_28333_length_181_cov_2.939394_g28128_i0 | PRJNA474426 | 28333 | 181 | 2.939394 | 5.32030314 | Metazoa | 33208 | Arthropoda | Arthropoda | 41.6 | 0.0436 | NR | XP_022254126.1 | 6850 | g28128 | i0 | 39.2 | 2.75138121546961 | 51 | 31 | 84.5 | 0 | 2 | 154 | 1408 | 1458 | XP_022254126.1 uncharacterized protein LOC106469854 [Limulus polyphemus] | diamond | 498 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Merostomata | Xiphosura | Limulidae | Limulus | Limulus polyphemus | |
| 30755953 | 30755953 | PRJNA474426_P_NODE_22114_length_211_cov_1.123457_g21909_i0 | PRJNA474426 | 22114 | 211 | 1.123457 | 2.37049427 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 52.4 | 9.34e-6 | NR | GLH16767.1 | 6999 | g21909 | i0 | 45.3 | 1.29383886255924 | 53 | 29 | 75.4 | 0 | 167 | 9 | 179 | 231 | GLH16767.1 Ankyrin2 [Gryllus bimaculatus] | diamond | 273 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Gryllidae | Gryllus | Gryllus bimaculatus | |
| 31245291 | 31245291 | PRJNA474426_P_NODE_31095_length_171_cov_1.483607_g30890_i0 | PRJNA474426 | 31095 | 171 | 1.483607 | 2.53696797 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 43.1 | 0.00987 | NR | XP_068733065.1 | 246305 | g30890 | i0 | 38 | 0.87719298245614 | 50 | 30 | 87.7 | 1 | 167 | 18 | 156 | 204 | XP_068733065.1 uncharacterized protein [Montipora capricornis] | diamond | 150 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 31909592 | 31909592 | PRJNA474426_P_NODE_17597_length_242_cov_1.740933_g17392_i0 | PRJNA474426 | 17597 | 242 | 1.740933 | 4.21305786 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 46.6 | 0.00146 | NR | XP_065584274.1 | 6661 | g17392 | i0 | 47.1 | 0.632231404958678 | 51 | 27 | 63.2 | 0 | 221 | 69 | 1 | 51 | XP_065584274.1 ankyrin-1-like, partial [Artemia franciscana] | diamond | 153 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32083856 | 32083856 | PRJNA474426_P_NODE_17238_length_245_cov_1.561224_g17033_i0 | PRJNA474426 | 17238 | 245 | 1.561224 | 3.8249988 | Aves | 8782 | Chordata | Chordata | 58.9 | 7.62e-8 | NR | KAK2532735.1 | 135627 | g17033 | i0 | 81.3 | 3.5265306122449 | 32 | 6 | 39.2 | 0 | 6 | 101 | 235 | 266 | KAK2532735.1 Glb1l2 [Columba guinea] | diamond | 864 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Columba | Columba guinea | |
| 32511084 | 32511084 | PRJNA474426_P_NODE_19599_length_226_cov_1.644068_g19394_i0 | PRJNA474426 | 19599 | 226 | 1.644068 | 3.71559368 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 113 | 8.349999999999999e-28 | NR | KAK2705440.1 | 6661 | g19394 | i0 | 83.6 | 0.969026548672566 | 73 | 12 | 96.9 | 0 | 226 | 8 | 170 | 242 | KAK2705440.1 hypothetical protein QYM36_015728 [Artemia franciscana] | diamond | 219 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 32715999 | 32715999 | PRJNA474426_P_NODE_8080_length_380_cov_2.063444_g7875_i0 | PRJNA474426 | 8080 | 380 | 2.063444 | 7.8410872 | Chiroptera | 9397 | Chordata | Chordata | 47.4 | 0.00358 | NR | ELK19605.1 | 9402 | g7875 | i0 | 71.4 | 3.30789473684211 | 28 | 8 | 22.1 | 0 | 154 | 237 | 52 | 79 | ELK19605.1 MORN repeat-containing protein 1 [Pteropus alecto] | diamond | 1257 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Pteropus | Pteropus alecto |
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);;