RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJDB14275" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB14275 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
3834753 3834753 PRJDB14275_P_NODE_1724_length_541_cov_39.942231_g1666_i0 PRJDB14275 1724 541 39.942231 216.08746971 Arthropoda 6656 Arthropoda Arthropoda 188 6.01e-58   NR XP_032793488.1 35525 g1666 i0 79.7 10.3974121996303 123 24 68.2 1 463 95 1 122 XP_032793488.1 40S ribosomal protein S17 [Daphnia magna] diamond 5625 188 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
3834766 3834766 PRJDB14275_P_NODE_3164_length_342_cov_1.732673_g3105_i0 PRJDB14275 3164 342 1.732673 5.92574166 Artemia franciscana 6661 Arthropoda Arthropoda 172 1.44e-53   NR KAK2720046.1 6661 g3105 i0 100 0.745614035087719 85 0 74.6 0 74 328 15 99 KAK2720046.1 hypothetical protein QYM36_004080 [Artemia franciscana] diamond 255 172 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
6386885 6386885 PRJDB14275_P_NODE_3206_length_337_cov_4.053691_g3147_i0 PRJDB14275 3206 337 4.053691 13.66093867 Artemia franciscana 6661 Arthropoda Arthropoda 151 2.62e-45   NR KAK2726236.1 6661 g3147 i0 100 0.70326409495549 79 0 70.3 0 277 41 1 79 KAK2726236.1 hypothetical protein QYM36_000629 [Artemia franciscana] diamond 237 151 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
24234453 24234453 PRJDB14275_P_NODE_3240_length_334_cov_10.444068_g3181_i0 PRJDB14275 3240 334 10.444068 34.88318712 Halocaridina rubra 373956 Arthropoda Arthropoda 92.8 2.77e-22   NR KAK7070780.1 373956 g3181 i0 64.5 1.09580838323353 62 22 55.7 0 267 82 1 62 KAK7070780.1 Cytochrome b-c1 complex subunit 9 [Halocaridina rubra] diamond 366 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
26779281 26779281 PRJDB14275_P_NODE_6221_length_186_cov_1.666667_g6162_i0 PRJDB14275 6221 186 1.666667 3.10000062 Halocaridina rubra 373956 Arthropoda Arthropoda 76.3 8.06e-16   NR KAK7067682.1 373956 g6162 i0 59.3 2.87096774193548 59 24 95.2 0 2 178 34 92 KAK7067682.1 Centromere protein S [Halocaridina rubra] diamond 534 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
28011796 28011796 PRJDB14275_P_NODE_4685_length_239_cov_1.010000_g4626_i0 PRJDB14275 4685 239 1.01 2.4139 Artemia franciscana 6661 Arthropoda Arthropoda 114 9.06e-31   NR XP_065570066.1 6661 g4626 i0 70.9 0.99163179916318 79 23 99.2 0 1 237 33 111 XP_065570066.1 leptin receptor gene-related protein-like isoform X2 [Artemia franciscana] diamond 237 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28200810 28200810 PRJDB14275_P_NODE_6306_length_184_cov_1.634483_g6247_i0 PRJDB14275 6306 184 1.634483 3.00744872 Artemia franciscana 6661 Arthropoda Arthropoda 102 1.27e-26   NR KAK2709098.1 6661 g6247 i0 98 0.815217391304348 50 1 81.5 0 184 35 48 97 KAK2709098.1 hypothetical protein QYM36_012944 [Artemia franciscana] diamond 150 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28390459 28390459 PRJDB14275_P_NODE_8366_length_151_cov_1.098214_g8307_i0 PRJDB14275 8366 151 1.098214 1.65830314 Artemia franciscana 6661 Arthropoda Arthropoda 52.4 1.2e-6   NR KAK2711112.1 6661 g8307 i0 66.7 0.834437086092715 42 10 75.5 1 151 38 78 119 KAK2711112.1 hypothetical protein QYM36_012328 [Artemia franciscana] diamond 126 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28548561 28548561 PRJDB14275_P_NODE_5487_length_206_cov_3.670659_g5428_i0 PRJDB14275 5487 206 3.670659 7.56155754 Fopius arisanus 64838 Arthropoda Arthropoda 109 7.960000000000001e-29   NR XP_011300005.1 64838 g5428 i0 82.5 2.75242718446602 63 11 91.7 0 205 17 68 130 XP_011300005.1 uncharacterized protein Nop10 [Fopius arisanus] diamond 567 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Fopius Fopius arisanus
28668894 28668894 PRJDB14275_P_NODE_3367_length_322_cov_14.915194_g3308_i0 PRJDB14275 3367 322 14.915194 48.02692468 Insecta 50557 Arthropoda Arthropoda 85.9 1.06e-19   NR QVD39528.1 7010 g3308 i0 74.1 2.09627329192547 54 14 50.3 0 85 246 1 54 QVD39528.1 Protein stunted [Schistocerca gregaria] diamond 675 86.3 0.995365005793743 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28769285 28769285 PRJDB14275_P_NODE_1707_length_543_cov_17.654762_g1649_i0 PRJDB14275 1707 543 17.654762 95.86535766 Artemia franciscana 6661 Arthropoda Arthropoda 154 1.28e-44   NR XP_065560387.1 6661 g1649 i0 66.4 0.707182320441989 128 40 70.2 2 70 450 1 126 XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana] diamond 384 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28800755 28800755 PRJDB14275_P_NODE_2328_length_443_cov_1.663366_g2269_i0 PRJDB14275 2328 443 1.663366 7.36871138 Artemia franciscana 6661 Arthropoda Arthropoda 154 1.0699999999999998e-41   NR KAK2707618.1 6661 g2269 i0 100 0.602708803611738 89 0 60.3 0 355 89 211 299 KAK2707618.1 hypothetical protein QYM36_015356 [Artemia franciscana] diamond 267 154 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28800758 28800758 PRJDB14275_P_NODE_5268_length_214_cov_3.954286_g5209_i0 PRJDB14275 5268 214 3.954286 8.46217204 Chironomus riparius 315576 Arthropoda Arthropoda 69.3 7e-14   NR CAG9809125.1 315576 g5209 i0 70.6 0.714953271028037 51 13 71.5 1 199 47 1 49 CAG9809125.1 unnamed protein product [Chironomus riparius] diamond 153 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
29369304 29369304 PRJDB14275_P_NODE_3349_length_324_cov_1.792982_g3290_i0 PRJDB14275 3349 324 1.792982 5.80926168 Artemia franciscana 6661 Arthropoda Arthropoda 182 4.87e-56   NR KAK2706750.1 6661 g3290 i0 100 1 108 0 100 0 1 324 64 171 KAK2706750.1 hypothetical protein QYM36_014701 [Artemia franciscana] diamond 324 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29432134 29432134 PRJDB14275_P_NODE_8270_length_152_cov_1.345133_g8211_i0 PRJDB14275 8270 152 1.345133 2.04460216 Artemia franciscana 6661 Arthropoda Arthropoda 58.5 1.62e-9   NR KAK2703894.1 6661 g8211 i0 96.6 0.572368421052632 29 1 57.2 0 152 66 13 41 KAK2703894.1 hypothetical protein QYM36_017819 [Artemia franciscana] diamond 87 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29463588 29463588 PRJDB14275_P_NODE_1090_length_726_cov_36.898108_g1041_i0 PRJDB14275 1090 726 36.898108 267.88026408 Artemia franciscana 6661 Arthropoda Arthropoda 364 1.5299999999999998e-125   NR KAK2724467.1 6661 g1041 i0 99.5 0.888429752066116 215 1 88.8 0 673 29 1 215 KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] diamond 645 364 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29906238 29906238 PRJDB14275_P_NODE_2791_length_379_cov_2.667647_g2732_i0 PRJDB14275 2791 379 2.667647 10.11038213 Daphnia magna 35525 Arthropoda Arthropoda 105 5.56e-27   NR XP_032786053.2 35525 g2732 i0 79.7 0.506596306068602 64 13 50.7 0 25 216 1 64 XP_032786053.2 stress-associated endoplasmic reticulum protein 2 [Daphnia magna] diamond 192 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
30689956 30689956 PRJDB14275_P_NODE_5713_length_199_cov_1.937500_g5654_i0 PRJDB14275 5713 199 1.9375 3.855625 root 1 Root_unresolved Root_unresolved 84.7 2.97e-17   NR KAJ6645170.1 35572 g5654 i0 70.3 7.71859296482412 64 18 96.5 1 197 6 330 392 KAJ6645170.1 Replicative DNA helicase [Pseudolycoriella hygida] diamond 1536 85.5 0.990643274853801 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
31833868 31833868 PRJDB14275_P_NODE_2557_length_411_cov_3.927419_g2498_i0 PRJDB14275 2557 411 3.927419 16.14169209 Artemia franciscana 6661 Arthropoda Arthropoda 191 1.74e-60   NR KAK2723094.1 6661 g2498 i0 100 0.722627737226277 99 0 72.3 0 72 368 1 99 KAK2723094.1 hypothetical protein QYM36_003328 [Artemia franciscana] diamond 297 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
32334707 32334707 PRJDB14275_P_NODE_3119_length_346_cov_11.648208_g3060_i0 PRJDB14275 3119 346 11.648208 40.30279968 Insecta 50557 Arthropoda Arthropoda 110 2.15e-29   NR AAL68340.2 7227 g3060 i0 82.1 5.35838150289017 56 10 48.6 0 82 249 13 68 AAL68340.2 RH06643p, partial [Drosophila melanogaster] diamond 1854 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster

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