contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA694557" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19800356 | 19800356 | PRJNA694557_P_NODE_3296_length_848_cov_3.718710_g3098_i0 | PRJNA694557 | 3296 | 848 | 3.71871 | 31.5346608 | Chironomus tepperi | 113505 | Arthropoda | Arthropoda | 204 | 4.3799999999999995e-61 | NR | XP_070507736.1 | 113505 | g3098 | i0 | 51.7 | 0.841981132075472 | 238 | 108 | 83.1 | 3 | 27 | 731 | 1 | 234 | XP_070507736.1 large ribosomal subunit protein mL64 [Chironomus tepperi] | diamond | 714 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus tepperi | |
| 26619072 | 26619072 | PRJNA694557_P_NODE_10761_length_412_cov_2.368732_g10541_i0 | PRJNA694557 | 10761 | 412 | 2.368732 | 9.75917584 | Metazoa | 33208 | Annelida | Annelida | 60.8 | 5.29e-8 | NR | CAH1784968.1 | 6347 | g10541 | i0 | 60 | 4.07766990291262 | 40 | 16 | 29.1 | 0 | 2 | 121 | 146 | 185 | CAH1784968.1 unnamed protein product [Owenia fusiformis] | diamond | 1680 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26639391 | 26639391 | PRJNA694557_P_NODE_5661_length_618_cov_1.361468_g5443_i0 | PRJNA694557 | 5661 | 618 | 1.361468 | 8.41387224 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 47.8 | 0.0203 | NR | OWF52509.1 | 6573 | g5443 | i0 | 41.5 | 0.257281553398058 | 53 | 31 | 25.7 | 0 | 296 | 138 | 1487 | 1539 | OWF52509.1 Vacuolar protein sorting-associated protein 13D [Mizuhopecten yessoensis] | diamond | 159 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 26702566 | 26702566 | PRJNA694557_P_NODE_20781_length_272_cov_2.512563_g20561_i0 | PRJNA694557 | 20781 | 272 | 2.512563 | 6.83417136 | Ixodes scapularis | 6945 | Arthropoda | Arthropoda | 61.6 | 1.66e-9 | NR | EEC09865.1 | 6945 | g20561 | i0 | 71.1 | 1.74264705882353 | 38 | 11 | 41.9 | 0 | 226 | 113 | 21 | 58 | EEC09865.1 ribosomal protein, putative [Ixodes scapularis] | diamond | 474 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes scapularis | |
| 26797740 | 26797740 | PRJNA694557_P_NODE_5541_length_625_cov_6.130435_g5323_i0 | PRJNA694557 | 5541 | 625 | 6.130435 | 38.31521875 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 105 | 1.71e-22 | NR | CAF0893266.1 | 104777 | g5323 | i0 | 41.5 | 1.5504 | 142 | 77 | 66.7 | 4 | 89 | 505 | 185 | 323 | CAF0893266.1 unnamed protein product [Brachionus calyciflorus] | diamond | 969 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27398775 | 27398775 | PRJNA694557_P_NODE_8183_length_489_cov_5.836538_g7963_i0 | PRJNA694557 | 8183 | 489 | 5.836538 | 28.54067082 | Camelus bactrianus | 9837 | Chordata | Chordata | 48.9 | 0.0025 | NR | XP_045369741.1 | 9837 | g7963 | i0 | 65.6 | 0.196319018404908 | 32 | 11 | 19.6 | 0 | 27 | 122 | 308 | 339 | XP_045369741.1 RNA-binding protein Musashi homolog 2 isoform X4 [Camelus bactrianus] | diamond | 96 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus bactrianus | |
| 27777681 | 27777681 | PRJNA694557_P_NODE_12204_length_381_cov_2.795455_g11984_i0 | PRJNA694557 | 12204 | 381 | 2.795455 | 10.65068355 | Staurois parvus | 386267 | Chordata | Chordata | 68.2 | 5.24e-12 | NR | CAI9547784.1 | 386267 | g11984 | i0 | 52.7 | 0.858267716535433 | 55 | 26 | 43.3 | 0 | 238 | 74 | 5 | 59 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 327 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28440736 | 28440736 | PRJNA694557_P_NODE_22646_length_256_cov_5.644809_g22426_i0 | PRJNA694557 | 22646 | 256 | 5.644809 | 14.45071104 | Galemys pyrenaicus | 202257 | Chordata | Chordata | 58.2 | 1.43e-7 | NR | KAG8509257.1 | 202257 | g22426 | i0 | 42 | 12.99609375 | 81 | 41 | 94.9 | 2 | 2 | 244 | 48 | 122 | KAG8509257.1 LOW QUALITY PROTEIN: CCR4-NOT transcription complex subunit 8 [Galemys pyrenaicus] | diamond | 3327 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Galemys | Galemys pyrenaicus | |
| 28546889 | 28546889 | PRJNA694557_P_NODE_9247_length_453_cov_3.178947_g9027_i0 | PRJNA694557 | 9247 | 453 | 3.178947 | 14.40062991 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 1.52e-8 | NR | KAJ8019869.1 | 206669 | g9027 | i0 | 47.4 | 2.13245033112583 | 57 | 30 | 37.7 | 0 | 180 | 350 | 279 | 335 | KAJ8019869.1 DnaJ-like subfamily C member 22 [Holothuria leucospilota] | diamond | 966 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28630245 | 28630245 | PRJNA694557_P_NODE_26307_length_235_cov_3.055556_g26087_i0 | PRJNA694557 | 26307 | 235 | 3.055556 | 7.1805566 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 112 | 4.31e-27 | NR | KAK2721442.1 | 6661 | g26087 | i0 | 73.3 | 1.91489361702128 | 75 | 20 | 95.7 | 0 | 226 | 2 | 226 | 300 | KAK2721442.1 hypothetical protein QYM36_003662, partial [Artemia franciscana] | diamond | 450 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 28724770 | 28724770 | PRJNA694557_P_NODE_5907_length_602_cov_6.939509_g5688_i0 | PRJNA694557 | 5907 | 602 | 6.939509 | 41.77584418 | Varroa destructor | 109461 | Arthropoda | Arthropoda | 84 | 3.96e-16 | NR | XP_022644639.1 | 109461 | g5688 | i0 | 54.3 | 3.06976744186047 | 70 | 32 | 34.9 | 0 | 601 | 392 | 134 | 203 | XP_022644639.1 ras-related C3 botulinum toxin substrate 1-like [Varroa destructor] | diamond | 1848 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa destructor | |
| 29198518 | 29198518 | PRJNA694557_P_NODE_11569_length_394_cov_3.797508_g11349_i0 | PRJNA694557 | 11569 | 394 | 3.797508 | 14.96218152 | Moschus berezovskii | 68408 | Chordata | Chordata | 42.4 | 0.0448 | NR | XP_055282863.1 | 68408 | g11349 | i0 | 51.3 | 0.296954314720812 | 39 | 19 | 29.7 | 0 | 240 | 124 | 16 | 54 | XP_055282863.1 uncharacterized protein LOC129556743 isoform X2 [Moschus berezovskii] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Moschidae | Moschus | Moschus berezovskii | |
| 29241314 | 29241314 | PRJNA694557_P_NODE_26049_length_239_cov_2.734940_g25829_i0 | PRJNA694557 | 26049 | 239 | 2.73494 | 6.5365066 | Metazoa | 33208 | Mollusca | Mollusca | 107 | 3.9600000000000006e-27 | NR | XP_012941389.2 | 6500 | g25829 | i0 | 66.7 | 13.7071129707113 | 78 | 26 | 97.9 | 0 | 236 | 3 | 31 | 108 | XP_012941389.2 tubulin alpha-1 chain, partial [Aplysia californica] | diamond | 3276 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29734831 | 29734831 | PRJNA694557_P_NODE_3130_length_873_cov_3.711250_g2937_i0 | PRJNA694557 | 3130 | 873 | 3.71125 | 32.3992125 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 156 | 1.49e-41 | NR | RNA00747.1 | 10195 | g2937 | i0 | 57.9 | 0.415807560137457 | 121 | 48 | 41.6 | 1 | 592 | 230 | 85 | 202 | RNA00747.1 beta-1-4-galactosyltransferase 4 [Brachionus plicatilis] | diamond | 363 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29829800 | 29829800 | PRJNA694557_P_NODE_27111_length_213_cov_4.100000_g26891_i0 | PRJNA694557 | 27111 | 213 | 4.1 | 8.733 | Petromyzon marinus | 7757 | Chordata | Chordata | 44.7 | 0.00463 | NR | XP_032807750.1 | 7757 | g26891 | i0 | 63.6 | 2.40845070422535 | 33 | 12 | 46.5 | 0 | 110 | 208 | 15 | 47 | XP_032807750.1 BTB/POZ domain-containing protein 19 isoform X2 [Petromyzon marinus] | diamond | 513 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 29893224 | 29893224 | PRJNA694557_P_NODE_18351_length_295_cov_2.936937_g18131_i0 | PRJNA694557 | 18351 | 295 | 2.936937 | 8.66396415 | Ceratitis capitata | 7213 | Arthropoda | Arthropoda | 49.3 | 7.22e-5 | NR | CAD7011254.1 | 7213 | g18131 | i0 | 59 | 0.396610169491525 | 39 | 16 | 39.7 | 0 | 217 | 101 | 85 | 123 | CAD7011254.1 unnamed protein product [Ceratitis capitata] | diamond | 117 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 30367367 | 30367367 | PRJNA694557_P_NODE_18532_length_293_cov_3.154545_g18312_i0 | PRJNA694557 | 18532 | 293 | 3.154545 | 9.24281685 | Sturnus vulgaris | 9172 | Chordata | Chordata | 57 | 6.67e-7 | NR | XP_014742936.1 | 9172 | g18312 | i0 | 48.2 | 1.59726962457338 | 85 | 31 | 86 | 3 | 258 | 7 | 52 | 124 | XP_014742936.1 PREDICTED: protein DDX26B-like isoform X1 [Sturnus vulgaris] | diamond | 468 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sturnidae | Sturnus | Sturnus vulgaris | |
| 30809274 | 30809274 | PRJNA694557_P_NODE_12554_length_374_cov_1.647841_g12334_i0 | PRJNA694557 | 12554 | 374 | 1.647841 | 6.16292534 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 64.7 | 2.92e-9 | NR | KAK2725871.1 | 6661 | g12334 | i0 | 59.3 | 2.40641711229947 | 54 | 22 | 43.3 | 0 | 331 | 170 | 37 | 90 | KAK2725871.1 hypothetical protein QYM36_000368 [Artemia franciscana] | diamond | 900 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 31136233 | 31136233 | PRJNA694557_P_NODE_24035_length_248_cov_1.560000_g23815_i0 | PRJNA694557 | 24035 | 248 | 1.56 | 3.8688 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 55.8 | 9.66e-7 | NR | RMX52769.1 | 46731 | g23815 | i0 | 46 | 3.03629032258065 | 63 | 34 | 76.2 | 0 | 35 | 223 | 235 | 297 | RMX52769.1 hypothetical protein pdam_00014228 [Pocillopora damicornis] | diamond | 753 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31251590 | 31251590 | PRJNA694557_P_NODE_7375_length_524_cov_2.252772_g7155_i0 | PRJNA694557 | 7375 | 524 | 2.252772 | 11.80452528 | Pseudolycoriella hygida | 35572 | Arthropoda | Arthropoda | 101 | 3.24e-21 | NR | KAJ6638648.1 | 35572 | g7155 | i0 | 52.2 | 1.58015267175573 | 92 | 44 | 52.7 | 0 | 247 | 522 | 1091 | 1182 | KAJ6638648.1 Phospholipid-transporting ATPase ABCA3 [Pseudolycoriella hygida] | diamond | 828 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Sciaridae | Pseudolycoriella | Pseudolycoriella hygida | |
| 31409860 | 31409860 | PRJNA694557_P_NODE_11696_length_392_cov_2.147335_g11476_i0 | PRJNA694557 | 11696 | 392 | 2.147335 | 8.4175532 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 159 | 2.1699999999999998e-42 | NR | KAK3882625.1 | 88211 | g11476 | i0 | 65.8 | 2.68622448979592 | 117 | 36 | 89.5 | 2 | 373 | 23 | 829 | 941 | KAK3882625.1 hypothetical protein Pcinc_012994 [Petrolisthes cinctipes] | diamond | 1053 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 31421140 | 31421140 | PRJNA694557_P_NODE_15716_length_325_cov_6.150794_g15496_i0 | PRJNA694557 | 15716 | 325 | 6.150794 | 19.9900805 | Bovidae | 9895 | Chordata | Chordata | 50.8 | 1.38e-4 | NR | DAA12893.1 | 9913 | g15496 | i0 | 67.6 | 1.37538461538462 | 37 | 12 | 34.2 | 0 | 131 | 21 | 1 | 37 | DAA12893.1 TPA: GK22061-like [Bos taurus] | diamond | 447 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 31631147 | 31631147 | PRJNA694557_P_NODE_22416_length_258_cov_3.681081_g22196_i0 | PRJNA694557 | 22416 | 258 | 3.681081 | 9.49718898 | Parthenolecanium corni | 536013 | Arthropoda | Arthropoda | 75.5 | 1.33e-13 | NR | KAK7580690.1 | 536013 | g22196 | i0 | 76.8 | 0.953488372093023 | 82 | 19 | 95.3 | 0 | 3 | 248 | 1036 | 1117 | KAK7580690.1 hypothetical protein V9T40_001319 [Parthenolecanium corni] | diamond | 246 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Coccidae | Parthenolecanium | Parthenolecanium corni | |
| 31884182 | 31884182 | PRJNA694557_P_NODE_8517_length_477_cov_2.465347_g8297_i0 | PRJNA694557 | 8517 | 477 | 2.465347 | 11.75970519 | Trichonephila clavipes | 2585209 | Arthropoda | Arthropoda | 45.8 | 0.0264 | NR | GFX97711.1 | 2585209 | g8297 | i0 | 30.6 | 0.69811320754717 | 111 | 66 | 67.3 | 2 | 109 | 429 | 17 | 120 | GFX97711.1 transposable element Tcb1 transposase [Trichonephila clavipes] | diamond | 333 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Trichonephila | Trichonephila clavipes |
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);;