contig_metadata
19 rows where bioproject = "PRJNA383995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405245 | 405245 | PRJNA383995_P_NODE_10321_length_204_cov_1.154839_g10222_i0 | PRJNA383995 | 10321 | 204 | 1.154839 | 2.35587156 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 298 | 2.07e-76 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g10222 | i0 | 93.5 | 17.9950980392157 | 200 | 13 | 99 | 0 | 3 | 202 | 755 | 556 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 3671 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 6782987 | 6782987 | PRJNA383995_P_NODE_9666_length_209_cov_2.231250_g9567_i0 | PRJNA383995 | 9666 | 209 | 2.23125 | 4.6633125 | Agapeta hamana | 1100904 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|2918369793|emb|OZ237860.1| | 1100904 | g9567 | i0 | 100 | 0.287081339712919 | 30 | 0 | 14 | 0 | 135 | 164 | 9630697 | 9630668 | Agapeta hamana genome assembly, chromosome: 1 | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Tortricidae | Agapeta | Agapeta hamana | |
| 8058542 | 8058542 | PRJNA383995_P_NODE_11367_length_195_cov_1.212329_g11268_i0 | PRJNA383995 | 11367 | 195 | 1.212329 | 2.36404155 | Aedes albopictus | 7160 | Arthropoda | Arthropoda | 52.8 | 0.017 | NTclustered | gi|2669916502|ref|XM_062857525.1| | 7160 | g11268 | i0 | 100 | 0.717948717948718 | 28 | 0 | 14 | 0 | 157 | 184 | 1870 | 1897 | PREDICTED: Aedes albopictus uncharacterized LOC134290391 (LOC134290391), mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Aedes | Aedes albopictus | |
| 8058561 | 8058561 | PRJNA383995_P_NODE_16267_length_166_cov_0.871795_g16168_i0 | PRJNA383995 | 16267 | 166 | 0.871795 | 1.4471797 | Zootermopsis nevadensis | 136037 | Arthropoda | Arthropoda | 54.7 | 0.004 | NTclustered | gi|1227993080|ref|XM_022072615.1| | 136037 | g16168 | i0 | 100 | 0.174698795180723 | 29 | 0 | 17 | 0 | 96 | 124 | 2246 | 2274 | PREDICTED: Zootermopsis nevadensis CMP-sialic acid transporter 1 (LOC110833964), transcript variant X1, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Termopsidae | Zootermopsis | Zootermopsis nevadensis | |
| 9333328 | 9333328 | PRJNA383995_P_NODE_10948_length_198_cov_1.369128_g10849_i0 | PRJNA383995 | 10948 | 198 | 1.369128 | 2.71087344 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 126 | 9.97e-25 | NTclustered | gi|2743049377|ref|XM_065720999.1| | 6661 | g10849 | i0 | 91.398 | 0.939393939393939 | 93 | 7 | 47 | 1 | 106 | 198 | 3717 | 3626 | PREDICTED: Artemia franciscana lachesin-like (LOC136038049), transcript variant X2, mRNA | blastn | 186 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 11883951 | 11883951 | PRJNA383995_P_NODE_16090_length_166_cov_0.871795_g15991_i0 | PRJNA383995 | 16090 | 166 | 0.871795 | 1.4471797 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 302 | 1.2500000000000001e-77 | NTclustered | gi|2743045148|ref|XM_065718801.1| | 6661 | g15991 | i0 | 99.401 | 1.00602409638554 | 167 | 0 | 100 | 1 | 1 | 166 | 4318 | 4484 | PREDICTED: Artemia franciscana uncharacterized LOC136036510 (LOC136036510), transcript variant X1, mRNA | blastn | 167 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 13158980 | 13158980 | PRJNA383995_P_NODE_1451_length_488_cov_0.888383_g1352_i0 | PRJNA383995 | 1451 | 488 | 0.888383 | 4.33530904 | Glaucopsyche melanops | 1002887 | Arthropoda | Arthropoda | 56.5 | 0.004 | NTclustered | gi|2919550840|emb|OZ238361.1| | 1002887 | g1352 | i0 | 100 | 0.0614754098360656 | 30 | 0 | 6 | 0 | 152 | 181 | 14100599 | 14100628 | Glaucopsyche melanops genome assembly, chromosome: 20 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Lycaenidae | Glaucopsyche | Glaucopsyche melanops | |
| 13158999 | 13158999 | PRJNA383995_P_NODE_18351_length_162_cov_0.902655_g18252_i0 | PRJNA383995 | 18351 | 162 | 0.902655 | 1.4623011 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 300 | 4.36e-77 | NTclustered | gi|2743075735|ref|XM_065707073.1| | 6661 | g18252 | i0 | 100 | 1.19753086419753 | 162 | 0 | 100 | 0 | 1 | 162 | 1292 | 1453 | PREDICTED: Artemia franciscana methionine synthase-like (LOC136029039), mRNA | blastn | 194 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 13829287 | 13829287 | PRJNA383995_P_NODE_9571_length_210_cov_1.583851_g9472_i0 | PRJNA383995 | 9571 | 210 | 1.583851 | 3.3260871 | Artemia | 6660 | Arthropoda | Arthropoda | 388 | 1.24e-103 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g9472 | i0 | 100 | 86.1333333333333 | 210 | 0 | 100 | 0 | 1 | 210 | 804 | 1013 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 18088 | 388 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 14434003 | 14434003 | PRJNA383995_P_NODE_2352_length_394_cov_9.550725_g2253_i0 | PRJNA383995 | 2352 | 394 | 9.550725 | 37.6298565 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 721 | 0 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g2253 | i0 | 99.746 | 33.7741116751269 | 393 | 1 | 99 | 0 | 2 | 394 | 3693 | 3301 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 13307 | 721 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 14434006 | 14434006 | PRJNA383995_P_NODE_3632_length_324_cov_5.516364_g3533_i0 | PRJNA383995 | 3632 | 324 | 5.516364 | 17.87301936 | Helicoverpa assulta | 52344 | Arthropoda | Arthropoda | 52.8 | 0.03 | NTclustered | gi|2636206755|emb|OY979781.1| | 52344 | g3533 | i0 | 100 | 0.0864197530864197 | 28 | 0 | 9 | 0 | 230 | 257 | 8315215 | 8315242 | Helicoverpa assulta genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Helicoverpa | Helicoverpa assulta | |
| 16982643 | 16982643 | PRJNA383995_P_NODE_16454_length_165_cov_0.879310_g16355_i0 | PRJNA383995 | 16454 | 165 | 0.87931 | 1.4508615 | Drosophila pseudoobscura | 7237 | Arthropoda | Arthropoda | 52.8 | 0.014 | NTclustered | gi|1830844047|ref|XM_033379140.1| | 7237 | g16355 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 8 | 35 | 5135 | 5108 | PREDICTED: Drosophila pseudoobscura transient receptor potential cation channel, subfamily M (Trpm), transcript variant X25, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila pseudoobscura | |
| 18256792 | 18256792 | PRJNA383995_P_NODE_18655_length_161_cov_1.821429_g18556_i0 | PRJNA383995 | 18655 | 161 | 1.821429 | 2.93250069 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 231 | 1.5999999999999997e-56 | NTclustered | gi|2743025003|ref|XR_010621486.1| | 6661 | g18556 | i0 | 92.547 | 8.49689440993789 | 161 | 12 | 100 | 0 | 1 | 161 | 5 | 165 | PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA | blastn | 1368 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 19531124 | 19531124 | PRJNA383995_P_NODE_2096_length_416_cov_1.920981_g1997_i0 | PRJNA383995 | 2096 | 416 | 1.920981 | 7.99128096 | Hyalella azteca | 294128 | Arthropoda | Arthropoda | 706 | 0 | NTclustered | gi|2232419545|ref|XR_007157289.1| | 294128 | g1997 | i0 | 97.356 | 101.947115384615 | 416 | 10 | 100 | 1 | 1 | 416 | 443 | 857 | PREDICTED: Hyalella azteca large subunit ribosomal RNA (LOC125179508), rRNA | blastn | 42410 | 706 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Amphipoda | Hyalellidae | Hyalella | Hyalella azteca | |
| 20806869 | 20806869 | PRJNA383995_P_NODE_18377_length_162_cov_0.902655_g18278_i0 | PRJNA383995 | 18377 | 162 | 0.902655 | 1.4623011 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 283 | 4.39e-72 | NTclustered | gi|2743057488|ref|XM_065728831.1| | 6661 | g18278 | i0 | 98.148 | 3.12345679012346 | 162 | 3 | 100 | 0 | 1 | 162 | 32 | 193 | PREDICTED: Artemia franciscana protein bric-a-brac 1-like (LOC136043868), transcript variant X2, mRNA | blastn | 506 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 21477484 | 21477484 | PRJNA383995_P_NODE_3197_length_345_cov_4.402027_g3098_i0 | PRJNA383995 | 3197 | 345 | 4.402027 | 15.18699315 | Artemia | 6660 | Arthropoda | Arthropoda | 638 | 1.97e-178 | NTclustered | gi|2743080997|ref|XR_010618360.1| | 6661 | g3098 | i0 | 100 | 100.142028985507 | 345 | 0 | 100 | 0 | 1 | 345 | 1814 | 2158 | PREDICTED: Artemia franciscana large subunit ribosomal RNA (LOC136030742), rRNA | blastn | 34549 | 638 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 22081733 | 22081733 | PRJNA383995_P_NODE_18518_length_162_cov_0.902655_g18419_i0 | PRJNA383995 | 18518 | 162 | 0.902655 | 1.4623011 | Drosophila montana | 40370 | Arthropoda | Arthropoda | 54.7 | 0.004 | NTclustered | gi|2721904602|ref|XM_064682810.1| | 40370 | g18419 | i0 | 100 | 0.179012345679012 | 29 | 0 | 18 | 0 | 54 | 82 | 533 | 561 | PREDICTED: Drosophila montana uncharacterized LOC135428716 (LOC135428716), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila montana | |
| 27218249 | 27218249 | PRJNA383995_P_NODE_15502_length_167_cov_0.864407_g15403_i0 | PRJNA383995 | 15502 | 167 | 0.864407 | 1.44355969 | Arthropoda | 6656 | Arthropoda | Arthropoda | 76.3 | 2.03e-14 | NR | XP_042219005.1 | 6706 | g15403 | i0 | 60.7 | 11.0479041916168 | 56 | 21 | 98.8 | 1 | 166 | 2 | 421 | 476 | XP_042219005.1 uncharacterized protein LOC121864135 isoform X2 [Homarus americanus] | diamond | 1845 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Nephropidae | Homarus | Homarus americanus | |
| 31292702 | 31292702 | PRJNA383995_P_NODE_10055_length_206_cov_1.299363_g9956_i0 | PRJNA383995 | 10055 | 206 | 1.299363 | 2.67668778 | root | 1 | Root_unresolved | Root_unresolved | 51.6 | 1.72e-5 | NR | PNF39304.1 | 105785 | g9956 | i0 | 55.8 | 4.7621359223301 | 43 | 19 | 62.6 | 0 | 131 | 3 | 394 | 436 | PNF39304.1 hypothetical protein B7P43_G16557 [Cryptotermes secundus] | diamond | 981 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Kalotermitidae | Cryptotermes | Cryptotermes secundus |
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);;