RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1047551" 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

  • PRJNA1047551 · 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
10377866 10377866 PRJNA1047551_S_NODE_3569_length_248_cov_1.075117_g3442_i0 PRJNA1047551 3569 248 1.075117 2.66629016 Leptotrombidium deliense 299467 Arthropoda Arthropoda 118 9.919999999999999e-29   NR RWS31269.1 299467 g3442 i0 85.5 0.75 62 9 75 0 248 63 562 623 RWS31269.1 alpha 1:2 mannosidase precursor-like protein [Leptotrombidium deliense] diamond 186 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
26710301 26710301 PRJNA1047551_S_NODE_7221_length_188_cov_3.588235_g7094_i0 PRJNA1047551 7221 188 3.588235 6.7458818 Opisthokonta 33154 Arthropoda Arthropoda 48.1 1.73e-4   NR KOX78024.1 166423 g7094 i0 80 0.781914893617021 25 5 39.9 0 186 112 187 211 KOX78024.1 Proliferating cell nuclear antigen [Melipona quadrifasciata] diamond 147 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Melipona Melipona quadrifasciata
26940202 26940202 PRJNA1047551_S_NODE_9102_length_174_cov_1.287770_g8975_i0 PRJNA1047551 9102 174 1.28777 2.2407198 Ornithodoros turicata 34597 Arthropoda Arthropoda 42 0.0279   NR XP_064486842.1 34597 g8975 i0 67.9 0.482758620689655 28 9 48.3 0 134 51 352 379 XP_064486842.1 mucin-2-like isoform X2 [Ornithodoros turicata] diamond 84 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
27572371 27572371 PRJNA1047551_S_NODE_12084_length_157_cov_1.172131_g11957_i0 PRJNA1047551 12084 157 1.172131 1.84024567 Melanaphis sacchari 742174 Arthropoda Arthropoda 83.6 3.54e-17   NR XP_025206579.1 742174 g11957 i0 76.9 2.98089171974522 52 12 99.4 0 1 156 295 346 XP_025206579.1 NSFL1 cofactor p47 [Melanaphis sacchari] diamond 468 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Melanaphis Melanaphis sacchari
27856505 27856505 PRJNA1047551_S_NODE_9545_length_171_cov_1.308824_g9418_i0 PRJNA1047551 9545 171 1.308824 2.23808904 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 105 6.54e-25   NR NP_001192074.1 7029 g9418 i0 89.3 0.982456140350877 56 6 98.2 0 2 169 34 89 NP_001192074.1 sorting nexin-30-like [Acyrthosiphon pisum] diamond 168 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
29119759 29119759 PRJNA1047551_S_NODE_4649_length_222_cov_1.363636_g4522_i0 PRJNA1047551 4649 222 1.363636 3.02727192 Halotydeus destructor 2874060 Arthropoda Arthropoda 112 1.61e-30   NR KAI1277996.1 2874060 g4522 i0 75.3 0.986486486486487 73 18 98.6 0 221 3 7 79 KAI1277996.1 hypothetical protein HDE_14508 [Halotydeus destructor] diamond 219 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
29466481 29466481 PRJNA1047551_S_NODE_7750_length_184_cov_1.442953_g7623_i0 PRJNA1047551 7750 184 1.442953 2.65503352 Cinara cedri 506608 Arthropoda Arthropoda 89 7.38e-19   NR VVC44866.1 506608 g7623 i0 68.9 1.98913043478261 61 19 99.5 0 1 183 26 86 VVC44866.1 Sugar transporter, conserved site,Major facilitator superfamily domain,Major facilitator, sugar [Cinara cedri] diamond 366 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
30003797 30003797 PRJNA1047551_S_NODE_4431_length_226_cov_1.528796_g4304_i0 PRJNA1047551 4431 226 1.528796 3.45507896 Halotydeus destructor 2874060 Arthropoda Arthropoda 96.3 4.969999999999999e-23   NR KAI1291096.1 2874060 g4304 i0 57.5 0.969026548672566 73 30 95.6 1 218 3 69 141 KAI1291096.1 NADH dehydrogenase [ubiquinone] 1 beta subcomplex subunit 2, mitochondrial [Halotydeus destructor] diamond 219 96.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30375203 30375203 PRJNA1047551_S_NODE_6992_length_191_cov_1.371795_g6865_i0 PRJNA1047551 6992 191 1.371795 2.62012845 Diptera 7147 Arthropoda Arthropoda 104 3.54e-25   NR KFB37578.1 74873 g6865 i0 72.1 4.82198952879581 61 17 95.8 0 2 184 17 77 KFB37578.1 AGAP011350-PA-like protein [Anopheles sinensis] diamond 921 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles sinensis
30532697 30532697 PRJNA1047551_S_NODE_10673_length_164_cov_1.387597_g10546_i0 PRJNA1047551 10673 164 1.387597 2.27565908 Arthropoda 6656 Arthropoda Arthropoda 95.1 4.350000000000001e-21   NR KAL1436099.1 34631 g10546 i0 83 10.6646341463415 53 9 97 0 160 2 425 477 KAL1436099.1 hypothetical protein MTO96_010847 [Rhipicephalus appendiculatus] diamond 1749 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
31354445 31354445 PRJNA1047551_S_NODE_10536_length_165_cov_1.092308_g10409_i0 PRJNA1047551 10536 165 1.092308 1.8023082 Cecidomyiidae 33406 Arthropoda Arthropoda 84 3.79e-17   NR XP_055308422.1 263140 g10409 i0 70.4 3.92727272727273 54 16 98.2 0 2 163 99 152 XP_055308422.1 uncharacterized protein LOC129572485 [Sitodiplosis mosellana] diamond 648 84 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
31741878 31741878 PRJNA1047551_S_NODE_12277_length_156_cov_1.214876_g12150_i0 PRJNA1047551 12277 156 1.214876 1.89520656 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 80.5 3.4e-17   NR KFM61320.1 407821 g12150 i0 89.1 0.884615384615385 46 4 86.5 1 21 155 52 97 KFM61320.1 Protein lethal(2)essential for life, partial [Stegodyphus mimosarum] diamond 138 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
32343407 32343407 PRJNA1047551_S_NODE_4419_length_226_cov_2.010471_g4292_i0 PRJNA1047551 4419 226 2.010471 4.54366446 Schistocerca gregaria 7010 Arthropoda Arthropoda 66.2 1.57e-11   NR XP_049851313.1 7010 g4292 i0 60 0.663716814159292 50 20 66.4 0 212 63 96 145 XP_049851313.1 myosin regulatory light chain-like [Schistocerca gregaria] diamond 150 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria

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