contig_metadata
22 rows where bioproject = "PRJNA556842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3072721 | 3072721 | PRJNA556842_P_NODE_15563_length_168_cov_1.145038_g15058_i0 | PRJNA556842 | 15563 | 168 | 1.145038 | 1.92366384 | Zeugodacus cucurbitae | 28588 | Arthropoda | Arthropoda | 52.8 | 0.014 | NTclustered | gi|2460017187|ref|XM_011186644.3| | 28588 | g15058 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 10 | 37 | 6951 | 6978 | PREDICTED: Zeugodacus cucurbitae IDLSRF-like peptide (LOC105213665), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Zeugodacus | Zeugodacus cucurbitae | |
| 6227810 | 6227810 | PRJNA556842_P_NODE_3125_length_554_cov_16.705996_g2661_i0 | PRJNA556842 | 3125 | 554 | 16.705996 | 92.55121784 | Staphylinidae | 29026 | Arthropoda | Arthropoda | 209 | 3.06e-49 | NTclustered | gi|693464834|gb|KJ844884.1| | 1541375 | g2661 | i0 | 74.582 | 12.956678700361 | 598 | 94 | 99 | 42 | 4 | 554 | 922 | 336 | Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence | blastn | 7178 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Staphylinidae | Pselaptrichus | Pselaptrichus sp. DDM1181 | |
| 10052581 | 10052581 | PRJNA556842_P_NODE_16248_length_162_cov_1.696000_g15743_i0 | PRJNA556842 | 16248 | 162 | 1.696 | 2.74752 | Insecta | 50557 | Arthropoda | Arthropoda | 182 | 1.6499999999999996e-41 | NTclustered | gi|2733082149|emb|OX466067.1| | 7070 | g15743 | i0 | 93.496 | 68.7839506172839 | 123 | 7 | 78 | 1 | 40 | 162 | 1520426 | 1520547 | Tribolium castaneum genome assembly, chromosome: LG7 | blastn | 11143 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tribolium | Tribolium castaneum | |
| 10725964 | 10725964 | PRJNA556842_P_NODE_169_length_2257_cov_35.410811_g105_i0 | PRJNA556842 | 169 | 2257 | 35.410811 | 799.22200427 | Opisthokonta | 33154 | Brachiopoda | other_Eukaryota | 633 | 1.2499999999999999e-216 | NR | XP_013400629.1 | 7574 | g105 | i0 | 60.1 | 87.2578644217988 | 536 | 196 | 69 | 3 | 200 | 1756 | 65 | 599 | XP_013400629.1 heat shock cognate 71 kDa protein [Lingula anatina] | diamond | 196941 | 636 | 0.995283018867924 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 12603117 | 12603117 | PRJNA556842_P_NODE_3430_length_521_cov_16.450413_g2951_i0 | PRJNA556842 | 3430 | 521 | 16.450413 | 85.70665173 | Insecta | 50557 | Arthropoda | Arthropoda | 388 | 3.4299999999999996e-103 | NTclustered | gi|2209605878|ref|XR_006974651.1| | 7009 | g2951 | i0 | 96.203 | 67.6545105566219 | 237 | 9 | 69 | 0 | 1 | 237 | 3573 | 3337 | PREDICTED: Schistocerca americana large subunit ribosomal RNA (LOC124584255), rRNA | blastn | 35248 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca americana | |
| 14550815 | 14550815 | PRJNA556842_P_NODE_10992_length_224_cov_1.320856_g10487_i0 | PRJNA556842 | 10992 | 224 | 1.320856 | 2.95871744 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 176 | 1.13e-39 | NTclustered | gi|2327557302|ref|XM_028813649.2| | 27687 | g10487 | i0 | 81.614 | 25.1383928571429 | 223 | 31 | 96 | 8 | 1 | 215 | 3145 | 3365 | PREDICTED: Erpetoichthys calabaricus ras homolog gene family, member Aa (rhoaa), mRNA | blastn | 5631 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 15824553 | 15824553 | PRJNA556842_P_NODE_5293_length_394_cov_2.008403_g4794_i0 | PRJNA556842 | 5293 | 394 | 2.008403 | 7.91310782 | Pseudoterpna coronillaria | 1007376 | Arthropoda | Arthropoda | 56.5 | 0.003 | NTclustered | gi|2918369770|emb|OZ237837.1| | 1007376 | g4794 | i0 | 92.5 | 0.101522842639594 | 40 | 2 | 10 | 1 | 2 | 41 | 5854551 | 5854513 | Pseudoterpna coronillaria genome assembly, chromosome: 12 | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Geometridae | Pseudoterpna | Pseudoterpna coronillaria | |
| 19648136 | 19648136 | PRJNA556842_P_NODE_15096_length_172_cov_1.118519_g14591_i0 | PRJNA556842 | 15096 | 172 | 1.118519 | 1.92385268 | Anthonomus grandis | 7044 | Arthropoda | Arthropoda | 307 | 2.79e-79 | NTclustered | gi|2293499837|ref|XR_007665257.1| | 2921223 | g14591 | i0 | 98.837 | 105 | 172 | 2 | 100 | 0 | 1 | 172 | 2145 | 1974 | PREDICTED: Anthonomus grandis grandis large subunit ribosomal RNA (LOC126749694), rRNA | blastn | 18060 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Curculionidae | Anthonomus | Anthonomus grandis | |
| 23474214 | 23474214 | PRJNA556842_P_NODE_11639_length_212_cov_6.822857_g11134_i0 | PRJNA556842 | 11639 | 212 | 6.822857 | 14.46445684 | Liposcelidae sp. B1763 | 322491 | Arthropoda | Arthropoda | 392 | 9.67e-105 | NTclustered | gi|62529117|gb|AY900135.1| | 322491 | g11134 | i0 | 100 | 99.0188679245283 | 212 | 0 | 100 | 0 | 1 | 212 | 1833 | 1622 | Liposcelidae sp. B1763 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20992 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelidae sp. B1763 | ||
| 23474226 | 23474226 | PRJNA556842_P_NODE_3619_length_503_cov_6.375536_g3135_i0 | PRJNA556842 | 3619 | 503 | 6.375536 | 32.06894608 | Schistocerca americana | 7009 | Arthropoda | Arthropoda | 172 | 3.62e-38 | NTclustered | gi|2209603692|ref|XR_006972637.1| | 7009 | g3135 | i0 | 84.571 | 129.699801192843 | 175 | 25 | 35 | 2 | 1 | 174 | 3725 | 3898 | PREDICTED: Schistocerca americana large subunit ribosomal RNA (LOC124577385), rRNA | blastn | 65239 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca americana | |
| 25350511 | 25350511 | PRJNA556842_P_NODE_16440_length_160_cov_3.894309_g15935_i0 | PRJNA556842 | 16440 | 160 | 3.894309 | 6.2308944 | Chordata | 7711 | Chordata | Chordata | 52.8 | 0.013 | NTclustered | gi|2721460824|emb|HG999682.4| | 9103 | g15935 | i0 | 100 | 0.35 | 28 | 0 | 18 | 0 | 74 | 101 | 32418365 | 32418392 | Meleagris gallopavo genome assembly, chromosome: 3 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 25350514 | 25350514 | PRJNA556842_P_NODE_17180_length_155_cov_1.966102_g16675_i0 | PRJNA556842 | 17180 | 155 | 1.966102 | 3.0474581 | Metazoa | 33208 | Mollusca | Mollusca | 71.3 | 3.52e-8 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g16675 | i0 | 93.617 | 25.2774193548387 | 47 | 3 | 30 | 0 | 1 | 47 | 18004735 | 18004781 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 3918 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27250826 | 27250826 | PRJNA556842_P_NODE_383_length_1657_cov_7.925309_g247_i0 | PRJNA556842 | 383 | 1657 | 7.925309 | 131.32237013 | Metazoa | 33208 | Annelida | Annelida | 135 | 4.11e-33 | NR | CAH1798937.1 | 6347 | g247 | i0 | 47.4 | 7.8159324079662 | 156 | 76 | 28.2 | 1 | 367 | 834 | 29 | 178 | CAH1798937.1 unnamed protein product [Owenia fusiformis] | diamond | 12951 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27773384 | 27773384 | PRJNA556842_P_NODE_4444_length_443_cov_4.133005_g3948_i0 | PRJNA556842 | 4444 | 443 | 4.133005 | 18.30921215 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 5.8e-6 | NR | CAI9557087.1 | 386267 | g3948 | i0 | 63.9 | 0.487584650112867 | 36 | 11 | 23 | 1 | 235 | 336 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28689096 | 28689096 | PRJNA556842_P_NODE_17047_length_156_cov_1.983193_g16542_i0 | PRJNA556842 | 17047 | 156 | 1.983193 | 3.09378108 | Staurois parvus | 386267 | Chordata | Chordata | 40.4 | 0.00759 | NR | CAI9622433.1 | 386267 | g16542 | i0 | 78.9 | 0.365384615384615 | 19 | 4 | 36.5 | 0 | 3 | 59 | 14 | 32 | CAI9622433.1 unnamed protein product, partial [Staurois parvus] | diamond | 57 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29320260 | 29320260 | PRJNA556842_P_NODE_15949_length_164_cov_2.968504_g15444_i0 | PRJNA556842 | 15949 | 164 | 2.968504 | 4.86834656 | Harpegnathos saltator | 610380 | Arthropoda | Arthropoda | 48.5 | 9.78e-5 | NR | XP_011137057.1 | 610380 | g15444 | i0 | 73.3 | 0.548780487804878 | 30 | 8 | 54.9 | 0 | 157 | 68 | 1 | 30 | XP_011137057.1 uncharacterized protein LOC105181771 [Harpegnathos saltator] | diamond | 90 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Harpegnathos | Harpegnathos saltator | |
| 29414978 | 29414978 | PRJNA556842_P_NODE_10129_length_240_cov_2.502463_g9624_i0 | PRJNA556842 | 10129 | 240 | 2.502463 | 6.0059112 | Adineta environmental sample | 1193592 | Rotifera | other_Eukaryota | 53.5 | 3.4e-7 | NR | XBW52376.1 | 1193592 | g9624 | i0 | 64 | 0.625 | 50 | 18 | 62.5 | 0 | 2 | 151 | 31 | 80 | XBW52376.1 ice-binding family protein, partial [Adineta environmental sample] | diamond | 150 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta environmental sample | |
| 29793804 | 29793804 | PRJNA556842_P_NODE_7991_length_292_cov_1.968627_g7487_i0 | PRJNA556842 | 7991 | 292 | 1.968627 | 5.74839084 | Bufotes viridis | 30338 | Chordata | Chordata | 43.1 | 0.0447 | NR | CAK8629749.1 | 30338 | g7487 | i0 | 60 | 0.35958904109589 | 35 | 14 | 36 | 0 | 200 | 96 | 329 | 363 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 105 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29920455 | 29920455 | PRJNA556842_P_NODE_16031_length_164_cov_1.220472_g15526_i0 | PRJNA556842 | 16031 | 164 | 1.220472 | 2.00157408 | Idotea baltica | 82763 | Arthropoda | Arthropoda | 70.5 | 3.26e-13 | NR | MCL4120794.1 | 82763 | g15526 | i0 | 63 | 0.98780487804878 | 54 | 20 | 98.8 | 0 | 164 | 3 | 138 | 191 | MCL4120794.1 hypothetical protein [Idotea baltica] | diamond | 162 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 30204372 | 30204372 | PRJNA556842_P_NODE_12912_length_195_cov_1.120253_g12407_i0 | PRJNA556842 | 12912 | 195 | 1.120253 | 2.18449335 | Polypterus senegalus | 55291 | Chordata | Chordata | 65.1 | 2.32e-10 | NR | KAG2461018.1 | 55291 | g12407 | i0 | 60.4 | 3.15384615384615 | 53 | 21 | 81.5 | 0 | 195 | 37 | 287 | 339 | KAG2461018.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 615 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30583596 | 30583596 | PRJNA556842_P_NODE_1193_length_965_cov_38.913793_g888_i0 | PRJNA556842 | 1193 | 965 | 38.913793 | 375.51810245 | Polypedilum vanderplanki | 319348 | Arthropoda | Arthropoda | 70.9 | 1.42e-9 | NR | KAG5668960.1 | 319348 | g888 | i0 | 35.7 | 0.391709844559586 | 126 | 78 | 38.9 | 3 | 876 | 502 | 267 | 390 | KAG5668960.1 hypothetical protein PVAND_016866 [Polypedilum vanderplanki] | diamond | 378 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Polypedilum | Polypedilum vanderplanki | |
| 32006530 | 32006530 | PRJNA556842_P_NODE_16978_length_157_cov_1.025000_g16473_i0 | PRJNA556842 | 16978 | 157 | 1.025 | 1.60925 | Colius striatus | 57412 | Chordata | Chordata | 43.5 | 0.00595 | NR | XP_061871356.1 | 57412 | g16473 | i0 | 39.6 | 0.917197452229299 | 48 | 25 | 91.7 | 1 | 149 | 6 | 273 | 316 | XP_061871356.1 lysophosphatidic acid receptor 2 isoform X2 [Colius striatus] | diamond | 144 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Coliiformes | Coliidae | Colius | Colius striatus |
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);;