contig_metadata
15 rows where bioproject = "PRJNA551951", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 520503 | 520503 | PRJNA551951_S_NODE_14681_length_173_cov_1.739130_g14563_i0 | PRJNA551951 | 14681 | 173 | 1.73913 | 3.0086949 | Demodex folliculorum | 481310 | Arthropoda | Arthropoda | 315 | 1.68e-81 | NTclustered | gi|1282187853|gb|KY922058.1| | 481310 | g14563 | i0 | 99.422 | 1 | 173 | 1 | 100 | 0 | 1 | 173 | 80 | 252 | Demodex folliculorum voucher UMMZ BMOC 07-0815-005 AD1011 28S ribosomal RNA gene, partial sequence | blastn | 173 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex folliculorum | |
| 1796170 | 1796170 | PRJNA551951_S_NODE_1642_length_737_cov_6.920228_g1562_i0 | PRJNA551951 | 1642 | 737 | 6.920228 | 51.00208036 | Demodex folliculorum | 481310 | Arthropoda | Arthropoda | 1260 | 0 | NTclustered | gi|746000042|ref|NC_026102.1| | 481310 | g1562 | i0 | 97.684 | 29.2075983717775 | 734 | 15 | 99 | 2 | 1 | 733 | 12364 | 11632 | Demodex folliculorum mitochondrion, complete genome | blastn | 21526 | 1260 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex folliculorum | |
| 4347615 | 4347615 | PRJNA551951_S_NODE_11264_length_214_cov_6.770950_g11146_i0 | PRJNA551951 | 11264 | 214 | 6.77095 | 14.489833 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 187 | 4.9499999999999984e-43 | NTclustered | gi|2899204213|ref|XM_016053504.3| | 114398 | g11146 | i0 | 86.517 | 0.831775700934579 | 178 | 14 | 83 | 3 | 38 | 214 | 1049 | 881 | PREDICTED: Parasteatoda tepidariorum dual specificity protein phosphatase 22-B (LOC107440544), mRNA | blastn | 178 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 4347731 | 4347731 | PRJNA551951_S_NODE_4184_length_441_cov_18.093596_g4069_i0 | PRJNA551951 | 4184 | 441 | 18.093596 | 79.79275836 | Cimex lectularius | 79782 | Arthropoda | Arthropoda | 52.8 | 0.043 | NTclustered | gi|498915507|emb|HF969883.1| | 79782 | g4069 | i0 | 100 | 0.0634920634920635 | 28 | 0 | 6 | 0 | 414 | 441 | 29 | 2 | Cimex lectularius microsatellite DNA locus Cle020, clone K01AXFGR | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cimicidae | Cimex | Cimex lectularius | |
| 5624523 | 5624523 | PRJNA551951_S_NODE_945_length_946_cov_251.437980_g883_i0 | PRJNA551951 | 945 | 946 | 251.43798 | 2378.6032908 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 1635 | 0 | NTclustered | gi|2743057281|ref|XM_065728723.1| | 6661 | g883 | i0 | 99.776 | 45.9175475687104 | 892 | 1 | 94 | 1 | 1 | 891 | 4814 | 3923 | PREDICTED: Artemia franciscana uncharacterized LOC136043804 (LOC136043804), mRNA | blastn | 43438 | 1635 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 7501024 | 7501024 | PRJNA551951_S_NODE_16626_length_157_cov_10.467213_g16508_i0 | PRJNA551951 | 16626 | 157 | 10.467213 | 16.43352441 | Arachnida | 6854 | Arthropoda | Arthropoda | 291 | 2.52e-74 | NTclustered | gi|359841699|gb|JN885467.1| | 188545 | g16508 | i0 | 100 | 100.407643312102 | 157 | 0 | 100 | 0 | 1 | 157 | 993 | 1149 | Demodex canis isolate Dc-S1 18S ribosomal RNA gene, complete sequence | blastn | 15764 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex canis | |
| 11999566 | 11999566 | PRJNA551951_S_NODE_6750_length_321_cov_3.629371_g6632_i0 | PRJNA551951 | 6750 | 321 | 3.629371 | 11.65028091 | Spodoptera frugiperda | 7108 | Arthropoda | Arthropoda | 126 | 1.75e-24 | NTclustered | gi|2306778951|ref|XM_035587016.2| | 7108 | g6632 | i0 | 86.726 | 13.797507788162 | 113 | 15 | 35 | 0 | 9 | 121 | 499 | 387 | PREDICTED: Spodoptera frugiperda thioredoxin-like protein 4A (LOC118271109), mRNA | blastn | 4429 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Spodoptera | Spodoptera frugiperda | |
| 14549675 | 14549675 | PRJNA551951_S_NODE_6132_length_344_cov_21.627832_g6014_i0 | PRJNA551951 | 6132 | 344 | 21.627832 | 74.39974208 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 324 | 6.25e-84 | NTclustered | gi|2743070621|ref|XM_065704403.1| | 6661 | g6014 | i0 | 93.925 | 2.40116279069767 | 214 | 13 | 62 | 0 | 105 | 318 | 1528 | 1741 | PREDICTED: Artemia franciscana angiogenic factor with G patch and FHA domains 1-like (LOC136027298), transcript variant X1, mRNA | blastn | 826 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 18372256 | 18372256 | PRJNA551951_S_NODE_13135_length_189_cov_3.896104_g13017_i0 | PRJNA551951 | 13135 | 189 | 3.896104 | 7.36363656 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 99 | 2.05e-16 | NTclustered | gi|2743033983|ref|XM_065713228.1| | 6661 | g13017 | i0 | 93.846 | 14.2328042328042 | 65 | 4 | 34 | 0 | 40 | 104 | 2176 | 2240 | PREDICTED: Artemia franciscana uncharacterized LOC136032822 (LOC136032822), transcript variant X1, mRNA | blastn | 2690 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 18372372 | 18372372 | PRJNA551951_S_NODE_5855_length_356_cov_4.778816_g5737_i0 | PRJNA551951 | 5855 | 356 | 4.778816 | 17.01258496 | Planococcus citri | 170843 | Arthropoda | Arthropoda | 601 | 2.6699999999999993e-167 | NTclustered | gi|2733127810|ref|XR_010557535.1| | 170843 | g5737 | i0 | 98.256 | 1.94662921348315 | 344 | 4 | 96 | 1 | 1 | 342 | 393 | 50 | PREDICTED: Planococcus citri uncharacterized LOC135839094 (LOC135839094), ncRNA | blastn | 693 | 601 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Pseudococcidae | Planococcus | Planococcus citri | |
| 19647001 | 19647001 | PRJNA551951_S_NODE_8556_length_269_cov_1.824786_g8438_i0 | PRJNA551951 | 8556 | 269 | 1.824786 | 4.90867434 | Ctenolepisma villosum | 257043 | Arthropoda | Arthropoda | 346 | 1.01e-90 | NTclustered | gi|1824663945|ref|NC_046478.1| | 257043 | g8438 | i0 | 92.308 | 88.2453531598513 | 247 | 14 | 91 | 5 | 25 | 269 | 13185 | 12942 | Ctenolepisma villosa mitochondrion, complete genome | blastn | 23738 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Zygentoma | Lepismatidae | Ctenolepisma | Ctenolepisma villosum | |
| 20922801 | 20922801 | PRJNA551951_S_NODE_6337_length_336_cov_30.621262_g6219_i0 | PRJNA551951 | 6337 | 336 | 30.621262 | 102.88744032 | Cimex lectularius | 79782 | Arthropoda | Arthropoda | 54.7 | 0.009 | NTclustered | gi|498915508|emb|HF969884.1| | 79782 | g6219 | i0 | 100 | 0.169642857142857 | 29 | 0 | 9 | 0 | 308 | 336 | 30 | 2 | Cimex lectularius microsatellite DNA locus Cle021, clone K01CM2VQ | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cimicidae | Cimex | Cimex lectularius | |
| 22197514 | 22197514 | PRJNA551951_S_NODE_5738_length_362_cov_2.357798_g5620_i0 | PRJNA551951 | 5738 | 362 | 2.357798 | 8.53522876 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 664 | 0 | NTclustered | gi|2743042588|ref|XM_065717503.1| | 6661 | g5620 | i0 | 99.724 | 4.1353591160221 | 362 | 1 | 100 | 0 | 1 | 362 | 234 | 595 | PREDICTED: Artemia franciscana small ribosomal subunit protein eS6-like (LOC136035617), mRNA | blastn | 1497 | 664 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 24746792 | 24746792 | PRJNA551951_S_NODE_17080_length_155_cov_1.000000_g16962_i0 | PRJNA551951 | 17080 | 155 | 1 | 1.55 | Oppiella nova | 334625 | Arthropoda | Arthropoda | 278 | 1.93e-70 | NTclustered | gi|1964613267|emb|OC975412.1| | 334625 | g16962 | i0 | 99.346 | 0.987096774193548 | 153 | 1 | 99 | 0 | 3 | 155 | 533 | 381 | Oppiella nova | blastn | 153 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Oppiella | Oppiella nova | |
| 32101349 | 32101349 | PRJNA551951_S_NODE_3798_length_469_cov_32.502304_g3684_i0 | PRJNA551951 | 3798 | 469 | 32.502304 | 152.43580576 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 94.7 | 6.14e-22 | NR | XP_015922803.1 | 114398 | g3684 | i0 | 45.9 | 0.71002132196162 | 111 | 53 | 70.4 | 4 | 404 | 75 | 1 | 105 | XP_015922803.1 uncharacterized protein [Parasteatoda tepidariorum] | diamond | 333 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum |
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);;