contig_metadata
21 rows where bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118534 | 1118534 | PRJNA543299_P_NODE_18181_length_176_cov_1.976378_g18024_i0 | PRJNA543299 | 18181 | 176 | 1.976378 | 3.47842528 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 326 | 7.92e-85 | NTclustered | gi|16751927|gb|AF169720.2| | 77687 | g18024 | i0 | 100 | 96.0965909090909 | 176 | 0 | 100 | 0 | 1 | 176 | 344 | 519 | Anaspides tasmaniae large subunit ribosomal RNA gene, partial sequence | blastn | 16913 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Anaspidacea | Anaspididae | Anaspides | Anaspides tasmaniae | |
| 1785103 | 1785103 | PRJNA543299_P_NODE_23862_length_163_cov_0.894737_g23705_i0 | PRJNA543299 | 23862 | 163 | 0.894737 | 1.45842131 | Procambarus clarkii | 6728 | Arthropoda | Arthropoda | 56.5 | 0.001 | NTclustered | gi|2837570114|ref|XM_069313848.1| | 6728 | g23705 | i0 | 85.714 | 0.343558282208589 | 56 | 4 | 34 | 4 | 13 | 68 | 152 | 203 | PREDICTED: Procambarus clarkii protein LIAT1-like (LOC138357197), mRNA | blastn | 56 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Cambaridae | Procambarus | Procambarus clarkii | |
| 1785225 | 1785225 | PRJNA543299_P_NODE_7662_length_267_cov_3.238532_g7505_i0 | PRJNA543299 | 7662 | 267 | 3.238532 | 8.64688044 | Corynoneura carriana | 1278985 | Arthropoda | Arthropoda | 252 | 2.24e-62 | NTclustered | gi|2490581767|gb|OQ834389.1| | 2575444 | g7505 | i0 | 84.47 | 0.98876404494382 | 264 | 32 | 97 | 5 | 1 | 259 | 3159 | 3418 | Corynoneura carriana kadalinka isolate COR-GUS4E8-8 510 large subunit ribosomal RNA gene, partial sequence | blastn | 264 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Corynoneura | Corynoneura carriana | |
| 3060590 | 3060590 | PRJNA543299_P_NODE_24623_length_162_cov_1.805310_g24466_i0 | PRJNA543299 | 24623 | 162 | 1.80531 | 2.9246022 | Helicoverpa assulta | 52344 | Arthropoda | Arthropoda | 52.8 | 0.013 | NTclustered | gi|2636206763|emb|OY979789.1| | 52344 | g24466 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 54 | 81 | 12978788 | 12978761 | Helicoverpa assulta genome assembly, chromosome: 15 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Helicoverpa | Helicoverpa assulta | |
| 3060668 | 3060668 | PRJNA543299_P_NODE_6143_length_296_cov_2.048583_g5987_i0 | PRJNA543299 | 6143 | 296 | 2.048583 | 6.06380568 | Clunio marinus | 568069 | Arthropoda | Arthropoda | 435 | 2.34e-117 | NTclustered | gi|1105063683|emb|LN833602.1| | 568069 | g5987 | i0 | 93.023 | 100.530405405405 | 301 | 16 | 100 | 3 | 1 | 296 | 146 | 446 | Clunio marinus genomic DNA sequence contains 18S rRNA gene, ITSITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate Jean | blastn | 29757 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Clunio | Clunio marinus | |
| 8771662 | 8771662 | PRJNA543299_P_NODE_3367_length_393_cov_3.613372_g3215_i0 | PRJNA543299 | 3367 | 393 | 3.613372 | 14.20055196 | Chironomidae | 7149 | Arthropoda | Arthropoda | 424 | 6.91e-114 | NTclustered | gi|1105063683|emb|LN833602.1| | 568069 | g3215 | i0 | 86.386 | 92.5419847328244 | 404 | 36 | 100 | 14 | 1 | 393 | 3249 | 2854 | Clunio marinus genomic DNA sequence contains 18S rRNA gene, ITSITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate Jean | blastn | 36369 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Clunio | Clunio marinus | |
| 9437716 | 9437716 | PRJNA543299_P_NODE_11228_length_223_cov_1.126437_g11071_i0 | PRJNA543299 | 11228 | 223 | 1.126437 | 2.51195451 | Corynoneura carriana | 1278985 | Arthropoda | Arthropoda | 315 | 2.29e-81 | NTclustered | gi|2490581767|gb|OQ834389.1| | 2575444 | g11071 | i0 | 92.07 | 101.37668161435 | 227 | 12 | 100 | 5 | 1 | 223 | 924 | 700 | Corynoneura carriana kadalinka isolate COR-GUS4E8-8 510 large subunit ribosomal RNA gene, partial sequence | blastn | 22607 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Corynoneura | Corynoneura carriana | |
| 10713882 | 10713882 | PRJNA543299_P_NODE_8209_length_259_cov_1.771429_g8052_i0 | PRJNA543299 | 8209 | 259 | 1.771429 | 4.58800111 | Thienemanniella vittata | 879780 | Arthropoda | Arthropoda | 398 | 2.6299999999999997e-106 | NTclustered | gi|1043385720|dbj|LC164785.1| | 879780 | g8052 | i0 | 94.253 | 101.953667953668 | 261 | 13 | 100 | 1 | 1 | 259 | 528 | 268 | Thienemanniella vittata gene for 28S ribosomal RNA, partial sequence | blastn | 26406 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Thienemanniella | Thienemanniella vittata | |
| 11988456 | 11988456 | PRJNA543299_P_NODE_25570_length_161_cov_1.366071_g25413_i0 | PRJNA543299 | 25570 | 161 | 1.366071 | 2.19937431 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 52.8 | 0.013 | NTclustered | gi|1964708817|emb|OC858617.1| | 1979941 | g25413 | i0 | 100 | 0.173913043478261 | 28 | 0 | 17 | 0 | 102 | 129 | 5067 | 5040 | Medioppia subpectinata | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 12597658 | 12597658 | PRJNA543299_P_NODE_9750_length_238_cov_2.772487_g9593_i0 | PRJNA543299 | 9750 | 238 | 2.772487 | 6.59851906 | root | 1 | Root_unresolved | Root_unresolved | 418 | 1.8299999999999998e-112 | NTclustered | gi|294661761|dbj|AB526262.1| | 6669 | g9593 | i0 | 98.319 | 241.336134453782 | 238 | 4 | 100 | 0 | 1 | 238 | 440 | 203 | Daphnia pulex ncRNA, kairomone-inducible transcript | blastn | 57438 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 15812549 | 15812549 | PRJNA543299_P_NODE_7533_length_269_cov_3.877273_g7376_i0 | PRJNA543299 | 7533 | 269 | 3.877273 | 10.42986437 | Corynoneura carriana | 1278985 | Arthropoda | Arthropoda | 409 | 1.27e-109 | NTclustered | gi|2490581767|gb|OQ834389.1| | 2575444 | g7376 | i0 | 94.074 | 83.6245353159851 | 270 | 15 | 100 | 1 | 1 | 269 | 1469 | 1738 | Corynoneura carriana kadalinka isolate COR-GUS4E8-8 510 large subunit ribosomal RNA gene, partial sequence | blastn | 22495 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Corynoneura | Corynoneura carriana | |
| 17087291 | 17087291 | PRJNA543299_P_NODE_6934_length_280_cov_2.645022_g6777_i0 | PRJNA543299 | 6934 | 280 | 2.645022 | 7.4060616 | Notocladius sp. 2 SRM-2010 | 891917 | Arthropoda | Arthropoda | 414 | 2.86e-111 | NTclustered | gi|346682069|gb|HQ440783.1| | 891917 | g6777 | i0 | 93.525 | 14.8321428571429 | 278 | 18 | 99 | 0 | 3 | 280 | 298 | 21 | Notocladius sp. 2 SRM-2010 voucher NOTO 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4153 | 414 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Notocladius | Notocladius sp. 2 SRM-2010 | |
| 18361091 | 18361091 | PRJNA543299_P_NODE_17175_length_181_cov_1.545455_g17018_i0 | PRJNA543299 | 17175 | 181 | 1.545455 | 2.79727355 | Stegobium paniceum | 295656 | Arthropoda | Arthropoda | 335 | 1.36e-87 | NTclustered | gi|54179529|gb|AY748103.1| | 295656 | g17018 | i0 | 100 | 100.46408839779 | 181 | 0 | 100 | 0 | 1 | 181 | 636 | 816 | Stegobium paniceum voucher BMNH:679315 18S ribosomal RNA gene, partial sequence | blastn | 18184 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Ptinidae | Stegobium | Stegobium paniceum | |
| 18970182 | 18970182 | PRJNA543299_P_NODE_25995_length_161_cov_0.910714_g25838_i0 | PRJNA543299 | 25995 | 161 | 0.910714 | 1.46624954 | root | 1 | Root_unresolved | Root_unresolved | 287 | 3.37e-73 | NTclustered | gi|78097479|gb|AC160245.2| | 7176 | g25838 | i0 | 98.758 | 46.9254658385093 | 161 | 2 | 100 | 0 | 1 | 161 | 30417 | 30577 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940136D9, complete sequence | blastn | 7555 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 18970183 | 18970183 | PRJNA543299_P_NODE_26695_length_156_cov_3.785047_g26538_i0 | PRJNA543299 | 26695 | 156 | 3.785047 | 5.90467332 | Chironomidae | 7149 | Arthropoda | Arthropoda | 178 | 2.03e-40 | NTclustered | gi|2486656233|gb|OQ819021.1| | 611500 | g26538 | i0 | 87.261 | 86.75 | 157 | 18 | 100 | 2 | 1 | 156 | 1564 | 1719 | Hydrobaenus laticaudus isolate 617 HYD-BAS8G7-10 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 13533 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Hydrobaenus | Hydrobaenus laticaudus | |
| 19635768 | 19635768 | PRJNA543299_P_NODE_2296_length_466_cov_3.541966_g2151_i0 | PRJNA543299 | 2296 | 466 | 3.541966 | 16.50556156 | Notocladius sp. 2 SRM-2010 | 891917 | Arthropoda | Arthropoda | 747 | 0 | NTclustered | gi|346681916|gb|HQ440630.1| | 891917 | g2151 | i0 | 95.69 | 100.429184549356 | 464 | 20 | 99 | 0 | 1 | 464 | 88 | 551 | Notocladius sp. 2 SRM-2010 voucher NOTO 18S ribosomal RNA gene, partial sequence | blastn | 46800 | 747 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Notocladius | Notocladius sp. 2 SRM-2010 | |
| 20245099 | 20245099 | PRJNA543299_P_NODE_20016_length_167_cov_12.161017_g19859_i0 | PRJNA543299 | 20016 | 167 | 12.161017 | 20.30889839 | root | 1 | Root_unresolved | Root_unresolved | 60.2 | 8.37e-5 | NTclustered | gi|2864127362|ref|XM_070117547.1| | 6689 | g19859 | i0 | 100 | 1.90419161676647 | 32 | 0 | 19 | 0 | 28 | 59 | 42 | 11 | PREDICTED: Penaeus vannamei HECT, UBA and WWE domain containing E3 ubiquitin protein ligase 1 (HUWE1), transcript variant X6, mRNA | blastn | 318 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus vannamei | |
| 27235910 | 27235910 | PRJNA543299_P_NODE_27223_length_151_cov_2.500000_g27066_i0 | PRJNA543299 | 27223 | 151 | 2.5 | 3.775 | Anthophora plagiata | 597819 | Arthropoda | Arthropoda | 43.1 | 0.00784 | NR | CAK9813121.1 | 597819 | g27066 | i0 | 48.6 | 2.04635761589404 | 35 | 18 | 69.5 | 0 | 105 | 1 | 222 | 256 | CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] | diamond | 309 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Anthophora | Anthophora plagiata | |
| 27804609 | 27804609 | PRJNA543299_P_NODE_20804_length_167_cov_0.864407_g20647_i0 | PRJNA543299 | 20804 | 167 | 0.864407 | 1.44355969 | Ixodes hexagonus | 34612 | Arthropoda | Arthropoda | 48.1 | 1.62e-4 | NR | CAL6198435.1 | 34612 | g20647 | i0 | 65.6 | 0.574850299401198 | 32 | 11 | 57.5 | 0 | 161 | 66 | 182 | 213 | CAL6198435.1 unnamed protein product [Ixodes hexagonus] | diamond | 96 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes hexagonus | |
| 30914386 | 30914386 | PRJNA543299_P_NODE_23954_length_163_cov_0.894737_g23797_i0 | PRJNA543299 | 23954 | 163 | 0.894737 | 1.45842131 | Insecta | 50557 | Arthropoda | Arthropoda | 47 | 3.92e-4 | NR | XP_062714690.1 | 7160 | g23797 | i0 | 100 | 8.04294478527607 | 23 | 0 | 42.3 | 0 | 71 | 3 | 735 | 757 | XP_062714690.1 alpha-actinin, sarcomeric isoform X2 [Aedes albopictus] | diamond | 1311 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Aedes | Aedes albopictus | |
| 32779206 | 32779206 | PRJNA543299_P_NODE_24340_length_163_cov_0.894737_g24183_i0 | PRJNA543299 | 24340 | 163 | 0.894737 | 1.45842131 | Daphnia | 6668 | Arthropoda | Arthropoda | 50.4 | 1.19e-5 | NR | KZS20822.1 | 35525 | g24183 | i0 | 76.7 | 1.65644171779141 | 30 | 7 | 55.2 | 0 | 163 | 74 | 143 | 172 | KZS20822.1 Uncharacterized protein APZ42_012487 [Daphnia magna] | diamond | 270 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia magna |
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);;