contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1098727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7863822 | 7863822 | PRJNA1098727_P_NODE_15607_length_162_cov_0.920354_g15366_i0 | PRJNA1098727 | 15607 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Nematoda | Nematoda | 87.4 | 2.29e-18 | NR | KHN74648.1 | 6265 | g15366 | i0 | 82.4 | 24.5555555555556 | 51 | 9 | 94.4 | 0 | 153 | 1 | 4 | 54 | KHN74648.1 40S ribosomal protein S3a [Toxocara canis] | diamond | 3978 | 87.8 | 0.995444191343964 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 26687757 | 26687757 | PRJNA1098727_P_NODE_2701_length_414_cov_3.430137_g2461_i0 | PRJNA1098727 | 2701 | 414 | 3.430137 | 14.20076718 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 46.6 | 0.0086 | NR | XP_062599881.1 | 36930 | g2461 | i0 | 32.2 | 0.427536231884058 | 59 | 40 | 42.8 | 0 | 213 | 389 | 21 | 79 | XP_062599881.1 uncharacterized protein LOC134261454 [Saccostrea cuccullata] | diamond | 177 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 26995446 | 26995446 | PRJNA1098727_P_NODE_10522_length_187_cov_1.318841_g10281_i0 | PRJNA1098727 | 10522 | 187 | 1.318841 | 2.46623267 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.1 | 5.46e-21 | NR | XP_054270932.1 | 74068 | g10281 | i0 | 74.5 | 24.1122994652406 | 47 | 12 | 75.4 | 0 | 3 | 143 | 117 | 163 | XP_054270932.1 adenosine 5'-monophosphoramidase HINT1-like isoform X1 [Macrosteles quadrilineatus] | diamond | 4509 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cicadellidae | Macrosteles | Macrosteles quadrilineatus | |
| 27004261 | 27004261 | PRJNA1098727_P_NODE_5602_length_268_cov_0.831050_g5361_i0 | PRJNA1098727 | 5602 | 268 | 0.83105 | 2.227214 | Bufotes viridis | 30338 | Chordata | Chordata | 43.5 | 0.025 | NR | CAK8629749.1 | 30338 | g5361 | i0 | 66.7 | 0.57089552238806 | 30 | 10 | 33.6 | 0 | 173 | 84 | 331 | 360 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 153 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27817297 | 27817297 | PRJNA1098727_P_NODE_14664_length_164_cov_1.582609_g14423_i0 | PRJNA1098727 | 14664 | 164 | 1.582609 | 2.59547876 | Artiodactyla | 91561 | Chordata | Chordata | 58.2 | 4.63e-8 | NR | XP_069396403.1 | 9728 | g14423 | i0 | 90.3 | 2.72560975609756 | 31 | 3 | 56.7 | 0 | 161 | 69 | 156 | 186 | XP_069396403.1 collagen alpha-1(I) chain-like, partial [Delphinus delphis] | diamond | 447 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Delphinus | Delphinus delphis | |
| 27857265 | 27857265 | PRJNA1098727_P_NODE_12885_length_169_cov_0.866667_g12644_i0 | PRJNA1098727 | 12885 | 169 | 0.866667 | 1.46466723 | Fukomys damarensis | 885580 | Chordata | Chordata | 73.2 | 2.58e-13 | NR | XP_033614349.1 | 885580 | g12644 | i0 | 71.4 | 1.98816568047337 | 56 | 16 | 99.4 | 0 | 2 | 169 | 1416 | 1471 | XP_033614349.1 multidrug resistance-associated protein 1 isoform X3 [Fukomys damarensis] | diamond | 336 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Fukomys | Fukomys damarensis | |
| 28015352 | 28015352 | PRJNA1098727_P_NODE_15705_length_162_cov_0.920354_g15464_i0 | PRJNA1098727 | 15705 | 162 | 0.920354 | 1.49097348 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 76.3 | 1.78e-14 | NR | CAF0752623.1 | 104777 | g15464 | i0 | 100 | 0.666666666666667 | 36 | 0 | 66.7 | 0 | 46 | 153 | 392 | 427 | CAF0752623.1 unnamed protein product [Brachionus calyciflorus] | diamond | 108 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28520483 | 28520483 | PRJNA1098727_P_NODE_6467_length_246_cov_1.563452_g6226_i0 | PRJNA1098727 | 6467 | 246 | 1.563452 | 3.84609192 | Daphnia magna | 35525 | Arthropoda | Arthropoda | 40.4 | 0.0401 | NR | KZR97555.1 | 35525 | g6226 | i0 | 73.9 | 0.280487804878049 | 23 | 6 | 28 | 0 | 210 | 142 | 2 | 24 | KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] | diamond | 69 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia magna | |
| 28638203 | 28638203 | PRJNA1098727_P_NODE_15687_length_162_cov_0.920354_g15446_i0 | PRJNA1098727 | 15687 | 162 | 0.920354 | 1.49097348 | Chordata | 7711 | Chordata | Chordata | 49.7 | 2.7e-5 | NR | KAG2458726.1 | 55291 | g15446 | i0 | 56 | 21.5185185185185 | 50 | 22 | 92.6 | 0 | 159 | 10 | 14 | 63 | KAG2458726.1 ORML1 protein, partial [Polypterus senegalus] | diamond | 3486 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30320947 | 30320947 | PRJNA1098727_P_NODE_12932_length_169_cov_0.866667_g12691_i0 | PRJNA1098727 | 12932 | 169 | 0.866667 | 1.46466723 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 55.1 | 6.19e-7 | NR | XP_064637995.1 | 88925 | g12691 | i0 | 47.9 | 1.7396449704142 | 48 | 25 | 85.2 | 0 | 145 | 2 | 144 | 191 | XP_064637995.1 ubiquitin carboxyl-terminal hydrolase 36-like isoform X2 [Lineus longissimus] | diamond | 294 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 31331542 | 31331542 | PRJNA1098727_P_NODE_15296_length_163_cov_0.912281_g15055_i0 | PRJNA1098727 | 15296 | 163 | 0.912281 | 1.48701803 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 45.8 | 8.48e-4 | NR | KAJ8025874.1 | 206669 | g15055 | i0 | 51 | 1.93251533742331 | 49 | 23 | 90.2 | 1 | 3 | 149 | 128 | 175 | KAJ8025874.1 Ras-related protein Rab-24 [Holothuria leucospilota] | diamond | 315 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31521512 | 31521512 | PRJNA1098727_P_NODE_8136_length_216_cov_1.119760_g7895_i0 | PRJNA1098727 | 8136 | 216 | 1.11976 | 2.4186816 | Lottia gigantea | 225164 | Mollusca | Mollusca | 91.7 | 5.7500000000000005e-21 | NR | XP_009049886.1 | 225164 | g7895 | i0 | 68.1 | 32.6111111111111 | 69 | 22 | 95.8 | 0 | 208 | 2 | 25 | 93 | XP_009049886.1 hypothetical protein LOTGIDRAFT_178048 [Lottia gigantea] | diamond | 7044 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 31607598 | 31607598 | PRJNA1098727_P_NODE_14776_length_164_cov_0.904348_g14535_i0 | PRJNA1098727 | 14776 | 164 | 0.904348 | 1.48313072 | Metazoa | 33208 | Priapulida | other_Eukaryota | 58.2 | 4.28e-8 | NR | XP_014679392.1 | 37621 | g14535 | i0 | 59.3 | 10.8658536585366 | 54 | 22 | 98.8 | 0 | 162 | 1 | 80 | 133 | XP_014679392.1 PREDICTED: tubulin alpha-8 chain-like [Priapulus caudatus] | diamond | 1782 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 32312579 | 32312579 | PRJNA1098727_P_NODE_13119_length_168_cov_0.873950_g12878_i0 | PRJNA1098727 | 13119 | 168 | 0.87395 | 1.468236 | Sitodiplosis mosellana | 263140 | Arthropoda | Arthropoda | 114 | 8.280000000000001e-29 | NR | XP_055305540.1 | 263140 | g12878 | i0 | 90.9 | 0.982142857142857 | 55 | 5 | 98.2 | 0 | 2 | 166 | 229 | 283 | XP_055305540.1 venom protease-like isoform X2 [Sitodiplosis mosellana] | diamond | 165 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Cecidomyiidae | Sitodiplosis | Sitodiplosis mosellana | |
| 32691229 | 32691229 | PRJNA1098727_P_NODE_9740_length_194_cov_3.075862_g9499_i0 | PRJNA1098727 | 9740 | 194 | 3.075862 | 5.96717228 | Heterocephalus glaber | 10181 | Chordata | Chordata | 43.1 | 0.0143 | NR | XP_012924134.2 | 10181 | g9499 | i0 | 58.6 | 0.448453608247423 | 29 | 12 | 44.8 | 0 | 192 | 106 | 221 | 249 | XP_012924134.2 LOW QUALITY PROTEIN: zinc finger protein 627-like [Heterocephalus glaber] | diamond | 87 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Heterocephalus | Heterocephalus glaber | |
| 32785671 | 32785671 | PRJNA1098727_P_NODE_11500_length_178_cov_1.565891_g11259_i0 | PRJNA1098727 | 11500 | 178 | 1.565891 | 2.78728598 | Bufotes viridis | 30338 | Chordata | Chordata | 42.4 | 0.0215 | NR | CAK8629749.1 | 30338 | g11259 | i0 | 63.3 | 0.50561797752809 | 30 | 11 | 50.6 | 0 | 7 | 96 | 331 | 360 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 90 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 32902982 | 32902982 | PRJNA1098727_P_NODE_9500_length_197_cov_3.040541_g9259_i0 | PRJNA1098727 | 9500 | 197 | 3.040541 | 5.98986577 | Lamniformes | 30496 | Chordata | Chordata | 46.6 | 8.78e-4 | NR | XP_041068779.1 | 13397 | g9259 | i0 | 65.5 | 1.30964467005076 | 29 | 10 | 44.2 | 0 | 106 | 20 | 443 | 471 | XP_041068779.1 homeobox protein Meis1a isoform X4 [Carcharodon carcharias] | diamond | 258 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Lamniformes | Alopiidae | Carcharodon | Carcharodon carcharias |
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);;