RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB6054" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB6054 · 16 ✖
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
25522983 25522983 PRJEB6054_S_NODE_13801_length_157_cov_2.286885_g13712_i0 PRJEB6054 13801 157 2.286885 3.59040945 Notodromas monacha 399045 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|1937984410|emb|OA882969.1| 399045 g13712 i0 100 0.184713375796178 29 0 18 0 99 127 19088 19116 Notodromas monacha blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
25523084 25523084 PRJEB6054_S_NODE_2985_length_266_cov_2.761905_g2896_i0 PRJEB6054 2985 266 2.761905 7.3466673 Chelidura thaleri 2546182 Arthropoda Arthropoda 52.8 0.024   NTclustered gi|2919607036|emb|OZ238402.1| 2546182 g2896 i0 100 0.105263157894737 28 0 11 0 174 201 5916400 5916427 Chelidura thaleri genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
25523243 25523243 PRJEB6054_S_NODE_689_length_419_cov_7544.627604_g603_i0 PRJEB6054 689 419 7544.627604 31611.98966076 Demodex environmental sample 1856688 Arthropoda Arthropoda 606 6.859999999999998e-169   NTclustered gi|1040064834|gb|KU363928.1| 1856688 g603 i0 98.547 82.0143198090692 344 4 82 1 76 419 345 3 Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence blastn 34364 606 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Demodicidae Demodex Demodex environmental sample
25615520 25615520 PRJEB6054_S_NODE_11929_length_165_cov_3.546154_g11840_i0 PRJEB6054 11929 165 3.546154 5.8511541 Diptera 7147 Arthropoda Arthropoda 152 1.3199999999999998e-32   NTclustered gi|2202972731|ref|XM_023452677.2| 7375 g11840 i0 92.453 63.2181818181818 106 8 64 0 1 106 1140 1245 PREDICTED: Lucilia cuprina actin-57B (LOC111690227), mRNA blastn 10431 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
25659100 25659100 PRJEB6054_S_NODE_6058_length_209_cov_72460.672414_g5969_i0 PRJEB6054 6058 209 72460.672414 151442.80534526 Papilio polytes 76194 Arthropoda Arthropoda 220 4.75e-53   NTclustered gi|389615034|dbj|AK405121.1| 76194 g5969 i0 93.333 21.6698564593301 150 4 70 3 63 209 803 657 Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis blastn 4529 220 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
25794910 25794910 PRJEB6054_S_NODE_12963_length_161_cov_1.420635_g12874_i0 PRJEB6054 12963 161 1.420635 2.28722235 Neodiprion lecontei 441921 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2194857035|ref|XM_046733365.1| 441921 g12874 i0 100 0.180124223602484 29 0 18 0 83 111 5142 5170 PREDICTED: Neodiprion lecontei uncharacterized LOC107224049 (LOC107224049), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Diprionidae Neodiprion Neodiprion lecontei
25931260 25931260 PRJEB6054_S_NODE_2852_length_270_cov_2.361702_g2763_i0 PRJEB6054 2852 270 2.361702 6.3765954 Dyschiriodes sp. 63_EN 1055885 Arthropoda Arthropoda 93.5 1.46e-14   NTclustered gi|340807426|gb|JF778824.1| 1055885 g2763 i0 85.87 22.9518518518519 92 7 33 5 145 233 841 929 Dyschiriodes sp. 63_EN large subunit ribosomal RNA gene, partial sequence blastn 6197 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Dyschiriodes Dyschiriodes sp. 63_EN
26067164 26067164 PRJEB6054_S_NODE_12581_length_163_cov_1.562500_g12492_i0 PRJEB6054 12581 163 1.5625 2.546875 Zerynthia rumina 132710 Arthropoda Arthropoda 58.4 2.92e-4   NTclustered gi|2918382960|emb|OZ238066.1| 132710 g12492 i0 92.683 0.251533742331288 41 2 25 1 122 162 14560642 14560603 Zerynthia rumina genome assembly, chromosome: Z blastn 41 58.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Zerynthia Zerynthia rumina
26067362 26067362 PRJEB6054_S_NODE_5093_length_223_cov_4.255319_g5004_i0 PRJEB6054 5093 223 4.255319 9.48936137 Paroster macrosturtensis 610277 Arthropoda Arthropoda 115 2.4900000000000004e-21   NTclustered gi|2207857403|gb|OL803883.1| 610277 g5004 i0 78.5 1.73991031390135 200 25 87 13 27 221 781 595 Paroster macrosturtensis heat shock protein 83 mRNA, complete cds blastn 388 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Paroster Paroster macrosturtensis
26067436 26067436 PRJEB6054_S_NODE_693_length_418_cov_368.668407_g607_i0 PRJEB6054 693 418 368.668407 1541.03394126 Chironomus tepperi 113505 Arthropoda Arthropoda 135 3.8800000000000006e-27   NTclustered gi|2874216783|ref|XM_070642639.1| 113505 g607 i0 85.606 16.0047846889952 132 15 31 4 236 365 1463 1334 PREDICTED: Chironomus tepperi elongation factor 1-alpha-like (LOC139092294), mRNA blastn 6690 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
26067450 26067450 PRJEB6054_S_NODE_757_length_408_cov_10.399464_g671_i0 PRJEB6054 757 408 10.399464 42.42981312 Hydrometra stagnorum 446445 Arthropoda Arthropoda 424 7.21e-114   NTclustered gi|1131051030|gb|KX821841.1| 446445 g671 i0 89.045 25.843137254902 356 19 84 10 67 408 1433 1084 Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence blastn 10544 424 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Hydrometridae Hydrometra Hydrometra stagnorum
26203455 26203455 PRJEB6054_S_NODE_11558_length_167_cov_10.242424_g11469_i0 PRJEB6054 11558 167 10.242424 17.10484808 Asellus aquaticus 92525 Arthropoda Arthropoda 67.6 5e-7   NTclustered gi|2572721835|gb|OR507567.1| 92525 g11469 i0 90.385 2.37125748502994 52 3 31 1 57 108 499 450 Asellus aquaticus isolate Aaquaticus_PLANINA_201504_3arn large subunit ribosomal RNA gene, partial sequence blastn 396 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Asellidae Asellus Asellus aquaticus
26203595 26203595 PRJEB6054_S_NODE_2654_length_277_cov_12.925620_g2565_i0 PRJEB6054 2654 277 12.92562 35.8039674 Tribolium castaneum 7070 Arthropoda Arthropoda 54.7 0.007   NTclustered gi|2733082151|emb|OX466069.1| 7070 g2565 i0 100 0.104693140794224 29 0 10 0 1 29 2492462 2492490 Tribolium castaneum genome assembly, chromosome: LG9 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
26339239 26339239 PRJEB6054_S_NODE_11415_length_168_cov_2.917293_g11326_i0 PRJEB6054 11415 168 2.917293 4.90105224 Anopheles darlingi 43151 Arthropoda Arthropoda 54.7 0.004   NTclustered gi|2278019553|ref|XM_049689388.1| 43151 g11326 i0 96.875 0.547619047619048 32 1 19 0 61 92 2193 2224 PREDICTED: Anopheles darlingi filaggrin-like (LOC125957032), transcript variant X2, mRNA blastn 92 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles darlingi
33014237 33014237 PRJEB6054_S_NODE_4020_length_238_cov_5.049261_g3931_i0 PRJEB6054 4020 238 5.0492610000000004 12.01724118 Anoplophora glabripennis 217634 Arthropoda Arthropoda 102 7.3e-26   NR XP_018578213.1 217634 g3931 i0 84.1 7.02100840336134 63 10 79.4 0 218 30 71 133 XP_018578213.1 ubiquitin-like protein FUBI [Anoplophora glabripennis] diamond 1671 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Anoplophora Anoplophora glabripennis
33048278 33048278 PRJEB6054_S_NODE_3037_length_264_cov_6.449782_g2948_i0 PRJEB6054 3037 264 6.449782 17.02742448 Nephila pilipes 299642 Arthropoda Arthropoda 47.8 5.22e-4   NR GFT36626.1 299642 g2948 i0 48.4 1.45454545454545 64 29 72.7 2 50 241 66 125 GFT36626.1 hypothetical protein NPIL_642691 [Nephila pilipes] diamond 384 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes

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