RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174770 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
15619024 15619024 PRJNA1174770_P_NODE_2133_length_328_cov_1.448029_g2044_i0 PRJNA1174770 2133 328 1.448029 4.74953512 Artemia franciscana 6661 Arthropoda Arthropoda 137 2.93e-39   NR XP_065560387.1 6661 g2044 i0 67.3 0.978658536585366 107 33 97.9 1 7 327 17 121 XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana] diamond 321 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
18167890 18167890 PRJNA1174770_P_NODE_3115_length_265_cov_2.324074_g3026_i0 PRJNA1174770 3115 265 2.324074 6.1587961 Timema genevievae 629358 Arthropoda Arthropoda 144 2.29e-41   NR CAD7601923.1 629358 g3026 i0 86.7 12.8943396226415 83 11 94 0 16 264 71 153 CAD7601923.1 unnamed protein product [Timema genevievae] diamond 3417 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
26819205 26819205 PRJNA1174770_P_NODE_601_length_653_cov_7.120861_g524_i0 PRJNA1174770 601 653 7.120861 46.49922233 Artemia franciscana 6661 Arthropoda Arthropoda 356 9.36e-123   NR KAK2724467.1 6661 g524 i0 99.5 0.978560490045942 213 1 97.9 0 639 1 1 213 KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] diamond 639 356 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27565081 27565081 PRJNA1174770_P_NODE_6944_length_178_cov_2.379845_g6855_i0 PRJNA1174770 6944 178 2.379845 4.2361241 Decapoda 6683 Arthropoda Arthropoda 80.9 1.86e-18   NR KAK8379488.1 85552 g6855 i0 65.4 2.62921348314607 52 18 87.6 0 159 4 1 52 KAK8379488.1 hypothetical protein O3P69_019418 [Scylla paramamosain] diamond 468 81.6 0.991421568627451 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28619845 28619845 PRJNA1174770_P_NODE_11227_length_163_cov_0.912281_g11138_i0 PRJNA1174770 11227 163 0.912281 1.48701803 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 108 1.14e-26   NR CAL4191123.1 48144 g11138 i0 92.6 6.68098159509202 54 4 99.4 0 2 163 158 211 CAL4191123.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 1089 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
29219711 29219711 PRJNA1174770_P_NODE_5029_length_207_cov_0.867089_g4940_i0 PRJNA1174770 5029 207 0.867089 1.79487423 Artemia franciscana 6661 Arthropoda Arthropoda 131 3.69e-38   NR KAK2714786.1 6661 g4940 i0 98.5 0.942028985507246 65 1 94.2 0 12 206 1 65 KAK2714786.1 hypothetical protein QYM36_009113 [Artemia franciscana] diamond 195 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29851175 29851175 PRJNA1174770_P_NODE_8671_length_167_cov_1.669492_g8582_i0 PRJNA1174770 8671 167 1.669492 2.78805164 Folsomia candida 158441 Arthropoda Arthropoda 43.1 0.00669   NR XP_021959805.1 158441 g8582 i0 36.4 0.988023952095808 55 35 98.8 0 2 166 90 144 XP_021959805.1 uncharacterized protein LOC110855700 [Folsomia candida] diamond 165 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
29945923 29945923 PRJNA1174770_P_NODE_4391_length_220_cov_1.520468_g4302_i0 PRJNA1174770 4391 220 1.520468 3.3450296 Artemia franciscana 6661 Arthropoda Arthropoda 143 1.26e-40   NR KAK2713069.1 6661 g4302 i0 98.6 0.981818181818182 72 1 98.2 0 218 3 87 158 KAK2713069.1 hypothetical protein QYM36_011680 [Artemia franciscana] diamond 216 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30059609 30059609 PRJNA1174770_P_NODE_10951_length_164_cov_0.886957_g10862_i0 PRJNA1174770 10951 164 0.886957 1.45460948 Aphididae 27482 Arthropoda Arthropoda 54.7 7.69e-7   NR XP_025421854.1 143950 g10862 i0 67.4 5.50609756097561 43 14 78.7 0 36 164 434 476 XP_025421854.1 eukaryotic translation initiation factor 2D [Sipha flava] diamond 903 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
30198336 30198336 PRJNA1174770_P_NODE_6252_length_187_cov_1.485507_g6163_i0 PRJNA1174770 6252 187 1.485507 2.77789809 Artemia franciscana 6661 Arthropoda Arthropoda 110 5.94e-29   NR XP_065570501.1 6661 g6163 i0 82 0.978609625668449 61 11 97.9 0 186 4 119 179 XP_065570501.1 uncharacterized protein LOC136033627 isoform X2 [Artemia franciscana] diamond 183 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30628253 30628253 PRJNA1174770_P_NODE_3613_length_244_cov_1.441026_g3524_i0 PRJNA1174770 3613 244 1.441026 3.51610344 Insecta 50557 Arthropoda Arthropoda 108 3.16e-29   NR AAL68340.2 7227 g3524 i0 80.4 7.5983606557377 56 11 68.9 0 39 206 13 68 AAL68340.2 RH06643p, partial [Drosophila melanogaster] diamond 1854 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
31209161 31209161 PRJNA1174770_P_NODE_10035_length_165_cov_0.896552_g9946_i0 PRJNA1174770 10035 165 0.896552 1.4793108 Artemia franciscana 6661 Arthropoda Arthropoda 104 1.82e-24   NR XP_065562336.1 6661 g9946 i0 80 2 55 11 100 0 165 1 238 292 XP_065562336.1 lactase/phlorizin hydrolase-like [Artemia franciscana] diamond 330 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32506918 32506918 PRJNA1174770_P_NODE_10139_length_165_cov_0.896552_g10050_i0 PRJNA1174770 10139 165 0.896552 1.4793108 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 95.5 3.46e-21   NR CAL4062729.1 48144 g10050 i0 85.5 1 55 8 100 0 1 165 1698 1752 CAL4062729.1 unnamed protein product [Meganyctiphanes norvegica] diamond 165 95.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica

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