contig_metadata
28 rows where bioproject = "PRJEB55250" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1396067 | 1396067 | PRJEB55250_P_NODE_12222_length_250_cov_0.870056_g12098_i0 | PRJEB55250 | 12222 | 250 | 0.870056 | 2.17514 | Manduca sexta | 7130 | Arthropoda | Arthropoda | 71.3 | 6.25e-8 | NTclustered | gi|268306473|gb|GU084325.1| | 7130 | g12098 | i0 | 81.928 | 1.008 | 83 | 15 | 33 | 0 | 3 | 85 | 148 | 230 | Manduca sexta ribosomal protein L29 (rpl29) mRNA, complete cds | blastn | 252 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Sphingidae | Manduca | Manduca sexta | |
| 3947709 | 3947709 | PRJEB55250_P_NODE_10724_length_256_cov_1.513661_g10600_i0 | PRJEB55250 | 10724 | 256 | 1.513661 | 3.87497216 | Diaphorina citri | 121845 | Arthropoda | Arthropoda | 468 | 1.95e-127 | NTclustered | gi|1494774796|ref|XR_003394590.1| | 121845 | g10600 | i0 | 99.609 | 100.5234375 | 256 | 1 | 100 | 0 | 1 | 256 | 1491 | 1746 | PREDICTED: Diaphorina citri large subunit ribosomal RNA (LOC113472154), rRNA | blastn | 25734 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Diaphorina | Diaphorina citri | |
| 3947760 | 3947760 | PRJEB55250_P_NODE_13064_length_248_cov_0.880000_g12940_i0 | PRJEB55250 | 13064 | 248 | 0.88 | 2.1824 | Acyrthosiphon pisum | 7029 | Arthropoda | Arthropoda | 403 | 5.38e-108 | NTclustered | gi|149944780|gb|AC202223.6| | 7029 | g12940 | i0 | 95.984 | 3.36290322580645 | 249 | 9 | 100 | 1 | 1 | 248 | 52244 | 52492 | Acyrthosiphon pisum BAC VMRC38-10-A9 (Benaroya Research Institute VMRC38 Acrythosiphon pisum (Pea Aphid) BAC library) complete sequence | blastn | 834 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Acyrthosiphon | Acyrthosiphon pisum | |
| 3947910 | 3947910 | PRJEB55250_P_NODE_5164_length_312_cov_0.962343_g5040_i0 | PRJEB55250 | 5164 | 312 | 0.962343 | 3.00251016 | Cybister sp. CYE1 | 1075885 | Arthropoda | Arthropoda | 577 | 3.89e-160 | NTclustered | gi|353169492|gb|JN840674.1| | 1075885 | g5040 | i0 | 100 | 99.9423076923077 | 312 | 0 | 100 | 0 | 1 | 312 | 635 | 324 | Cybister sp. CYE1 voucher BMNH:721669 cytochrome c oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 31182 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Dytiscidae | Cybister | Cybister sp. CYE1 | |
| 5224382 | 5224382 | PRJEB55250_P_NODE_8205_length_275_cov_1.143564_g8081_i0 | PRJEB55250 | 8205 | 275 | 1.143564 | 3.144801 | Lysiphlebia japonica | 104022 | Arthropoda | Arthropoda | 58.4 | 5.43e-4 | NTclustered | gi|1251773062|gb|KY809859.1| | 104022 | g8081 | i0 | 97.059 | 0.123636363636364 | 34 | 1 | 12 | 0 | 94 | 127 | 1869 | 1836 | Lysiphlebia japonica elongation factor 1-alpha mRNA, complete cds | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Lysiphlebia | Lysiphlebia japonica | |
| 8645015 | 8645015 | PRJEB55250_P_NODE_2107_length_448_cov_1.434667_g1984_i0 | PRJEB55250 | 2107 | 448 | 1.434667 | 6.42730816 | root | 1 | Root_unresolved | Root_unresolved | 789 | 0 | NTclustered | gi|78097481|gb|AC167665.2| | 7176 | g1984 | i0 | 98.438 | 98 | 448 | 7 | 100 | 0 | 1 | 448 | 79185 | 79632 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940135D9, complete sequence | blastn | 43904 | 795 | 0.992452830188679 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 8645074 | 8645074 | PRJEB55250_P_NODE_8847_length_270_cov_1.289340_g8723_i0 | PRJEB55250 | 8847 | 270 | 1.28934 | 3.481218 | root | 1 | Root_unresolved | Root_unresolved | 483 | 7.409999999999998e-132 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g8723 | i0 | 98.889 | 32.8296296296296 | 270 | 3 | 100 | 0 | 1 | 270 | 5038 | 5307 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 8864 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 10324833 | 10324833 | PRJEB55250_P_NODE_3149_length_376_cov_1.118812_g3025_i0 | PRJEB55250 | 3149 | 376 | 1.118812 | 4.20673312 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 166 | 7.34e-49 | NR | RWS10781.1 | 1965070 | g3025 | i0 | 66.9 | 1.98670212765957 | 124 | 41 | 98.9 | 0 | 4 | 375 | 38 | 161 | RWS10781.1 ribosomal protein-like protein, partial [Dinothrombium tinctorium] | diamond | 747 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombidiidae | Dinothrombium | Dinothrombium tinctorium | |
| 12875370 | 12875370 | PRJEB55250_P_NODE_3671_length_354_cov_1.505338_g3547_i0 | PRJEB55250 | 3671 | 354 | 1.505338 | 5.32889652 | Timema monikensis | 170555 | Arthropoda | Arthropoda | 58.4 | 7.2e-4 | NTclustered | gi|1946411097|emb|OB793204.1| | 170555 | g3547 | i0 | 97.059 | 0.254237288135593 | 34 | 1 | 10 | 0 | 29 | 62 | 168510 | 168543 | 3_Tms_b3v08 | blastn | 90 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema monikensis | |
| 14150215 | 14150215 | PRJEB55250_P_NODE_6152_length_291_cov_1.766055_g6028_i0 | PRJEB55250 | 6152 | 291 | 1.766055 | 5.13922005 | Dermatophagoides pteronyssinus | 6956 | Arthropoda | Arthropoda | 56.5 | 0.002 | NTclustered | gi|1535914965|ref|XM_027343730.1| | 6956 | g6028 | i0 | 100 | 1.72852233676976 | 30 | 0 | 10 | 0 | 108 | 137 | 876 | 905 | PREDICTED: Dermatophagoides pteronyssinus uncharacterized LOC113793668 (LOC113793668), mRNA | blastn | 503 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides pteronyssinus | |
| 17569685 | 17569685 | PRJEB55250_P_NODE_15354_length_243_cov_1.676471_g15230_i0 | PRJEB55250 | 15354 | 243 | 1.676471 | 4.0738245300000004 | root | 1 | Root_unresolved | Root_unresolved | 440 | 4e-119 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g15230 | i0 | 99.585 | 94.3868312757202 | 241 | 1 | 99 | 0 | 3 | 243 | 49999 | 50239 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 22936 | 444 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 19247365 | 19247365 | PRJEB55250_P_NODE_2456_length_419_cov_2.291908_g2333_i0 | PRJEB55250 | 2456 | 419 | 2.291908 | 9.60309452 | Euproctis chrysorrhoea | 987934 | Arthropoda | Arthropoda | 54.7 | 0.011 | NTclustered | gi|2918370018|emb|OZ237905.1| | 987934 | g2333 | i0 | 96.97 | 0.0787589498806683 | 33 | 0 | 8 | 1 | 156 | 187 | 14694390 | 14694358 | Euproctis chrysorrhoea genome assembly, chromosome: 1 | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Erebidae | Euproctis | Euproctis chrysorrhoea | |
| 20118310 | 20118310 | PRJEB55250_P_NODE_10716_length_256_cov_1.568306_g10592_i0 | PRJEB55250 | 10716 | 256 | 1.568306 | 4.01486336 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.95e-127 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g10592 | i0 | 99.609 | 84.18359375 | 256 | 1 | 100 | 0 | 1 | 256 | 45284 | 45539 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 21551 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 22668826 | 22668826 | PRJEB55250_P_NODE_7718_length_278_cov_1.921951_g7594_i0 | PRJEB55250 | 7718 | 278 | 1.921951 | 5.34302378 | Formicidae | 36668 | Arthropoda | Arthropoda | 503 | 5.88e-138 | NTclustered | gi|1419211181|emb|LT977143.1| | 67763 | g7594 | i0 | 99.281 | 99.931654676259 | 278 | 2 | 100 | 0 | 1 | 278 | 149 | 426 | Lasius flavus partial 28S rRNA gene, specimen voucher MCZ:Ent:654750 | blastn | 27781 | 508 | 0.990157480314961 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Lasius | Lasius flavus | |
| 24347602 | 24347602 | PRJEB55250_P_NODE_15860_length_242_cov_1.609467_g15736_i0 | PRJEB55250 | 15860 | 242 | 1.609467 | 3.89491014 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 448 | 2.3799999999999995e-121 | NTclustered | gi|2743035377|ref|XM_065713940.1| | 6661 | g15736 | i0 | 100 | 1 | 242 | 0 | 100 | 0 | 1 | 242 | 1113 | 872 | PREDICTED: Artemia franciscana SERPINE1 mRNA-binding protein 1-like (LOC136033227), mRNA | blastn | 242 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 25217984 | 25217984 | PRJEB55250_P_NODE_5180_length_311_cov_2.289916_g5056_i0 | PRJEB55250 | 5180 | 311 | 2.289916 | 7.12163876 | root | 1 | Root_unresolved | Root_unresolved | 575 | 1.3899999999999995e-159 | NTclustered | gi|78190082|gb|AC168047.3| | 7176 | g5056 | i0 | 100 | 25.2347266881029 | 311 | 0 | 100 | 0 | 1 | 311 | 68174 | 67864 | Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940115D9, complete sequence | blastn | 7848 | 575 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 27532371 | 27532371 | PRJEB55250_P_NODE_13603_length_247_cov_0.885057_g13479_i0 | PRJEB55250 | 13603 | 247 | 0.885057 | 2.18609079 | Insecta | 50557 | Arthropoda | Arthropoda | 69.3 | 1.11e-11 | NR | KAL4717768.1 | 72366 | g13479 | i0 | 48.6 | 9.68016194331984 | 72 | 37 | 87.4 | 0 | 26 | 241 | 20 | 91 | KAL4717768.1 hypothetical protein ACJJTC_000917 [Scirpophaga incertulas] | diamond | 2391 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Crambidae | Scirpophaga | Scirpophaga incertulas | |
| 27728953 | 27728953 | PRJEB55250_P_NODE_11684_length_251_cov_0.865169_g11560_i0 | PRJEB55250 | 11684 | 251 | 0.865169 | 2.17157419 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 45.4 | 0.00452 | NR | XP_049849277.1 | 7010 | g11560 | i0 | 47.8 | 0.549800796812749 | 46 | 22 | 52.6 | 1 | 136 | 5 | 30 | 75 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 138 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 28044290 | 28044290 | PRJEB55250_P_NODE_12165_length_250_cov_0.870056_g12041_i0 | PRJEB55250 | 12165 | 250 | 0.870056 | 2.17514 | Carabus blaptoides fortunei | 49296 | Arthropoda | Arthropoda | 97.4 | 2.3700000000000003e-21 | NR | GLV38013.1 | 49296 | g12041 | i0 | 63 | 0.972 | 81 | 30 | 97.2 | 0 | 244 | 2 | 647 | 727 | GLV38013.1 uncharacterized protein CBL_07811 [Carabus blaptoides fortunei] | diamond | 243 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Carabidae | Carabus | Carabus blaptoides | |
| 28233474 | 28233474 | PRJEB55250_P_NODE_13546_length_247_cov_0.885057_g13422_i0 | PRJEB55250 | 13546 | 247 | 0.885057 | 2.18609079 | Meladema coriacea | 107907 | Arthropoda | Arthropoda | 132 | 8.83e-38 | NR | CAJ17403.1 | 107907 | g13422 | i0 | 91.3 | 1.7004048582996 | 69 | 6 | 83.8 | 0 | 209 | 3 | 1 | 69 | CAJ17403.1 ribosomal protein L28e [Meladema coriacea] | diamond | 420 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Dytiscidae | Meladema | Meladema coriacea | |
| 28644373 | 28644373 | PRJEB55250_P_NODE_14647_length_245_cov_0.895349_g14523_i0 | PRJEB55250 | 14647 | 245 | 0.895349 | 2.19360505 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 56.6 | 4.92e-7 | NR | XP_049848239.1 | 7010 | g14523 | i0 | 31 | 0.869387755102041 | 71 | 49 | 86.9 | 0 | 1 | 213 | 482 | 552 | XP_049848239.1 uncharacterized protein LOC126313330 [Schistocerca gregaria] | diamond | 213 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 29401997 | 29401997 | PRJEB55250_P_NODE_8089_length_276_cov_0.960591_g7965_i0 | PRJEB55250 | 8089 | 276 | 0.960591 | 2.65123116 | Exocentrus adspersus | 1586481 | Arthropoda | Arthropoda | 91.7 | 2.6e-19 | NR | KAJ8924928.1 | 1586481 | g7965 | i0 | 49.4 | 2.83695652173913 | 89 | 45 | 96.7 | 0 | 275 | 9 | 331 | 419 | KAJ8924928.1 hypothetical protein NQ315_001091 [Exocentrus adspersus] | diamond | 783 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Cerambycidae | Exocentrus | Exocentrus adspersus | |
| 29559730 | 29559730 | PRJEB55250_P_NODE_6290_length_290_cov_1.327189_g6166_i0 | PRJEB55250 | 6290 | 290 | 1.327189 | 3.8488481 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 43.5 | 0.00514 | NR | XP_015910180.1 | 114398 | g6166 | i0 | 37.7 | 0.631034482758621 | 61 | 36 | 63.1 | 1 | 2 | 184 | 16 | 74 | XP_015910180.1 cytochrome b-c1 complex subunit 8 [Parasteatoda tepidariorum] | diamond | 183 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 29963704 | 29963704 | PRJEB55250_P_NODE_6471_length_288_cov_1.879070_g6347_i0 | PRJEB55250 | 6471 | 288 | 1.87907 | 5.4117216 | Arachnida | 6854 | Arthropoda | Arthropoda | 131 | 5.48e-34 | NR | XP_015789961.1 | 32264 | g6347 | i0 | 62.8 | 7.16666666666667 | 94 | 35 | 97.9 | 0 | 7 | 288 | 30 | 123 | XP_015789961.1 probable medium-chain specific acyl-CoA dehydrogenase, mitochondrial isoform X2 [Tetranychus urticae] | diamond | 2064 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 30539080 | 30539080 | PRJEB55250_P_NODE_15593_length_243_cov_0.905882_g15469_i0 | PRJEB55250 | 15593 | 243 | 0.905882 | 2.20129326 | Drosophila bipectinata | 42026 | Arthropoda | Arthropoda | 43.5 | 0.0202 | NR | XP_017105683.2 | 42026 | g15469 | i0 | 33.3 | 1.40740740740741 | 57 | 38 | 70.4 | 0 | 48 | 218 | 226 | 282 | XP_017105683.2 rab3 GTPase-activating protein non-catalytic subunit [Drosophila bipectinata] | diamond | 342 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila bipectinata | |
| 31234057 | 31234057 | PRJEB55250_P_NODE_16515_length_241_cov_0.916667_g16391_i0 | PRJEB55250 | 16515 | 241 | 0.916667 | 2.20916747 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 87 | 8.68e-18 | NR | XP_049849277.1 | 7010 | g16391 | i0 | 51.3 | 0.995850622406639 | 80 | 37 | 97.1 | 1 | 234 | 1 | 204 | 283 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 240 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 32681896 | 32681896 | PRJEB55250_P_NODE_6000_length_294_cov_1.416290_g5876_i0 | PRJEB55250 | 6000 | 294 | 1.41629 | 4.1638926 | Metazoa | 33208 | Arthropoda | Arthropoda | 88.6 | 3.99e-19 | NR | RXG61010.1 | 13347 | g5876 | i0 | 54.3 | 3.30612244897959 | 81 | 37 | 82.7 | 0 | 244 | 2 | 144 | 224 | RXG61010.1 hypothetical protein Avbf_14182 [Armadillidium vulgare] | diamond | 972 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Armadillidiidae | Armadillidium | Armadillidium vulgare | |
| 32846254 | 32846254 | PRJEB55250_P_NODE_14700_length_245_cov_0.895349_g14576_i0 | PRJEB55250 | 14700 | 245 | 0.895349 | 2.19360505 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 85.5 | 3.17e-17 | NR | XP_049849277.1 | 7010 | g14576 | i0 | 52.5 | 0.979591836734694 | 80 | 30 | 96.7 | 2 | 238 | 2 | 62 | 134 | XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] | diamond | 240 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria |
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);;