RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1065838" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1065838 · 19 ✖
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
180174 180174 PRJNA1065838_S_NODE_5561_length_312_cov_3.121673_g5459_i0 PRJNA1065838 5561 312 3.121673 9.73961976 Chelidurella thaleri 2546182 Arthropoda Arthropoda 52.8 0.029   NTclustered gi|2919610158|emb|OZ238415.1| 2546182 g5459 i0 100 0.0897435897435897 28 0 9 0 284 311 2961648 2961675 Chelidura thaleri genome assembly, chromosome: 16 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
1012412 1012412 PRJNA1065838_S_NODE_19621_length_203_cov_1.688312_g19519_i0 PRJNA1065838 19621 203 1.688312 3.42727336 Idotea baltica 82763 Arthropoda Arthropoda 109 8.54e-28   NR MCL4112850.1 82763 g19519 i0 79.1 0.990147783251232 67 13 97.5 1 2 199 72 138 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 201 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
6558043 6558043 PRJNA1065838_S_NODE_33886_length_165_cov_6.241379_g33784_i0 PRJNA1065838 33886 165 6.241379 10.29827535 Artemia franciscana 6661 Arthropoda Arthropoda 139 1.03e-28   NTclustered gi|2743069157|ref|XR_010617433.1| 6661 g33784 i0 95.402 4.56363636363636 87 4 82 0 1 87 3143 3229 PREDICTED: Artemia franciscana E3 ubiquitin-protein ligase COP1-like (LOC136026874), transcript variant X2, misc_RNA blastn 753 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
10383281 10383281 PRJNA1065838_S_NODE_22789_length_194_cov_1.075862_g22687_i0 PRJNA1065838 22789 194 1.075862 2.08717228 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 172 1.23e-38   NTclustered gi|1325255695|ref|XM_023464585.1| 1294199 g22687 i0 83.422 43.1494845360825 187 29 96 2 9 194 939 1124 PREDICTED: Eurytemora carolleeae actin-5C (LOC111695310), mRNA blastn 8371 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
12933704 12933704 PRJNA1065838_S_NODE_17651_length_209_cov_4.187500_g17549_i0 PRJNA1065838 17651 209 4.1875 8.751875 Medioppia subpectinata 1979941 Arthropoda Arthropoda 54.7 0.005   NTclustered gi|1963617327|emb|OC873114.1| 1979941 g17549 i0 100 0.138755980861244 29 0 14 0 148 176 1638 1610 Medioppia subpectinata blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
12933872 12933872 PRJNA1065838_S_NODE_35851_length_162_cov_16.353982_g35749_i0 PRJNA1065838 35851 162 16.353982 26.49345084 Artemia franciscana 6661 Arthropoda Arthropoda 261 2.06e-65   NTclustered gi|2743025003|ref|XR_010621486.1| 6661 g35749 i0 95.679 23.5617283950617 162 7 100 0 1 162 551 712 PREDICTED: Artemia franciscana nitric oxide synthase 1-like (LOC136042911), transcript variant X2, misc_RNA blastn 3817 261 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12933893 12933893 PRJNA1065838_S_NODE_6351_length_296_cov_1.327935_g6249_i0 PRJNA1065838 6351 296 1.327935 3.9306876 Calliphora vicina 7373 Arthropoda Arthropoda 56.5 0.002   NTclustered gi|2736825126|ref|XM_065502654.1| 7373 g6249 i0 97.059 0.114864864864865 34 0 11 1 139 172 442 410 PREDICTED: Calliphora vicina acanthoscurrin-1-like (LOC135952640), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Calliphora Calliphora vicina
21857005 21857005 PRJNA1065838_S_NODE_9598_length_251_cov_1.995050_g9496_i0 PRJNA1065838 9598 251 1.99505 5.0075755 Idotea baltica 82763 Arthropoda Arthropoda 99 1e-23   NR MCL4113740.1 82763 g9496 i0 61.7 0.968127490039841 81 30 95.6 1 1 240 53 133 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 243 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26940466 26940466 PRJNA1065838_S_NODE_23162_length_193_cov_1.444444_g23060_i0 PRJNA1065838 23162 193 1.444444 2.78777692 Procambarus clarkii 6728 Arthropoda Arthropoda 93.2 3.4800000000000006e-21   NR AXR98485.1 6728 g23060 i0 63.5 0.979274611398964 63 23 97.9 0 190 2 130 192 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 189 93.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
27129926 27129926 PRJNA1065838_S_NODE_18462_length_207_cov_0.974684_g18360_i0 PRJNA1065838 18462 207 0.974684 2.01759588 Idotea baltica 82763 Arthropoda Arthropoda 104 3.36e-24   NR MCL4114215.1 82763 g18360 i0 83.6 0.884057971014493 61 7 88.4 1 187 5 570 627 MCL4114215.1 hypothetical protein [Idotea baltica] diamond 183 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27446602 27446602 PRJNA1065838_S_NODE_22243_length_195_cov_4.424658_g22141_i0 PRJNA1065838 22243 195 4.424658 8.6280831 Anthophora plagiata 597819 Arthropoda Arthropoda 43.9 0.00747   NR CAK9813121.1 597819 g22141 i0 48.6 2.69230769230769 35 18 53.8 0 48 152 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 525 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
28425288 28425288 PRJNA1065838_S_NODE_5526_length_313_cov_2.393939_g5424_i0 PRJNA1065838 5526 313 2.393939 7.49302907 Idotea baltica 82763 Arthropoda Arthropoda 156 2.29e-45   NR MCL4112850.1 82763 g5424 i0 71.1 0.929712460063898 97 26 93 1 2 292 142 236 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 291 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28614641 28614641 PRJNA1065838_S_NODE_22407_length_195_cov_1.136986_g22305_i0 PRJNA1065838 22407 195 1.136986 2.2171227 Daphnia pulex 6669 Arthropoda Arthropoda 80.9 1.05e-16   NR EFX61420.1 6669 g22305 i0 83.7 0.661538461538462 43 7 66.2 0 67 195 151 193 EFX61420.1 hypothetical protein DAPPUDRAFT_339680 [Daphnia pulex] diamond 129 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
29056753 29056753 PRJNA1065838_S_NODE_37508_length_154_cov_2.971429_g37406_i0 PRJNA1065838 37508 154 2.971429 4.57600066 Idotea baltica 82763 Arthropoda Arthropoda 67.4 4.51e-12   NR MCL4113740.1 82763 g37406 i0 60 0.974025974025974 50 20 97.4 0 152 3 12 61 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 150 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29269159 29269159 PRJNA1065838_S_NODE_25389_length_187_cov_0.963768_g25287_i0 PRJNA1065838 25389 187 0.963768 1.80224616 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 91.7 2.48e-21   NR MCL4122626.1 82763 g25287 i0 72.9 1.87700534759358 59 16 94.7 0 179 3 74 132 MCL4122626.1 hypothetical protein [Idotea baltica] diamond 351 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31227741 31227741 PRJNA1065838_S_NODE_18995_length_205_cov_1.871795_g18893_i0 PRJNA1065838 18995 205 1.871795 3.8371797499999998 Opisthokonta 33154 Arthropoda Arthropoda 43.1 0.0166   NR XP_032594159.1 7222 g18893 i0 36.8 3.36585365853659 57 30 74.6 3 51 203 1158 1214 XP_032594159.1 furin-like protease 2 isoform X1 [Drosophila grimshawi] diamond 690 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
31354504 31354504 PRJNA1065838_S_NODE_12336_length_229_cov_942.083333_g12234_i0 PRJNA1065838 12336 229 942.083333 2157.37083257 Gryllus 6998 Arthropoda Arthropoda 58.5 8.12e-8   NR GLG93432.1 6999 g12234 i0 78.8 16.8340611353712 33 7 43.2 0 152 54 230 262 GLG93432.1 Coatomer subunit beta [Gryllus bimaculatus] diamond 3855 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
31362872 31362872 PRJNA1065838_S_NODE_22336_length_195_cov_1.520548_g22234_i0 PRJNA1065838 22336 195 1.520548 2.9650686 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 48.5 2.96e-5   NR CAL4117781.1 48144 g22234 i0 44.7 0.723076923076923 47 26 72.3 0 1 141 54 100 CAL4117781.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 141 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
31733804 31733804 PRJNA1065838_S_NODE_19417_length_204_cov_0.812903_g19315_i0 PRJNA1065838 19417 204 0.812903 1.65832212 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.5 5.61e-7   NR AXR98485.1 6728 g19315 i0 50.9 3.27941176470588 55 23 75 1 197 45 10 64 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 669 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;