RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA999747 · 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
2255843 2255843 PRJNA999747_S_NODE_3502_length_168_cov_1.635036_g3470_i0 PRJNA999747 3502 168 1.635036 2.74686048 Opisthokonta 33154 Arthropoda Arthropoda 89.4 5.03e-19   NR MCL4134467.1 82763 g3470 i0 78.2 15.7142857142857 55 9 98.2 1 3 167 192 243 MCL4134467.1 hypothetical protein [Idotea baltica] diamond 2640 89.7 0.996655518394649 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
4808511 4808511 PRJNA999747_S_NODE_2604_length_192_cov_2.260870_g2572_i0 PRJNA999747 2604 192 2.26087 4.3408704 Schistocerca gregaria 7010 Arthropoda Arthropoda 131 1.03e-36   NR XP_049847781.1 7010 g2572 i0 93.7 0.984375 63 4 98.4 0 4 192 62 124 XP_049847781.1 rho-related protein racB-like [Schistocerca gregaria] diamond 189 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
8633698 8633698 PRJNA999747_S_NODE_267_length_473_cov_4.393665_g239_i0 PRJNA999747 267 473 4.393665 20.78203545 Schistocerca gregaria 7010 Arthropoda Arthropoda 229 5.97e-74   NR XP_049849019.1 7010 g239 i0 81.8 0.86892177589852 137 23 85.6 1 4 408 62 198 XP_049849019.1 ras-related C3 botulinum toxin substrate 1-like [Schistocerca gregaria] diamond 411 229 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
21382731 21382731 PRJNA999747_S_NODE_197_length_518_cov_5.509240_g171_i0 PRJNA999747 197 518 5.50924 28.5378632 Schistocerca gregaria 7010 Arthropoda Arthropoda 251 1.58e-76   NR XP_049848412.1 7010 g171 i0 74.4 0.996138996138996 172 43 99.6 1 518 3 50 220 XP_049848412.1 uncharacterized protein LOC126315215 [Schistocerca gregaria] diamond 516 251 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
21382759 21382759 PRJNA999747_S_NODE_657_length_341_cov_2.158065_g625_i0 PRJNA999747 657 341 2.158065 7.35900165 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 142 1.79e-39   NR XP_013778419.1 6850 g625 i0 75.3 5.91202346041056 97 24 85.3 0 293 3 1 97 XP_013778419.1 14-3-3 protein epsilon-like [Limulus polyphemus] diamond 2016 143 0.993006993006993 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
22657621 22657621 PRJNA999747_S_NODE_418_length_401_cov_4.470270_g386_i0 PRJNA999747 418 401 4.47027 17.9257827 Schistocerca gregaria 7010 Arthropoda Arthropoda 199 1.3499999999999998e-57   NR XP_049849072.1 7010 g386 i0 77.3 0.987531172069825 132 30 98.8 0 4 399 376 507 XP_049849072.1 heat shock 70 kDa protein-like [Schistocerca gregaria] diamond 396 199 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
26741225 26741225 PRJNA999747_S_NODE_3601_length_166_cov_1.466667_g3569_i0 PRJNA999747 3601 166 1.466667 2.43466722 Schistocerca gregaria 7010 Arthropoda Arthropoda 77 1.15e-15   NR XP_049847934.1 7010 g3569 i0 68.5 0.975903614457831 54 17 97.6 0 4 165 123 176 XP_049847934.1 uncharacterized protein LOC126304989 [Schistocerca gregaria] diamond 162 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28138065 28138065 PRJNA999747_S_NODE_3485_length_168_cov_2.963504_g3453_i0 PRJNA999747 3485 168 2.963504 4.97868672 Arthropoda 6656 Arthropoda Arthropoda 68.6 2.52e-12   NR XP_046919890.1 6954 g3453 i0 54.7 4.48214285714286 53 24 94.6 0 163 5 64 116 XP_046919890.1 co-chaperone protein daf-41-like [Dermatophagoides farinae] diamond 753 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
28447923 28447923 PRJNA999747_S_NODE_286_length_458_cov_3.192037_g256_i0 PRJNA999747 286 458 3.192037 14.61952946 Schistocerca gregaria 7010 Arthropoda Arthropoda 176 7.34e-54   NR XP_049851025.1 7010 g256 i0 61.4 0.91703056768559 140 53 91.7 1 37 456 1 139 XP_049851025.1 uncharacterized protein LOC126324550 [Schistocerca gregaria] diamond 420 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28794835 28794835 PRJNA999747_S_NODE_2227_length_205_cov_1.706897_g2195_i0 PRJNA999747 2227 205 1.706897 3.49913885 Schistocerca gregaria 7010 Arthropoda Arthropoda 120 1.1399999999999999e-32   NR XP_049850353.1 7010 g2195 i0 79.4 4.85853658536585 68 14 99.5 0 204 1 11 78 XP_049850353.1 uncharacterized protein LOC126322536 [Schistocerca gregaria] diamond 996 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28953173 28953173 PRJNA999747_S_NODE_2408_length_198_cov_8.760479_g2376_i0 PRJNA999747 2408 198 8.760479 17.34574842 Kerria lacca 473130 Arthropoda Arthropoda 43.5 0.0106   NR XKL61972.1 473130 g2376 i0 44.1 3.09090909090909 68 34 97 2 3 194 243 310 XKL61972.1 hypothetical protein PGB90_001805 [Kerria lacca] diamond 612 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Tachardiidae Kerria Kerria lacca
30658435 30658435 PRJNA999747_S_NODE_2733_length_188_cov_2.343949_g2701_i0 PRJNA999747 2733 188 2.343949 4.40662412 Schistocerca gregaria 7010 Arthropoda Arthropoda 100 1.55e-25   NR XP_049850871.1 7010 g2701 i0 73.8 0.973404255319149 61 16 97.3 0 4 186 41 101 XP_049850871.1 profilin-2-like [Schistocerca gregaria] diamond 183 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32524560 32524560 PRJNA999747_S_NODE_2039_length_213_cov_3.340659_g2007_i0 PRJNA999747 2039 213 3.340659 7.11560367 Schistocerca gregaria 7010 Arthropoda Arthropoda 108 1.3e-27   NR XP_049850888.1 7010 g2007 i0 73.9 0.971830985915493 69 18 97.2 0 5 211 98 166 XP_049850888.1 ras-like protein rasG [Schistocerca gregaria] diamond 207 108 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);;