contig_metadata
24 rows where bioproject = "PRJNA734313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 716702 | 716702 | PRJNA734313_S_NODE_23341_length_193_cov_1.034247_g23228_i0 | PRJNA734313 | 23341 | 193 | 1.034247 | 1.99609671 | Coptotermes formosanus | 36987 | Arthropoda | Arthropoda | 52.8 | 0.017 | NTclustered | gi|506965362|gb|KC632258.1| | 36987 | g23228 | i0 | 100 | 0.145077720207254 | 28 | 0 | 15 | 0 | 5 | 32 | 1 | 28 | Coptotermes formosanus clone CFSNI2475 hypothetical protein mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Rhinotermitidae | Coptotermes | Coptotermes formosanus | |
| 3268043 | 3268043 | PRJNA734313_S_NODE_7583_length_335_cov_32.923611_g7470_i0 | PRJNA734313 | 7583 | 335 | 32.923611 | 110.29409685 | Gryllus bimaculatus | 6999 | Arthropoda | Arthropoda | 58.4 | 6.79e-4 | NTclustered | gi|1192786022|dbj|LC202053.1| | 6999 | g7470 | i0 | 100 | 0.555223880597015 | 31 | 0 | 9 | 0 | 1 | 31 | 8 | 38 | Gryllus bimaculatus cry2 mRNA for cryptochrome 2 transcript variant f, complete cds | blastn | 186 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Gryllidae | Gryllus | Gryllus bimaculatus | |
| 3748468 | 3748468 | PRJNA734313_S_NODE_11783_length_274_cov_1.264317_g11670_i0 | PRJNA734313 | 11783 | 274 | 1.264317 | 3.46422858 | Timema | 61471 | Arthropoda | Arthropoda | 54.7 | 0.007 | NTclustered | gi|1946277799|emb|OD565122.1| | 61472 | g11670 | i0 | 100 | 0.211678832116788 | 29 | 0 | 11 | 0 | 222 | 250 | 33016 | 33044 | 4_Tbi_b3v08 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema bartmani | |
| 5820296 | 5820296 | PRJNA734313_S_NODE_29725_length_169_cov_1.622951_g29612_i0 | PRJNA734313 | 29725 | 169 | 1.622951 | 2.74278719 | Timema tahoe | 61484 | Arthropoda | Arthropoda | 54.7 | 0.004 | NTclustered | gi|1948018594|emb|OE001404.1| | 61484 | g29612 | i0 | 100 | 0.171597633136095 | 29 | 0 | 17 | 0 | 79 | 107 | 87735 | 87763 | 4_Tte_b3v08 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema tahoe | |
| 8370025 | 8370025 | PRJNA734313_S_NODE_8247_length_324_cov_2.592058_g8134_i0 | PRJNA734313 | 8247 | 324 | 2.592058 | 8.39826792 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g8134 | i0 | 100 | 0.265432098765432 | 30 | 0 | 9 | 0 | 295 | 324 | 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 | |
| 9645178 | 9645178 | PRJNA734313_S_NODE_20088_length_208_cov_1.881988_g19975_i0 | PRJNA734313 | 20088 | 208 | 1.881988 | 3.91453504 | Spermophora senoculata | 280438 | Arthropoda | Arthropoda | 379 | 7.359999999999998e-101 | NTclustered | gi|452091145|gb|JN816663.1| | 280438 | g19975 | i0 | 99.519 | 100.822115384615 | 208 | 1 | 100 | 0 | 1 | 208 | 120 | 327 | Spermophora senoculata isolate LEGO_5_9 18S ribosomal RNA gene, partial sequence | blastn | 20971 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Pholcidae | Spermophora | Spermophora senoculata | |
| 12196056 | 12196056 | PRJNA734313_S_NODE_950_length_640_cov_6.881956_g861_i0 | PRJNA734313 | 950 | 640 | 6.881956 | 44.0445184 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 56.5 | 0.005 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g861 | i0 | 100 | 0.046875 | 30 | 0 | 5 | 0 | 611 | 640 | 57 | 28 | Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 12676355 | 12676355 | PRJNA734313_S_NODE_29870_length_169_cov_1.254098_g29757_i0 | PRJNA734313 | 29870 | 169 | 1.254098 | 2.11942562 | Ixodidae | 6939 | Arthropoda | Arthropoda | 75 | 3.01e-9 | NTclustered | gi|33772684|gb|AY277904.1| | 34621 | g29757 | i0 | 93.878 | 0.869822485207101 | 49 | 3 | 29 | 0 | 121 | 169 | 649 | 601 | Dermacentor variabilis ferritin (Fer) mRNA, complete cds | blastn | 147 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Dermacentor | Dermacentor variabilis | |
| 15225333 | 15225333 | PRJNA734313_S_NODE_9412_length_306_cov_2.888031_g9299_i0 | PRJNA734313 | 9412 | 306 | 2.888031 | 8.83737486 | Insecta | 50557 | Arthropoda | Arthropoda | 52.8 | 0.029 | NTclustered | gi|2918386055|emb|OZ238098.1| | 346795 | g9299 | i0 | 100 | 0.183006535947712 | 28 | 0 | 9 | 0 | 260 | 287 | 11867902 | 11867929 | Longitarsus dorsalis genome assembly, chromosome: 5 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Longitarsus | Longitarsus dorsalis | |
| 16019213 | 16019213 | PRJNA734313_S_NODE_11673_length_275_cov_1.960526_g11560_i0 | PRJNA734313 | 11673 | 275 | 1.960526 | 5.3914465 | Centruroides edwardsii | 2565419 | Arthropoda | Arthropoda | 52.8 | 0.025 | NTclustered | gi|1761173678|gb|MK932020.1| | 2565419 | g11560 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 0 | 1 | 28 | 31 | 58 | Centruroides edwardsii antimicrobial non-disulfide-bridged peptide (CR13_25) mRNA, partial cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Scorpiones | Buthidae | Centruroides | Centruroides edwardsii | |
| 16499766 | 16499766 | PRJNA734313_S_NODE_11993_length_271_cov_3.133929_g11880_i0 | PRJNA734313 | 11993 | 271 | 3.133929 | 8.49294759 | Decapoda | 6683 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|2311836542|ref|XM_050849004.1| | 95602 | g11880 | i0 | 83.871 | 0.686346863468635 | 62 | 7 | 23 | 3 | 114 | 175 | 1572 | 1514 | PREDICTED: Eriocheir sinensis uncharacterized LOC126990383 (LOC126990383), mRNA | blastn | 186 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Varunidae | Eriocheir | Eriocheir sinensis | |
| 17294768 | 17294768 | PRJNA734313_S_NODE_8834_length_315_cov_1.902985_g8721_i0 | PRJNA734313 | 8834 | 315 | 1.902985 | 5.99440275 | Hermetia illucens | 343691 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|1941209856|ref|XM_038060111.1| | 343691 | g8721 | i0 | 96.97 | 0.523809523809524 | 33 | 1 | 10 | 0 | 18 | 50 | 467 | 499 | PREDICTED: Hermetia illucens protein lifeguard 1-like (LOC119654628), transcript variant X2, mRNA | blastn | 165 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Stratiomyidae | Hermetia | Hermetia illucens | |
| 17774530 | 17774530 | PRJNA734313_S_NODE_23574_length_191_cov_559.256944_g23461_i0 | PRJNA734313 | 23574 | 191 | 559.256944 | 1068.18076304 | root | 1 | Root_unresolved | Root_unresolved | 281 | 1.92e-71 | NTclustered | gi|631471013|gb|KJ608149.1| | 7165 | g23461 | i0 | 93.194 | 105.55497382199 | 191 | 13 | 100 | 0 | 1 | 191 | 5737 | 5927 | Anopheles gambiae Y chromosome sequence | blastn | 20161 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Anopheles | Anopheles gambiae | |
| 20323277 | 20323277 | PRJNA734313_S_NODE_37436_length_153_cov_1052.924528_g37323_i0 | PRJNA734313 | 37436 | 153 | 1052.924528 | 1610.97452784 | root | 1 | Root_unresolved | Root_unresolved | 185 | 1.18e-42 | NTclustered | gi|631471013|gb|KJ608149.1| | 7165 | g37323 | i0 | 98.113 | 120.091503267974 | 106 | 2 | 100 | 0 | 1 | 106 | 5737 | 5842 | Anopheles gambiae Y chromosome sequence | blastn | 18374 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Anopheles | Anopheles gambiae | |
| 21119302 | 21119302 | PRJNA734313_S_NODE_7917_length_329_cov_9.808511_g7804_i0 | PRJNA734313 | 7917 | 329 | 9.808511 | 32.27000119 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 54.7 | 0.009 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g7804 | i0 | 100 | 0.258358662613982 | 29 | 0 | 9 | 0 | 301 | 329 | 56 | 28 | Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 21598958 | 21598958 | PRJNA734313_S_NODE_7737_length_332_cov_7.340351_g7624_i0 | PRJNA734313 | 7737 | 332 | 7.340351 | 24.36996532 | Schistocerca | 7008 | Arthropoda | Arthropoda | 52.8 | 0.031 | NTclustered | gi|2284228152|ref|XM_049984008.1| | 7010 | g7624 | i0 | 100 | 0.19578313253012 | 28 | 0 | 8 | 0 | 48 | 75 | 1190 | 1163 | PREDICTED: Schistocerca gregaria lysosomal alpha-mannosidase-like (LOC126284807), transcript variant X3, mRNA | blastn | 65 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 24943153 | 24943153 | PRJNA734313_S_NODE_13880_length_252_cov_4.331707_g13767_i0 | PRJNA734313 | 13880 | 252 | 4.331707 | 10.91590164 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 54.7 | 0.006 | NTclustered | gi|1237088976|dbj|LC316987.1| | 7091 | g13767 | i0 | 96.97 | 0.353174603174603 | 33 | 0 | 13 | 1 | 220 | 252 | 59 | 28 | Bombyx mori BmSfp53 mRNA for seminal fluid protein 53, complete cds | blastn | 89 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 27084049 | 27084049 | PRJNA734313_S_NODE_17962_length_221_cov_1.172414_g17849_i0 | PRJNA734313 | 17962 | 221 | 1.172414 | 2.59103494 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 57 | 2.59e-7 | NR | RWS31390.1 | 299467 | g17849 | i0 | 45 | 0.81447963800905 | 60 | 31 | 78.7 | 1 | 219 | 46 | 364 | 423 | RWS31390.1 uncharacterized protein B4U80_02538 [Leptotrombidium deliense] | diamond | 180 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 27347273 | 27347273 | PRJNA734313_S_NODE_26523_length_180_cov_1.150376_g26410_i0 | PRJNA734313 | 26523 | 180 | 1.150376 | 2.0706768 | Araneidae | 6913 | Arthropoda | Arthropoda | 90.9 | 7.61e-20 | NR | XP_055941438.1 | 94029 | g26410 | i0 | 62.7 | 3.93333333333333 | 59 | 22 | 98.3 | 0 | 2 | 178 | 300 | 358 | XP_055941438.1 protein SSUH2 homolog [Argiope bruennichi] | diamond | 708 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 28094713 | 28094713 | PRJNA734313_S_NODE_8965_length_313_cov_2.187970_g8852_i0 | PRJNA734313 | 8965 | 313 | 2.18797 | 6.8483461 | Leptopilina boulardi | 63433 | Arthropoda | Arthropoda | 55.8 | 2.13e-6 | NR | XP_051173332.1 | 63433 | g8852 | i0 | 29.7 | 0.87220447284345 | 91 | 55 | 87.2 | 2 | 312 | 40 | 38 | 119 | XP_051173332.1 ankyrin-1-like [Leptopilina boulardi] | diamond | 273 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Figitidae | Leptopilina | Leptopilina boulardi | |
| 29178585 | 29178585 | PRJNA734313_S_NODE_16589_length_230_cov_2.229508_g16476_i0 | PRJNA734313 | 16589 | 230 | 2.229508 | 5.1278684 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.9 | 2.01e-7 | NR | KAK2720597.1 | 6661 | g16476 | i0 | 37.3 | 2.60869565217391 | 67 | 42 | 87.4 | 0 | 230 | 30 | 10 | 76 | KAK2720597.1 hypothetical protein QYM36_004472 [Artemia franciscana] | diamond | 600 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 29452047 | 29452047 | PRJNA734313_S_NODE_10650_length_288_cov_1.481328_g10537_i0 | PRJNA734313 | 10650 | 288 | 1.481328 | 4.26622464 | Argiope bruennichi | 94029 | Arthropoda | Arthropoda | 117 | 2.9299999999999993e-28 | NR | XP_055928046.1 | 94029 | g10537 | i0 | 52.2 | 5.76041666666667 | 92 | 44 | 95.8 | 0 | 286 | 11 | 485 | 576 | XP_055928046.1 macrophage mannose receptor 1-like [Argiope bruennichi] | diamond | 1659 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 29494183 | 29494183 | PRJNA734313_S_NODE_20370_length_207_cov_0.956250_g20257_i0 | PRJNA734313 | 20370 | 207 | 0.95625 | 1.9794375 | Metazoa | 33208 | Arthropoda | Arthropoda | 62 | 3.85e-9 | NR | CAD7232757.1 | 163714 | g20257 | i0 | 46.4 | 2 | 69 | 36 | 98.6 | 1 | 4 | 207 | 55 | 123 | CAD7232757.1 unnamed protein product [Cyprideis torosa] | diamond | 414 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Cytherideidae | Cyprideis | Cyprideis torosa | |
| 30463573 | 30463573 | PRJNA734313_S_NODE_3233_length_454_cov_12.825553_g3125_i0 | PRJNA734313 | 3233 | 454 | 12.825553 | 58.22801062 | Uroleucon formosanum | 796250 | Arthropoda | Arthropoda | 47.4 | 0.00703 | NR | KAL4119326.1 | 796250 | g3125 | i0 | 29.4 | 0.786343612334802 | 119 | 72 | 73.3 | 5 | 103 | 435 | 3 | 117 | KAL4119326.1 hypothetical protein QTP88_012147 [Uroleucon formosanum] | diamond | 357 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Uroleucon | Uroleucon formosanum |
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);;