RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA796639" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA796639 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
1216543 1216543 PRJNA796639_P_NODE_7601_length_242_cov_0.911243_g7476_i0 PRJNA796639 7601 242 0.911243 2.20520806 Cryptotermes secundus 105785 Arthropoda Arthropoda 79.3 4.91e-15   NR XP_023703413.1 105785 g7476 i0 85.9 1.92148760330579 78 10 95.5 1 232 2 3214 3291 XP_023703413.1 uncharacterized protein LOC111862342 isoform X2 [Cryptotermes secundus] diamond 465 79.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
5884069 5884069 PRJNA796639_P_NODE_6525_length_247_cov_0.885057_g6400_i0 PRJNA796639 6525 247 0.885057 2.18609079 Coptotermes formosanus 36987 Arthropoda Arthropoda 152 8.19e-42   NR GFG30420.1 36987 g6400 i0 93.9 0.995951417004049 82 5 99.6 0 247 2 1 82 GFG30420.1 hypothetical protein Cfor_12929 [Coptotermes formosanus] diamond 246 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
10145106 10145106 PRJNA796639_P_NODE_3108_length_318_cov_1.514286_g2983_i0 PRJNA796639 3108 318 1.514286 4.81542948 Cryptotermes secundus 105785 Arthropoda Arthropoda 153 3.04e-44   NR PNF32194.1 105785 g2983 i0 97.6 0.792452830188679 84 2 79.2 0 316 65 87 170 PNF32194.1 hypothetical protein B7P43_G00719 [Cryptotermes secundus] diamond 252 153 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
10984460 10984460 PRJNA796639_P_NODE_4789_length_269_cov_1.178571_g4664_i0 PRJNA796639 4789 269 1.178571 3.17035599 Mesostigmata 34634 Arthropoda Arthropoda 170 1.54e-51   NR XP_022647179.1 109461 g4664 i0 95.5 1.98513011152416 89 4 99.3 0 269 3 54 142 XP_022647179.1 60S ribosomal protein L19-like [Varroa destructor] diamond 534 170 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor
12260063 12260063 PRJNA796639_P_NODE_7310_length_243_cov_0.905882_g7185_i0 PRJNA796639 7310 243 0.905882 2.20129326 Arthropoda 6656 Arthropoda Arthropoda 132 6.0799999999999985e-34   NR NP_729940.1 7227 g7185 i0 80 190.543209876543 80 16 98.8 0 3 242 297 376 NP_729940.1 heat shock protein 70 cognate 1, isoform C [Drosophila melanogaster] diamond 46302 133 0.992481203007519 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
26642261 26642261 PRJNA796639_P_NODE_7361_length_243_cov_0.905882_g7236_i0 PRJNA796639 7361 243 0.905882 2.20129326 Coptotermes formosanus 36987 Arthropoda Arthropoda 143 2.1499999999999994e-42   NR GFG28888.1 36987 g7236 i0 91.9 0.91358024691358 74 6 91.4 0 20 241 28 101 GFG28888.1 hypothetical protein Cfor_06264 [Coptotermes formosanus] diamond 222 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
26673650 26673650 PRJNA796639_P_NODE_6101_length_249_cov_0.875000_g5976_i0 PRJNA796639 6101 249 0.875 2.17875 Coptotermes formosanus 36987 Arthropoda Arthropoda 123 1.4899999999999998e-30   NR GFG40024.1 36987 g5976 i0 71.6 1.06024096385542 88 20 100 1 249 1 22 109 GFG40024.1 hypothetical protein Cfor_10572 [Coptotermes formosanus] diamond 264 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
26746078 26746078 PRJNA796639_P_NODE_1701_length_429_cov_1.662921_g1576_i0 PRJNA796639 1701 429 1.662921 7.13393109 Blattodea 85823 Arthropoda Arthropoda 216 4.59e-68   NR XP_069679933.1 6978 g1576 i0 75.4 4.95104895104895 142 35 99.3 0 4 429 1 142 XP_069679933.1 trypsin beta-like [Periplaneta americana] diamond 2124 216 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
26832361 26832361 PRJNA796639_P_NODE_6761_length_246_cov_0.890173_g6636_i0 PRJNA796639 6761 246 0.890173 2.18982558 Galendromus occidentalis 34638 Arthropoda Arthropoda 139 4.43e-36   NR XP_028968425.1 34638 g6636 i0 80.5 1 82 16 100 0 246 1 530 611 XP_028968425.1 tRNA (cytosine(34)-C(5))-methyltransferase [Galendromus occidentalis] diamond 246 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
27663375 27663375 PRJNA796639_P_NODE_6444_length_247_cov_0.885057_g6319_i0 PRJNA796639 6444 247 0.885057 2.18609079 Blattodea 85823 Arthropoda Arthropoda 144 1.33e-42   NR GFG36495.1 36987 g6319 i0 83.1 2.90283400809717 77 13 93.5 0 232 2 2 78 GFG36495.1 hypothetical protein Cfor_04647, partial [Coptotermes formosanus] diamond 717 145 0.993103448275862 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
27749081 27749081 PRJNA796639_P_NODE_7124_length_244_cov_0.900585_g6999_i0 PRJNA796639 7124 244 0.900585 2.1974274 Galendromus occidentalis 34638 Arthropoda Arthropoda 45.4 0.00406   NR XP_003745419.1 34638 g6999 i0 54.2 0.590163934426229 48 18 59 2 1 144 150 193 XP_003745419.1 acyl-CoA-binding domain-containing protein 5 [Galendromus occidentalis] diamond 144 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
27780533 27780533 PRJNA796639_P_NODE_7184_length_244_cov_0.900585_g7059_i0 PRJNA796639 7184 244 0.900585 2.1974274 Idotea baltica 82763 Arthropoda Arthropoda 145 2.4599999999999993e-43   NR MCL4118773.1 82763 g7059 i0 81.5 0.995901639344262 81 15 99.6 0 244 2 3 83 MCL4118773.1 hypothetical protein [Idotea baltica] diamond 243 145 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
28727651 28727651 PRJNA796639_P_NODE_6007_length_249_cov_0.875000_g5882_i0 PRJNA796639 6007 249 0.875 2.17875 Halyomorpha halys 286706 Arthropoda Arthropoda 95.5 1.12e-20   NR XP_014293272.1 286706 g5882 i0 62.2 0.891566265060241 74 28 89.2 0 28 249 226 299 XP_014293272.1 insulin-like growth factor-binding protein complex acid labile subunit [Halyomorpha halys] diamond 222 95.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
28885372 28885372 PRJNA796639_P_NODE_6768_length_246_cov_0.890173_g6643_i0 PRJNA796639 6768 246 0.890173 2.18982558 Galendromus occidentalis 34638 Arthropoda Arthropoda 47.4 8.14e-4   NR XP_003739722.1 34638 g6643 i0 81.8 0.402439024390244 33 6 40.2 0 108 10 232 264 XP_003739722.1 proteasome subunit alpha type-4 [Galendromus occidentalis] diamond 99 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
28894497 28894497 PRJNA796639_P_NODE_7748_length_241_cov_0.916667_g7623_i0 PRJNA796639 7748 241 0.916667 2.20916747 Blattodea 85823 Arthropoda Arthropoda 88.2 3.69e-18   NR PSN46743.1 6973 g7623 i0 93.2 1.64315352697095 44 3 54.8 0 240 109 768 811 PSN46743.1 26S proteasome regulatory subunit rpn-1 [Blattella germanica] diamond 396 88.6 0.99548532731377 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28916829 28916829 PRJNA796639_P_NODE_7768_length_241_cov_0.916667_g7643_i0 PRJNA796639 7768 241 0.916667 2.20916747 Cryptotermes secundus 105785 Arthropoda Arthropoda 127 1.8e-32   NR XP_023726864.1 105785 g7643 i0 76.9 0.970954356846473 78 18 97.1 0 234 1 252 329 XP_023726864.1 probable cytochrome P450 301a1, mitochondrial [Cryptotermes secundus] diamond 234 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
28948865 28948865 PRJNA796639_P_NODE_7568_length_242_cov_0.911243_g7443_i0 PRJNA796639 7568 242 0.911243 2.20520806 Varroa destructor 109461 Arthropoda Arthropoda 66.2 1.96e-10   NR XP_022664908.1 109461 g7443 i0 39.3 4.06611570247934 84 47 99.2 2 2 241 789 872 XP_022664908.1 uncharacterized protein LOC111251967 isoform X3 [Varroa destructor] diamond 984 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Varroidae Varroa Varroa destructor
29968244 29968244 PRJNA796639_P_NODE_6711_length_246_cov_0.890173_g6586_i0 PRJNA796639 6711 246 0.890173 2.18982558 Blattodea 85823 Arthropoda Arthropoda 114 1.16e-29   NR XP_023704642.1 105785 g6586 i0 98 3.70731707317073 51 1 62.2 0 93 245 113 163 XP_023704642.1 ORM1-like protein 3 isoform X1 [Cryptotermes secundus] diamond 912 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
30022407 30022407 PRJNA796639_P_NODE_2631_length_347_cov_1.686131_g2506_i0 PRJNA796639 2631 347 1.686131 5.85087457 Coptotermes formosanus 36987 Arthropoda Arthropoda 166 1.43e-48   NR AGM32769.1 36987 g2506 i0 71.2 0.899135446685879 104 30 89.9 0 346 35 171 274 AGM32769.1 chitin binding peritrophin-A domain containing protein [Coptotermes formosanus] diamond 312 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30338656 30338656 PRJNA796639_P_NODE_6972_length_245_cov_0.895349_g6847_i0 PRJNA796639 6972 245 0.895349 2.19360505 Anabrus simplex 316456 Arthropoda Arthropoda 74.7 2.11e-13   NR XP_068082957.1 316456 g6847 i0 65.5 0.673469387755102 55 19 67.3 0 167 3 172 226 XP_068082957.1 uncharacterized protein [Anabrus simplex] diamond 165 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
30370248 30370248 PRJNA796639_P_NODE_5752_length_250_cov_0.870056_g5627_i0 PRJNA796639 5752 250 0.870056 2.17514 Coptotermes formosanus 36987 Arthropoda Arthropoda 155 1.5399999999999999e-43   NR GFG39718.1 36987 g5627 i0 91.5 0.984 82 7 98.4 0 250 5 112 193 GFG39718.1 hypothetical protein Cfor_11123 [Coptotermes formosanus] diamond 246 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30559137 30559137 PRJNA796639_P_NODE_7033_length_245_cov_0.883721_g6908_i0 PRJNA796639 7033 245 0.883721 2.16511645 Coptotermes formosanus 36987 Arthropoda Arthropoda 110 5.1100000000000005e-26   NR GFG34209.1 36987 g6908 i0 94.6 0.685714285714286 56 3 68.6 0 76 243 1 56 GFG34209.1 hypothetical protein Cfor_00477 [Coptotermes formosanus] diamond 168 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30685605 30685605 PRJNA796639_P_NODE_6153_length_249_cov_0.875000_g6028_i0 PRJNA796639 6153 249 0.875 2.17875 Periplaneta americana 6978 Arthropoda Arthropoda 46.2 0.00254   NR KAJ4451635.1 6978 g6028 i0 63.3 3.25301204819277 30 11 36.1 0 4 93 1598 1627 KAJ4451635.1 hypothetical protein ANN_03104 [Periplaneta americana] diamond 810 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30717217 30717217 PRJNA796639_P_NODE_6314_length_248_cov_0.880000_g6189_i0 PRJNA796639 6314 248 0.88 2.1824 Coptotermes formosanus 36987 Arthropoda Arthropoda 176 6.04e-50   NR GFG37054.1 36987 g6189 i0 93.9 0.991935483870968 82 5 99.2 0 1 246 87 168 GFG37054.1 hypothetical protein Cfor_05441 [Coptotermes formosanus] diamond 246 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30938665 30938665 PRJNA796639_P_NODE_7034_length_245_cov_0.883721_g6909_i0 PRJNA796639 7034 245 0.883721 2.16511645 Coptotermes formosanus 36987 Arthropoda Arthropoda 83.2 2.18e-16   NR GFG30352.1 36987 g6909 i0 98.4 0.759183673469388 62 1 75.9 0 244 59 242 303 GFG30352.1 hypothetical protein Cfor_12937 [Coptotermes formosanus] diamond 186 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
31190927 31190927 PRJNA796639_P_NODE_7715_length_241_cov_0.916667_g7590_i0 PRJNA796639 7715 241 0.916667 2.20916747 Coptotermes formosanus 36987 Arthropoda Arthropoda 144 5.19e-38   NR GFG32582.1 36987 g7590 i0 89.9 0.983402489626556 79 8 98.3 0 2 238 621 699 GFG32582.1 hypothetical protein Cfor_12353 [Coptotermes formosanus] diamond 237 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
31254471 31254471 PRJNA796639_P_NODE_6955_length_245_cov_0.895349_g6830_i0 PRJNA796639 6955 245 0.895349 2.19360505 Cryptotermes secundus 105785 Arthropoda Arthropoda 90.5 3.4300000000000004e-21   NR PNF29924.1 105785 g6830 i0 66.1 0.759183673469388 62 21 75.9 0 198 13 1 62 PNF29924.1 hypothetical protein B7P43_G07270 [Cryptotermes secundus] diamond 186 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
31381218 31381218 PRJNA796639_P_NODE_1336_length_486_cov_1.721550_g1211_i0 PRJNA796639 1336 486 1.72155 8.366733 Coptotermes formosanus 36987 Arthropoda Arthropoda 181 1.8899999999999998e-54   NR GFG33529.1 36987 g1211 i0 64.6 0.907407407407407 147 52 90.7 0 3 443 85 231 GFG33529.1 hypothetical protein Cfor_00854, partial [Coptotermes formosanus] diamond 441 181 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
32362009 32362009 PRJNA796639_P_NODE_6119_length_249_cov_0.875000_g5994_i0 PRJNA796639 6119 249 0.875 2.17875 Oryctes borbonicus 1629725 Arthropoda Arthropoda 65.9 2.91e-10   NR KRT86457.1 1629725 g5994 i0 45.6 1.67469879518072 79 41 92.8 2 14 244 1319 1397 KRT86457.1 AAA protein, partial [Oryctes borbonicus] diamond 417 65.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Oryctes Oryctes borbonicus
32393417 32393417 PRJNA796639_P_NODE_6419_length_247_cov_1.183908_g6294_i0 PRJNA796639 6419 247 1.183908 2.92425276 Coptotermes formosanus 36987 Arthropoda Arthropoda 100 3.76e-24   NR GFG33529.1 36987 g6294 i0 62.5 1.91902834008097 80 30 97.2 0 6 245 6 85 GFG33529.1 hypothetical protein Cfor_00854, partial [Coptotermes formosanus] diamond 474 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
32645789 32645789 PRJNA796639_P_NODE_6500_length_247_cov_0.885057_g6375_i0 PRJNA796639 6500 247 0.885057 2.18609079 Drosophila ananassae 7217 Arthropoda Arthropoda 43.1 0.0296   NR XP_044570436.1 7217 g6375 i0 46.8 0.57085020242915 47 25 57.1 0 147 7 747 793 XP_044570436.1 uncharacterized protein LOC26513718 [Drosophila ananassae] diamond 141 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila ananassae

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