contig_metadata
22 rows where bioproject = "PRJNA1085664" and tax_phylum = "Arthropoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193544 | 193544 | PRJNA1085664_S_NODE_26641_length_171_cov_1.859375_g26222_i0 | PRJNA1085664 | 26641 | 171 | 1.859375 | 3.17953125 | Drymonia dodonaea | 988176 | Arthropoda | Arthropoda | 52.8 | 0.014 | NTclustered | gi|2918369730|emb|OZ237797.1| | 988176 | g26222 | i0 | 100 | 0.16374269005848 | 28 | 0 | 16 | 0 | 127 | 154 | 12793808 | 12793781 | Drymonia dodonaea genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Notodontidae | Drymonia | Drymonia dodonaea | |
| 2744240 | 2744240 | PRJNA1085664_S_NODE_23863_length_180_cov_1.416058_g23444_i0 | PRJNA1085664 | 23863 | 180 | 1.416058 | 2.5489044 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 65.8 | 1.96e-6 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g23444 | i0 | 97.368 | 0.677777777777778 | 38 | 1 | 21 | 0 | 1 | 38 | 28 | 65 | Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds | blastn | 122 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 4020185 | 4020185 | PRJNA1085664_S_NODE_7244_length_320_cov_1.039711_g6825_i0 | PRJNA1085664 | 7244 | 320 | 1.039711 | 3.3270752 | Timema monikensis | 170555 | Arthropoda | Arthropoda | 58.4 | 6.45e-4 | NTclustered | gi|1946411097|emb|OB793204.1| | 170555 | g6825 | i0 | 97.059 | 0.28125 | 34 | 1 | 11 | 0 | 212 | 245 | 168543 | 168510 | 3_Tms_b3v08 | blastn | 90 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema monikensis | |
| 4845412 | 4845412 | PRJNA1085664_S_NODE_10904_length_263_cov_3.127273_g10485_i0 | PRJNA1085664 | 10904 | 263 | 3.127273 | 8.22472799 | Timema | 61471 | Arthropoda | Arthropoda | 54.7 | 0.007 | NTclustered | gi|1947819235|emb|OD566261.1| | 61472 | g10485 | i0 | 100 | 0.220532319391635 | 29 | 0 | 11 | 0 | 160 | 188 | 111505 | 111477 | 4_Tbi_b3v08 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema bartmani | |
| 5296261 | 5296261 | PRJNA1085664_S_NODE_12965_length_241_cov_2.186869_g12546_i0 | PRJNA1085664 | 12965 | 241 | 2.186869 | 5.27035429 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g12546 | i0 | 100 | 0.356846473029046 | 30 | 0 | 12 | 0 | 212 | 241 | 57 | 28 | Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds | blastn | 86 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 6571420 | 6571420 | PRJNA1085664_S_NODE_19766_length_196_cov_1.882353_g19347_i0 | PRJNA1085664 | 19766 | 196 | 1.882353 | 3.68941188 | Limulus polyphemus | 6850 | Arthropoda | Arthropoda | 52.8 | 0.017 | NTclustered | gi|1238828986|ref|XM_013938960.2| | 6850 | g19347 | i0 | 100 | 0.285714285714286 | 28 | 0 | 14 | 0 | 7 | 34 | 3280 | 3253 | PREDICTED: Limulus polyphemus ribokinase-like (LOC106478414), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Merostomata | Xiphosura | Limulidae | Limulus | Limulus polyphemus | |
| 7846170 | 7846170 | PRJNA1085664_S_NODE_20267_length_194_cov_1.417219_g19848_i0 | PRJNA1085664 | 20267 | 194 | 1.417219 | 2.74940486 | Platynothrus peltifer | 128015 | Arthropoda | Arthropoda | 58.4 | 3.6e-4 | NTclustered | gi|2579718318|gb|CP133307.1| | 128015 | g19848 | i0 | 100 | 1.45876288659794 | 31 | 0 | 16 | 0 | 164 | 194 | 9149533 | 9149503 | Platynothrus peltifer isolate 155_3 chromosome 2 | blastn | 283 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Camisiidae | Platynothrus | Platynothrus peltifer | |
| 9121165 | 9121165 | PRJNA1085664_S_NODE_23828_length_180_cov_1.751825_g23409_i0 | PRJNA1085664 | 23828 | 180 | 1.751825 | 3.153285 | Glaucopsyche melanops | 1002887 | Arthropoda | Arthropoda | 54.7 | 0.004 | NTclustered | gi|2919553660|emb|OZ238364.1| | 1002887 | g23409 | i0 | 96.875 | 0.355555555555556 | 32 | 1 | 18 | 0 | 13 | 44 | 24059155 | 24059124 | Glaucopsyche melanops genome assembly, chromosome: W | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Glaucopsyche | Glaucopsyche melanops | |
| 10396831 | 10396831 | PRJNA1085664_S_NODE_15709_length_219_cov_2.573864_g15290_i0 | PRJNA1085664 | 15709 | 219 | 2.573864 | 5.63676216 | Lutzomyia longipalpis | 7200 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|2500586479|ref|XR_008750134.1| | 7200 | g15290 | i0 | 96.97 | 0.406392694063927 | 33 | 1 | 15 | 0 | 1 | 33 | 717 | 685 | PREDICTED: Lutzomyia longipalpis troponin C-like (LOC129786533), transcript variant X2, misc_RNA | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Psychodidae | Lutzomyia | Lutzomyia longipalpis | |
| 11672246 | 11672246 | PRJNA1085664_S_NODE_32030_length_157_cov_2.438596_g31611_i0 | PRJNA1085664 | 32030 | 157 | 2.438596 | 3.82859572 | Cydia pomonella | 82600 | Arthropoda | Arthropoda | 52.8 | 0.013 | NTclustered | gi|2639390682|ref|XM_061868808.1| | 82600 | g31611 | i0 | 100 | 0.356687898089172 | 28 | 0 | 18 | 0 | 27 | 54 | 126 | 99 | PREDICTED: Cydia pomonella muscle calcium channel subunit alpha-1 (LOC133530754), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Tortricidae | Cydia | Cydia pomonella | |
| 11672260 | 11672260 | PRJNA1085664_S_NODE_37130_length_150_cov_1.037383_g36711_i0 | PRJNA1085664 | 37130 | 150 | 1.037383 | 1.5560745 | Charissa obscurata | 204503 | Arthropoda | Arthropoda | 54.7 | 0.003 | NTclustered | gi|2919570218|emb|OZ238379.1| | 204503 | g36711 | i0 | 100 | 0.566666666666667 | 29 | 0 | 19 | 0 | 5 | 33 | 18363215 | 18363243 | Charissa obscurata genome assembly, chromosome: 13 | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Geometridae | Charissa | Charissa obscurata | |
| 12496131 | 12496131 | PRJNA1085664_S_NODE_11270_length_259_cov_1.236111_g10851_i0 | PRJNA1085664 | 11270 | 259 | 1.236111 | 3.20152749 | Timema | 61471 | Arthropoda | Arthropoda | 52.8 | 0.024 | NTclustered | gi|1947819297|emb|OD566285.1| | 61472 | g10851 | i0 | 100 | 0.324324324324324 | 28 | 0 | 11 | 0 | 76 | 103 | 91927 | 91954 | 4_Tbi_b3v08 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema bartmani | |
| 13770696 | 13770696 | PRJNA1085664_S_NODE_25311_length_175_cov_2.181818_g24892_i0 | PRJNA1085664 | 25311 | 175 | 2.181818 | 3.8181815 | Arthropoda | 6656 | Arthropoda | Arthropoda | 60.2 | 8.81e-5 | NTclustered | gi|2918381335|emb|OZ238053.1| | 132710 | g24892 | i0 | 100 | 5.54857142857143 | 32 | 0 | 18 | 0 | 56 | 87 | 16731473 | 16731504 | Zerynthia rumina genome assembly, chromosome: 18 | blastn | 971 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Papilionidae | Zerynthia | Zerynthia rumina | |
| 15496257 | 15496257 | PRJNA1085664_S_NODE_5853_length_352_cov_8.579288_g5434_i0 | PRJNA1085664 | 5853 | 352 | 8.579288 | 30.19909376 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 52.8 | 0.033 | NTclustered | gi|1832334880|gb|MK599468.1| | 6687 | g5434 | i0 | 100 | 0.0795454545454545 | 28 | 0 | 8 | 0 | 325 | 352 | 121 | 94 | Penaeus monodon C-type lectin mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 18045242 | 18045242 | PRJNA1085664_S_NODE_17875_length_206_cov_1.177914_g17456_i0 | PRJNA1085664 | 17875 | 206 | 1.177914 | 2.42650284 | Liposcelis decolor | 209926 | Arthropoda | Arthropoda | 381 | 2.0199999999999994e-101 | NTclustered | gi|338776974|gb|HQ110069.1| | 209926 | g17456 | i0 | 100 | 101.058252427184 | 206 | 0 | 100 | 0 | 1 | 206 | 262 | 57 | Liposcelis decolor strain L4c 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20818 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis decolor | |
| 18045264 | 18045264 | PRJNA1085664_S_NODE_22835_length_183_cov_3.300000_g22416_i0 | PRJNA1085664 | 22835 | 183 | 3.3 | 6.039 | Satyrium ilicis | 876074 | Arthropoda | Arthropoda | 58.4 | 3.35e-4 | NTclustered | gi|2918386101|emb|OZ238115.1| | 876074 | g22416 | i0 | 90.698 | 0.234972677595628 | 43 | 4 | 23 | 0 | 87 | 129 | 56559195 | 56559237 | Satyrium ilicis genome assembly, chromosome: 6 | blastn | 43 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Satyrium | Satyrium ilicis | |
| 20594641 | 20594641 | PRJNA1085664_S_NODE_31437_length_159_cov_1.068966_g31018_i0 | PRJNA1085664 | 31437 | 159 | 1.068966 | 1.69965594 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 52.8 | 0.013 | NTclustered | gi|952952252|gb|KU156741.1| | 6687 | g31018 | i0 | 100 | 0.176100628930818 | 28 | 0 | 18 | 0 | 132 | 159 | 31 | 4 | Penaeus monodon chitin deacetylase 1 (CDA1) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 21419370 | 21419370 | PRJNA1085664_S_NODE_7357_length_317_cov_6.109489_g6938_i0 | PRJNA1085664 | 7357 | 317 | 6.109489 | 19.36708013 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.03 | NTclustered | gi|1184387702|emb|LT835105.1| | 85552 | g6938 | i0 | 100 | 0.176656151419558 | 28 | 0 | 9 | 0 | 1 | 28 | 6 | 33 | Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Portunidae | Scylla | Scylla paramamosain | |
| 21870332 | 21870332 | PRJNA1085664_S_NODE_14698_length_227_cov_1.516304_g14279_i0 | PRJNA1085664 | 14698 | 227 | 1.516304 | 3.44201008 | Leiobunum subalpinum | 3086104 | Arthropoda | Arthropoda | 54.7 | 0.006 | NTclustered | gi|2920023896|emb|OZ239120.1| | 3086104 | g14279 | i0 | 92.308 | 0.171806167400881 | 39 | 1 | 17 | 2 | 13 | 50 | 35277171 | 35277208 | Leiobunum subalpinum genome assembly, chromosome: 3 | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Opiliones | Sclerosomatidae | Leiobunum | Leiobunum subalpinum | |
| 21870345 | 21870345 | PRJNA1085664_S_NODE_18158_length_204_cov_1.819876_g17739_i0 | PRJNA1085664 | 18158 | 204 | 1.819876 | 3.71254704 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 54.7 | 0.005 | NTclustered | gi|1832334880|gb|MK599468.1| | 6687 | g17739 | i0 | 100 | 0.588235294117647 | 29 | 0 | 14 | 0 | 176 | 204 | 115 | 87 | Penaeus monodon C-type lectin mRNA, complete cds | blastn | 120 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 23145795 | 23145795 | PRJNA1085664_S_NODE_7299_length_319_cov_1.565217_g6880_i0 | PRJNA1085664 | 7299 | 319 | 1.565217 | 4.99304223 | Scylla paramamosain | 85552 | Arthropoda | Arthropoda | 54.7 | 0.008 | NTclustered | gi|1184387702|emb|LT835105.1| | 85552 | g6880 | i0 | 100 | 0.178683385579937 | 29 | 0 | 9 | 0 | 1 | 29 | 6 | 34 | Scylla paramamosain mRNA for Toll-like receptor 2 (SpTLR2 gene) | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Portunidae | Scylla | Scylla paramamosain | |
| 25243678 | 25243678 | PRJNA1085664_S_NODE_25760_length_174_cov_1.297710_g25341_i0 | PRJNA1085664 | 25760 | 174 | 1.29771 | 2.2580154 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|312283558|dbj|AB561905.1| | 27405 | g25341 | i0 | 100 | 0.494252873563218 | 29 | 0 | 17 | 0 | 1 | 29 | 19 | 47 | Marsupenaeus japonicus mRNA for astakine, complete cds | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus japonicus |
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);;