RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA929924 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
26898472 26898472 PRJNA929924_P_NODE_16461_length_166_cov_0.888889_g16298_i0 PRJNA929924 16461 166 0.888889 1.47555574 Bemisia tabaci 7038 Arthropoda Arthropoda 50.8 1.84e-5   NR CAH0380794.1 7038 g16298 i0 60.4 0.867469879518072 48 18 84.9 1 166 26 185 232 CAH0380794.1 unnamed protein product [Bemisia tabaci] diamond 144 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
26961477 26961477 PRJNA929924_P_NODE_17522_length_163_cov_1.543860_g17359_i0 PRJNA929924 17522 163 1.54386 2.5164918 Bemisia tabaci 7038 Arthropoda Arthropoda 99 6.07e-25   NR XP_018901150.1 7038 g17359 i0 95.9 1.80368098159509 49 2 90.2 0 148 2 38 86 XP_018901150.1 PREDICTED: 40S ribosomal protein S24 isoform X2 [Bemisia tabaci] diamond 294 99 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
27309603 27309603 PRJNA929924_P_NODE_14983_length_169_cov_0.866667_g14820_i0 PRJNA929924 14983 169 0.866667 1.46466723 Halyomorpha halys 286706 Arthropoda Arthropoda 66.6 5.22e-11   NR XP_066902244.1 286706 g14820 i0 65.5 0.976331360946746 55 19 97.6 0 168 4 1439 1493 XP_066902244.1 apolipophorins [Halyomorpha halys] diamond 165 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
27720421 27720421 PRJNA929924_P_NODE_7144_length_392_cov_1.819242_g6981_i0 PRJNA929924 7144 392 1.819242 7.13142864 Pyrrhocoris apterus 37000 Arthropoda Arthropoda 127 4.64e-31   NR AIC66435.1 37000 g6981 i0 57.4 0.826530612244898 108 46 82.7 0 329 6 319 426 AIC66435.1 vitellogenin 2, partial [Pyrrhocoris apterus] diamond 324 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pyrrhocoridae Pyrrhocoris Pyrrhocoris apterus
27751745 27751745 PRJNA929924_P_NODE_18224_length_162_cov_0.920354_g18061_i0 PRJNA929924 18224 162 0.920354 1.49097348 Bemisia tabaci 7038 Arthropoda Arthropoda 115 2.17e-28   NR XP_018916265.1 7038 g18061 i0 98.1 0.981481481481482 53 1 98.1 0 160 2 757 809 XP_018916265.1 PREDICTED: nucleosome-remodeling factor subunit NURF301 [Bemisia tabaci] diamond 159 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
27941037 27941037 PRJNA929924_P_NODE_15025_length_169_cov_0.866667_g14862_i0 PRJNA929924 15025 169 0.866667 1.46466723 Artemia franciscana 6661 Arthropoda Arthropoda 55.5 4.42e-7   NR CAG4635509.1 6661 g14862 i0 55.3 0.834319526627219 47 21 83.4 0 7 147 158 204 CAG4635509.1 EOG090X07NA, partial [Artemia franciscana] diamond 141 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28035772 28035772 PRJNA929924_P_NODE_15245_length_169_cov_0.866667_g15082_i0 PRJNA929924 15245 169 0.866667 1.46466723 Bemisia tabaci 7038 Arthropoda Arthropoda 116 1.8099999999999999e-28   NR XP_018898965.1 7038 g15082 i0 92.9 1.98816568047337 56 4 99.4 0 1 168 520 575 XP_018898965.1 PREDICTED: uncharacterized protein LOC109031724 [Bemisia tabaci] diamond 336 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28516439 28516439 PRJNA929924_P_NODE_13807_length_181_cov_1.318182_g13644_i0 PRJNA929924 13807 181 1.318182 2.38590942 Metazoa 33208 Arthropoda Arthropoda 97.4 9.06e-22   NR XP_027204423.1 6956 g13644 i0 73.3 4.97237569060773 60 16 99.4 0 2 181 169 228 XP_027204423.1 NAD(P) transhydrogenase, mitochondrial-like [Dermatophagoides pteronyssinus] diamond 900 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
28572386 28572386 PRJNA929924_P_NODE_13407_length_185_cov_1.352941_g13244_i0 PRJNA929924 13407 185 1.352941 2.50294085 Ischnura elegans 197161 Arthropoda Arthropoda 70.5 2.86e-12   NR XP_046405787.1 197161 g13244 i0 51.7 2.9027027027027 60 29 97.3 0 2 181 1525 1584 XP_046405787.1 vitellogenin-A1-like [Ischnura elegans] diamond 537 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Coenagrionidae Ischnura Ischnura elegans
28611109 28611109 PRJNA929924_P_NODE_17267_length_164_cov_0.904348_g17104_i0 PRJNA929924 17267 164 0.904348 1.48313072 root 1 Root_unresolved Root_unresolved 75.1 4.96e-14   NR CAH1388808.1 85310 g17104 i0 63 3.95121951219512 54 20 98.8 0 164 3 583 636 CAH1388808.1 unnamed protein product [Nezara viridula] diamond 648 75.5 0.994701986754967 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Nezara Nezara viridula
28635836 28635836 PRJNA929924_P_NODE_15467_length_168_cov_0.873950_g15304_i0 PRJNA929924 15467 168 0.87395 1.468236 Bemisia tabaci 7038 Arthropoda Arthropoda 94 6.929999999999999e-23   NR XP_018898346.1 7038 g15304 i0 87.5 1 56 7 100 0 168 1 30 85 XP_018898346.1 PREDICTED: 60S ribosomal protein L44 [Bemisia tabaci] diamond 168 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28800283 28800283 PRJNA929924_P_NODE_10587_length_231_cov_1.983516_g10424_i0 PRJNA929924 10587 231 1.983516 4.58192196 Bemisia 7037 Arthropoda Arthropoda 115 8.06e-28   NR ADU04394.1 7038 g10424 i0 73.2 1.8961038961039 71 18 92.2 1 17 229 1 70 ADU04394.1 vitellogenin, partial [Bemisia tabaci] diamond 438 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
28863574 28863574 PRJNA929924_P_NODE_9408_length_263_cov_2.855140_g9245_i0 PRJNA929924 9408 263 2.85514 7.5090182 Pentatomidae 160513 Arthropoda Arthropoda 99.4 6.03e-22   NR BAA88076.1 106108 g9245 i0 56 3.80988593155894 84 37 95.8 0 255 4 20 103 BAA88076.1 vitellogenin-2 [Plautia stali] diamond 1002 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Plautia Plautia stali
28983147 28983147 PRJNA929924_P_NODE_16788_length_165_cov_0.896552_g16625_i0 PRJNA929924 16788 165 0.896552 1.4793108 Bemisia tabaci 7038 Arthropoda Arthropoda 74.3 9.24e-14   NR XP_018896024.1 7038 g16625 i0 78 0.909090909090909 50 11 90.9 0 15 164 392 441 XP_018896024.1 PREDICTED: KAT8 regulatory NSL complex subunit 1 [Bemisia tabaci] diamond 150 74.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
29148197 29148197 PRJNA929924_P_NODE_8689_length_294_cov_1.563265_g8526_i0 PRJNA929924 8689 294 1.563265 4.5959991 Bemisia 7037 Arthropoda Arthropoda 165 1.3499999999999999e-48   NR QHB15646.1 7038 g8526 i0 81.6 3 98 18 100 0 1 294 80 177 QHB15646.1 vitellogenin 1, partial [Bemisia tabaci] diamond 882 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
29330187 29330187 PRJNA929924_P_NODE_17509_length_163_cov_1.666667_g17346_i0 PRJNA929924 17509 163 1.666667 2.7166672100000002 Bemisia tabaci 7038 Arthropoda Arthropoda 66.2 6.49e-11   NR XP_018916989.1 7038 g17346 i0 63 0.993865030674847 54 20 99.4 0 2 163 319 372 XP_018916989.1 PREDICTED: sorting nexin-29-like [Bemisia tabaci] diamond 162 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
29740417 29740417 PRJNA929924_P_NODE_15030_length_169_cov_0.866667_g14867_i0 PRJNA929924 15030 169 0.866667 1.46466723 Riptortus pedestris 329032 Arthropoda Arthropoda 81.6 1.49e-17   NR WDD43128.1 329032 g14867 i0 67.9 0.994082840236686 56 18 99.4 0 168 1 33 88 WDD43128.1 hypothetical protein, partial [Riptortus pedestris] diamond 168 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Alydidae Riptortus Riptortus pedestris
30025121 30025121 PRJNA929924_P_NODE_16311_length_166_cov_0.888889_g16148_i0 PRJNA929924 16311 166 0.888889 1.47555574 Bemisia tabaci 7038 Arthropoda Arthropoda 48.1 1.51e-4   NR XP_018912660.1 7038 g16148 i0 52.3 0.795180722891566 44 21 79.5 0 164 33 241 284 XP_018912660.1 PREDICTED: non-structural maintenance of chromosomes element 4 homolog A [Bemisia tabaci] diamond 132 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
30341433 30341433 PRJNA929924_P_NODE_15212_length_169_cov_0.866667_g15049_i0 PRJNA929924 15212 169 0.866667 1.46466723 Bemisia tabaci 7038 Arthropoda Arthropoda 118 2.7099999999999995e-31   NR XP_018907768.1 7038 g15049 i0 96.4 0.976331360946746 55 2 97.6 0 3 167 35 89 XP_018907768.1 PREDICTED: 60S ribosomal protein L13a [Bemisia tabaci] diamond 165 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
30404524 30404524 PRJNA929924_P_NODE_8713_length_292_cov_56.732510_g8550_i0 PRJNA929924 8713 292 56.73251 165.6589292 Nephila pilipes 299642 Arthropoda Arthropoda 51.2 6.39e-5   NR GFT48125.1 299642 g8550 i0 45.2 2.86643835616438 73 40 75 0 283 65 224 296 GFT48125.1 uncharacterized protein NPIL_360421 [Nephila pilipes] diamond 837 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
30561805 30561805 PRJNA929924_P_NODE_16333_length_166_cov_0.888889_g16170_i0 PRJNA929924 16333 166 0.888889 1.47555574 Zophobas morio 2755281 Arthropoda Arthropoda 87.4 2.4e-18   NR KAJ3639174.1 2755281 g16170 i0 74.5 5.96385542168675 55 14 99.4 0 165 1 432 486 KAJ3639174.1 hypothetical protein Zmor_004044 [Zophobas morio] diamond 990 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
31130493 31130493 PRJNA929924_P_NODE_17155_length_164_cov_0.904348_g16992_i0 PRJNA929924 17155 164 0.904348 1.48313072 Bemisia tabaci 7038 Arthropoda Arthropoda 57.8 3.1e-8   NR XP_018895935.1 7038 g16992 i0 62.5 1.02439024390244 56 17 95.1 2 9 164 14 69 XP_018895935.1 PREDICTED: peptidyl-prolyl cis-trans isomerase-like [Bemisia tabaci] diamond 168 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
31295873 31295873 PRJNA929924_P_NODE_13195_length_187_cov_1.507246_g13032_i0 PRJNA929924 13195 187 1.507246 2.81855002 Bemisia 7037 Arthropoda Arthropoda 92.8 3.99e-20   NR ADU04394.1 7038 g13032 i0 76.3 1.92513368983957 59 11 94.7 2 179 3 1 56 ADU04394.1 vitellogenin, partial [Bemisia tabaci] diamond 360 93.6 0.991452991452991 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
31668332 31668332 PRJNA929924_P_NODE_17397_length_164_cov_0.904348_g17234_i0 PRJNA929924 17397 164 0.904348 1.48313072 Bemisia tabaci 7038 Arthropoda Arthropoda 62.4 1.49e-9   NR XP_018909251.1 7038 g17234 i0 68.3 1.5 41 13 75 0 124 2 477 517 XP_018909251.1 PREDICTED: probable ATP-dependent RNA helicase spindle-E [Bemisia tabaci] diamond 246 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
31668334 31668334 PRJNA929924_P_NODE_9517_length_260_cov_1.478673_g9354_i0 PRJNA929924 9517 260 1.478673 3.8445498 Copidosoma floridanum 29053 Arthropoda Arthropoda 91.7 2.87e-19   NR XP_014218074.1 29053 g9354 i0 51.2 2.78076923076923 86 37 99.2 2 2 259 533 613 XP_014218074.1 vitellogenin-1-like, partial [Copidosoma floridanum] diamond 723 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Encyrtidae Copidosoma Copidosoma floridanum
31826400 31826400 PRJNA929924_P_NODE_15697_length_167_cov_2.076271_g15534_i0 PRJNA929924 15697 167 2.076271 3.46737257 Bemisia tabaci 7038 Arthropoda Arthropoda 98.6 2.86e-22   NR XP_018908486.1 7038 g15534 i0 83.3 0.970059880239521 54 9 97 0 6 167 316 369 XP_018908486.1 PREDICTED: lysosomal alpha-mannosidase [Bemisia tabaci] diamond 162 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
32648487 32648487 PRJNA929924_P_NODE_18280_length_162_cov_0.920354_g18117_i0 PRJNA929924 18280 162 0.920354 1.49097348 Bemisia tabaci 7038 Arthropoda Arthropoda 91.3 8.32e-20   NR XP_018903831.1 7038 g18117 i0 75.5 0.981481481481482 53 13 98.1 0 160 2 323 375 XP_018903831.1 PREDICTED: diphthamide biosynthesis protein 2 [Bemisia tabaci] diamond 159 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci
32711728 32711728 PRJNA929924_P_NODE_15220_length_169_cov_0.866667_g15057_i0 PRJNA929924 15220 169 0.866667 1.46466723 Bemisia tabaci 7038 Arthropoda Arthropoda 87.8 1.83e-18   NR XP_018902899.1 7038 g15057 i0 76.8 0.994082840236686 56 13 99.4 0 2 169 705 760 XP_018902899.1 PREDICTED: eukaryotic translation initiation factor 4E transporter [Bemisia tabaci] diamond 168 87.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aleyrodidae Bemisia Bemisia tabaci

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