RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA795663 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
2055458 2055458 PRJNA795663_S_NODE_8222_length_210_cov_1.121387_g8117_i0 PRJNA795663 8222 210 1.121387 2.3549127 Cryptotermes secundus 105785 Arthropoda Arthropoda 124 6.69e-31   NR XP_023723815.1 105785 g8117 i0 87.1 15 70 9 100 0 1 210 5507 5576 XP_023723815.1 nesprin-1 isoform X4 [Cryptotermes secundus] diamond 3150 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Kalotermitidae Cryptotermes Cryptotermes secundus
2491837 2491837 PRJNA795663_S_NODE_6762_length_228_cov_2.026178_g6657_i0 PRJNA795663 6762 228 2.026178 4.61968584 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 9.21e-26   NR XP_003376876.1 6334 g6657 i0 71 42.2105263157895 69 20 90.8 0 21 227 41 109 XP_003376876.1 60S ribosomal protein L31 [Trichinella spiralis] diamond 9624 103 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella spiralis
8432568 8432568 PRJNA795663_S_NODE_5547_length_249_cov_1.339623_g5442_i0 PRJNA795663 5547 249 1.339623 3.33566127 Anabrus simplex 316456 Arthropoda Arthropoda 151 2.86e-40   NR XP_066991170.2 316456 g5442 i0 82.9 4.89156626506024 82 14 98.8 0 2 247 294 375 XP_066991170.2 anoctamin-1 [Anabrus simplex] diamond 1218 151 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
9707739 9707739 PRJNA795663_S_NODE_6808_length_227_cov_9.594737_g6703_i0 PRJNA795663 6808 227 9.594737 21.78005299 Sus scrofa 9823 Chordata Chordata 112 5.73e-27   NR XP_020938199.1 9823 g6703 i0 82.4 1.5726872246696 68 5 80.6 1 199 17 47 114 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 357 112 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
22456580 22456580 PRJNA795663_S_NODE_2998_length_330_cov_1.566553_g2893_i0 PRJNA795663 2998 330 1.566553 5.1696249 Orthoptera 6993 Arthropoda Arthropoda 185 9.71e-52   NR GLH12362.1 6999 g2893 i0 75.2 4.95454545454545 109 27 99.1 0 329 3 346 454 GLH12362.1 Anoctamin [Gryllus bimaculatus] diamond 1635 186 0.99462365591397806 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
26619760 26619760 PRJNA795663_S_NODE_1381_length_470_cov_2.321016_g1277_i0 PRJNA795663 1381 470 2.321016 10.9087752 Opisthokonta 33154 Arthropoda Arthropoda 228 9.05e-74   NR XP_049848423.1 7010 g1277 i0 75.3 30.631914893617 150 37 95.7 0 2 451 29 178 XP_049848423.1 60S ribosomal protein L11-like isoform X2 [Schistocerca gregaria] diamond 14397 229 0.995633187772926 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
26736854 26736854 PRJNA795663_S_NODE_4921_length_263_cov_1.349558_g4816_i0 PRJNA795663 4921 263 1.349558 3.54933754 Anabrus simplex 316456 Arthropoda Arthropoda 55.8 4.27e-7   NR XP_067006521.1 316456 g4816 i0 81.3 0.365019011406844 32 6 36.5 0 262 167 6 37 XP_067006521.1 28 kDa heat- and acid-stable phosphoprotein [Anabrus simplex] diamond 96 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Tettigoniidae Anabrus Anabrus simplex
26927246 26927246 PRJNA795663_S_NODE_4422_length_277_cov_2.320833_g4317_i0 PRJNA795663 4422 277 2.320833 6.42870741 Cyamophila willieti 2604842 Arthropoda Arthropoda 46.2 0.00181   NR KAL1448479.1 2604842 g4317 i0 46.5 0.465703971119134 43 23 46.6 0 25 153 83 125 KAL1448479.1 hypothetical protein WDU94_005478, partial [Cyamophila willieti] diamond 129 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
27116793 27116793 PRJNA795663_S_NODE_4302_length_281_cov_1.307377_g4197_i0 PRJNA795663 4302 281 1.307377 3.67372937 Schistocerca gregaria 7010 Arthropoda Arthropoda 62.4 5.55e-9   NR XP_049851957.1 7010 g4197 i0 42 1.06761565836299 100 28 95 4 268 2 14 94 XP_049851957.1 protein spalten-like [Schistocerca gregaria] diamond 300 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
27663363 27663363 PRJNA795663_S_NODE_11784_length_181_cov_1.020833_g11679_i0 PRJNA795663 11784 181 1.020833 1.84770773 Schistocerca 7008 Arthropoda Arthropoda 86.3 7.65e-18   NR XP_049835211.1 7010 g11679 i0 66.7 9.94475138121547 60 20 99.4 0 181 2 5952 6011 XP_049835211.1 muscle-specific protein 300 kDa isoform X1 [Schistocerca gregaria] diamond 1800 87 0.991954022988506 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29106571 29106571 PRJNA795663_S_NODE_7568_length_217_cov_2.894444_g7463_i0 PRJNA795663 7568 217 2.894444 6.28094348 Trichinella nativa 6335 Nematoda Nematoda 62.8 2.5e-11   NR KRZ47273.1 6335 g7463 i0 91.7 0.497695852534562 36 3 49.8 0 183 76 8 43 KRZ47273.1 hypothetical protein T02_1459 [Trichinella nativa] diamond 108 62.8 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichinellidae Trichinella Trichinella nativa
29399744 29399744 PRJNA795663_S_NODE_5569_length_248_cov_2.606635_g5464_i0 PRJNA795663 5569 248 2.606635 6.4644548 Metazoa 33208 Arthropoda Arthropoda 73.2 7.47e-13   NR CAD7659214.1 334625 g5464 i0 57.1 6.20564516129032 49 18 55.6 1 4 141 302 350 CAD7659214.1 unnamed protein product [Oppiella nova] diamond 1539 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
29579807 29579807 PRJNA795663_S_NODE_6830_length_227_cov_2.231579_g6725_i0 PRJNA795663 6830 227 2.231579 5.06568433 Blattella germanica 6973 Arthropoda Arthropoda 119 4.72e-29   NR PSN50192.1 6973 g6725 i0 78.7 0.991189427312775 75 16 99.1 0 227 3 4332 4406 PSN50192.1 hypothetical protein C0J52_06636 [Blattella germanica] diamond 225 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
29769422 29769422 PRJNA795663_S_NODE_2871_length_337_cov_1.623333_g2766_i0 PRJNA795663 2871 337 1.623333 5.47063221 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 175 4.5599999999999997e-48   NR XP_021938107.1 136037 g2766 i0 83 0.997032640949555 112 19 99.7 0 337 2 576 687 XP_021938107.1 LOW QUALITY PROTEIN: uncharacterized protein LOC110838813, partial [Zootermopsis nevadensis] diamond 336 175 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
30284557 30284557 PRJNA795663_S_NODE_13652_length_170_cov_2.533835_g13547_i0 PRJNA795663 13652 170 2.533835 4.3075195 Opisthokonta 33154 Rotifera other_Eukaryota 67 3.81e-11   NR CAF0710424.1 104777 g13547 i0 69.8 6.9 43 13 75.9 0 29 157 1057 1099 CAF0710424.1 unnamed protein product [Brachionus calyciflorus] diamond 1173 67 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus calyciflorus
31033566 31033566 PRJNA795663_S_NODE_7475_length_218_cov_2.966851_g7370_i0 PRJNA795663 7475 218 2.966851 6.46773518 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 84.3 2.82e-18   NR CAF0953362.1 1234261 g7370 i0 54.8 2.53211009174312 62 27 83.9 1 3 185 127 188 CAF0953362.1 unnamed protein product [Didymodactylos carnosus] diamond 552 84.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
32771920 32771920 PRJNA795663_S_NODE_13340_length_172_cov_1.429630_g13235_i0 PRJNA795663 13340 172 1.42963 2.4589636 Bacillus rossius redtenbacheri 93214 Arthropoda Arthropoda 90.9 1.59e-19   NR XP_063222932.1 93214 g13235 i0 86 12.9244186046512 57 8 99.4 0 172 2 5227 5283 XP_063222932.1 muscle-specific protein 300 kDa isoform X1 [Bacillus rossius redtenbacheri] diamond 2223 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius

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