contig_metadata
17 rows where bioproject = "PRJNA1009807" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154811 | 154811 | PRJNA1009807_S_NODE_2081_length_216_cov_1.593220_g2053_i0 | PRJNA1009807 | 2081 | 216 | 1.59322 | 3.4413552 | Timema genevievae | 629358 | Arthropoda | Arthropoda | 52.8 | 0.019 | NTclustered | gi|1964503389|emb|OE840646.1| | 629358 | g2053 | i0 | 100 | 0.12962962962963 | 28 | 0 | 13 | 0 | 79 | 106 | 115144 | 115171 | 5_Tge_b3v08 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema genevievae | |
| 3981241 | 3981241 | PRJNA1009807_S_NODE_3484_length_174_cov_3.600000_g3456_i0 | PRJNA1009807 | 3484 | 174 | 3.6 | 6.264 | Polypterus senegalus | 55291 | Chordata | Chordata | 195 | 2.3e-45 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g3456 | i0 | 90.132 | 9.79885057471264 | 152 | 12 | 86 | 3 | 1 | 150 | 1323 | 1173 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 1705 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 5257712 | 5257712 | PRJNA1009807_S_NODE_2205_length_210_cov_26.637427_g2177_i0 | PRJNA1009807 | 2205 | 210 | 26.637427 | 55.9385967 | Myolaimus byersi | 1811516 | Nematoda | Nematoda | 209 | 1.03e-49 | NTclustered | gi|1003466868|gb|KU180676.1| | 1811516 | g2177 | i0 | 85.507 | 99.5333333333333 | 207 | 23 | 98 | 7 | 6 | 210 | 1047 | 1248 | Myolaimus byersi 28S ribosomal RNA gene, partial sequence | blastn | 20902 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Myolaimidae | Myolaimus | Myolaimus byersi | |
| 5257751 | 5257751 | PRJNA1009807_S_NODE_905_length_314_cov_5.334545_g877_i0 | PRJNA1009807 | 905 | 314 | 5.334545 | 16.7504713 | Speleorchestes sp. AD1084 | 2051767 | Arthropoda | Arthropoda | 104 | 8e-18 | NTclustered | gi|1282187773|gb|KY921978.1| | 2051767 | g877 | i0 | 83.478 | 5.14012738853503 | 115 | 16 | 36 | 3 | 128 | 239 | 2454 | 2568 | Speleorchestes sp. AD1084 voucher UMMZ BMOC 07-0615-007 AD1084 28S ribosomal RNA gene, partial sequence | blastn | 1614 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Nanorchestidae | Speleorchestes | Speleorchestes sp. AD1084 | |
| 6532973 | 6532973 | PRJNA1009807_S_NODE_1406_length_255_cov_2.833333_g1378_i0 | PRJNA1009807 | 1406 | 255 | 2.833333 | 7.22499915 | Harbansus paucichelatus | 178850 | Arthropoda | Arthropoda | 99 | 2.93e-16 | NTclustered | gi|751143631|gb|KM875573.1| | 178850 | g1378 | i0 | 75.214 | 10.9333333333333 | 234 | 45 | 89 | 12 | 2 | 227 | 343 | 571 | Harbansus paucichelatus isolate M1 28S ribosomal RNA gene, partial sequence | blastn | 2788 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Myodocopida | Philomedidae | Harbansus | Harbansus paucichelatus | |
| 10357921 | 10357921 | PRJNA1009807_S_NODE_2469_length_200_cov_11.086957_g2441_i0 | PRJNA1009807 | 2469 | 200 | 11.086957 | 22.173914 | Galathea rostrata | 1377960 | Arthropoda | Arthropoda | 60.2 | 1.04e-4 | NTclustered | gi|527498840|gb|KF182504.1| | 1377960 | g2441 | i0 | 92.857 | 3.29 | 42 | 2 | 21 | 1 | 139 | 180 | 854 | 814 | Galathea rostrata voucher KC4767/ULLZ7681 18S ribosomal RNA gene, partial sequence | blastn | 658 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Galatheidae | Galathea | Galathea rostrata | |
| 12480208 | 12480208 | PRJNA1009807_S_NODE_2270_length_208_cov_3.248521_g2242_i0 | PRJNA1009807 | 2270 | 208 | 3.248521 | 6.75692368 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|1517521407|gb|MK190976.1| | 13016 | g2242 | i0 | 96.875 | 0.293269230769231 | 32 | 1 | 15 | 0 | 173 | 204 | 1229 | 1260 | Codakia orbicularis voucher SDSM:134093 large subunit ribosomal RNA gene, partial sequence | blastn | 61 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Codakia | Codakia orbicularis | |
| 14183465 | 14183465 | PRJNA1009807_S_NODE_3272_length_179_cov_1.442857_g3244_i0 | PRJNA1009807 | 3272 | 179 | 1.442857 | 2.58271403 | Timema cristinae | 61476 | Arthropoda | Arthropoda | 58.4 | 3.26e-4 | NTclustered | gi|1946878153|emb|OC316793.1| | 61476 | g3244 | i0 | 97.059 | 0.189944134078212 | 34 | 1 | 19 | 0 | 91 | 124 | 333653 | 333620 | 3_Tce_b3v08 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema cristinae | |
| 15457419 | 15457419 | PRJNA1009807_S_NODE_4593_length_156_cov_1.803419_g4565_i0 | PRJNA1009807 | 4593 | 156 | 1.803419 | 2.81333364 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 189 | 9.39e-44 | NTclustered | gi|2327563545|ref|XM_051935314.1| | 27687 | g4565 | i0 | 91.304 | 16.4551282051282 | 138 | 12 | 88 | 0 | 1 | 138 | 845 | 982 | PREDICTED: Erpetoichthys calabaricus E3 SUMO-protein ligase ZBED1-like (LOC127529930), mRNA | blastn | 2567 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 16303935 | 16303935 | PRJNA1009807_S_NODE_773_length_336_cov_34.175084_g745_i0 | PRJNA1009807 | 773 | 336 | 34.175084 | 114.82828224 | Metazoa | 33208 | Porifera | other_Eukaryota | 99 | 4.01e-16 | NTclustered | gi|1284883228|gb|KY825184.1| | 178514 | g745 | i0 | 79.452 | 7.19047619047619 | 146 | 24 | 43 | 4 | 193 | 336 | 3474 | 3333 | Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence | blastn | 2416 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon compressa | |
| 18853104 | 18853104 | PRJNA1009807_S_NODE_3635_length_171_cov_4.439394_g3607_i0 | PRJNA1009807 | 3635 | 171 | 4.439394 | 7.59136374 | Artemia | 6660 | Arthropoda | Arthropoda | 316 | 4.6e-82 | NTclustered | gi|2295022767|gb|OP365120.1| | 6661 | g3607 | i0 | 100 | 100.035087719298 | 171 | 0 | 100 | 0 | 1 | 171 | 756 | 586 | Artemia franciscana isolate soni103 small subunit ribosomal RNA gene, partial sequence | blastn | 17106 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 20127852 | 20127852 | PRJNA1009807_S_NODE_2596_length_196_cov_501.490446_g2568_i0 | PRJNA1009807 | 2596 | 196 | 501.490446 | 982.92127416 | root | 1 | Root_unresolved | Root_unresolved | 357 | 3.2099999999999996e-94 | NTclustered | gi|78097480|gb|AC167666.4| | 7176 | g2568 | i0 | 100 | 290.489795918367 | 193 | 0 | 98 | 0 | 4 | 196 | 1179 | 987 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence | blastn | 56936 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 26907941 | 26907941 | PRJNA1009807_S_NODE_122_length_663_cov_3.791667_g105_i0 | PRJNA1009807 | 122 | 663 | 3.791667 | 25.13875221 | Trichuris suis | 68888 | Nematoda | Nematoda | 52.4 | 6.44e-4 | NR | KFD59988.1 | 68888 | g105 | i0 | 41.3 | 0.470588235294118 | 104 | 51 | 43 | 3 | 466 | 182 | 207 | 309 | KFD59988.1 LOW QUALITY PROTEIN: hypothetical protein M514_27836 [Trichuris suis] | diamond | 312 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 27603429 | 27603429 | PRJNA1009807_S_NODE_4064_length_164_cov_1.480000_g4036_i0 | PRJNA1009807 | 4064 | 164 | 1.48 | 2.4272 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 57.4 | 8.58e-8 | NR | KAA3669829.1 | 34504 | g4036 | i0 | 54 | 1.82926829268293 | 50 | 23 | 91.5 | 0 | 162 | 13 | 180 | 229 | KAA3669829.1 uncharacterized protein DEA37_0001408, partial [Paragonimus westermani] | diamond | 300 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 27824400 | 27824400 | PRJNA1009807_S_NODE_1864_length_227_cov_2.148936_g1836_i0 | PRJNA1009807 | 1864 | 227 | 2.148936 | 4.87808472 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 42.7 | 0.0298 | NR | CAH3174760.1 | 104759 | g1836 | i0 | 50 | 0.475770925110132 | 36 | 18 | 47.6 | 0 | 46 | 153 | 363 | 398 | CAH3174760.1 unnamed protein product [Porites lobata] | diamond | 108 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 27887285 | 27887285 | PRJNA1009807_S_NODE_2725_length_192_cov_2.320261_g2697_i0 | PRJNA1009807 | 2725 | 192 | 2.320261 | 4.45490112 | Anthophora plagiata | 597819 | Arthropoda | Arthropoda | 43.9 | 0.00747 | NR | CAK9813121.1 | 597819 | g2697 | i0 | 48.6 | 2.734375 | 35 | 18 | 54.7 | 0 | 40 | 144 | 222 | 256 | CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] | diamond | 525 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Anthophora | Anthophora plagiata | |
| 28992807 | 28992807 | PRJNA1009807_S_NODE_3148_length_182_cov_1.202797_g3120_i0 | PRJNA1009807 | 3148 | 182 | 1.202797 | 2.18909054 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 99.8 | 1.4000000000000002e-22 | NR | KAK3884497.1 | 88211 | g3120 | i0 | 70 | 1.96153846153846 | 60 | 18 | 98.9 | 0 | 2 | 181 | 139 | 198 | KAK3884497.1 hypothetical protein Pcinc_011235 [Petrolisthes cinctipes] | diamond | 357 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes |
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);;