RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJEB65099 · 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
1404499 1404499 PRJEB65099_P_NODE_6642_length_243_cov_0.917647_g6537_i0 PRJEB65099 6642 243 0.917647 2.22988221 Meloidogyne enterolobii 390850 Nematoda Nematoda 154 1.71e-41   NR CAD2175649.1 390850 g6537 i0 100 0.987654320987654 80 0 98.8 0 2 241 129 208 CAD2175649.1 unnamed protein product [Meloidogyne enterolobii] diamond 240 154 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
16706624 16706624 PRJEB65099_P_NODE_5714_length_248_cov_0.891429_g5609_i0 PRJEB65099 5714 248 0.891429 2.21074392 Metazoa 33208 Platyhelminthes Platyhelminthes 130 9.359999999999999e-34   NR KAH8878026.1 6182 g5609 i0 79.3 44.3709677419355 82 17 99.2 0 247 2 341 422 KAH8878026.1 ATP synthase subunit alpha, mitochondrial [Schistosoma japonicum] diamond 11004 130 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
18845526 18845526 PRJEB65099_P_NODE_6175_length_246_cov_0.901734_g6070_i0 PRJEB65099 6175 246 0.901734 2.21826564 Uloborus diversus 327109 Arthropoda Arthropoda 118 5.710000000000001e-29   NR XP_054711886.1 327109 g6070 i0 67.9 2.9390243902439 81 25 98.8 1 245 3 263 342 XP_054711886.1 aldehyde dehydrogenase, mitochondrial-like [Uloborus diversus] diamond 723 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
26812423 26812423 PRJEB65099_P_NODE_1721_length_459_cov_1.277202_g1616_i0 PRJEB65099 1721 459 1.277202 5.86235718 Tribolium castaneum 7070 Arthropoda Arthropoda 46.6 0.0147   NR XP_008199173.3 7070 g1616 i0 35.8 0.830065359477124 81 49 51.6 3 158 394 470 549 XP_008199173.3 protein bride of sevenless [Tribolium castaneum] diamond 381 47 0.991489361702128 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
27539541 27539541 PRJEB65099_P_NODE_6084_length_246_cov_0.901734_g5979_i0 PRJEB65099 6084 246 0.901734 2.21826564 Meloidogyne enterolobii 390850 Nematoda Nematoda 157 3e-43   NR CAD2191354.1 390850 g5979 i0 100 0.98780487804878 81 0 98.8 0 2 244 114 194 CAD2191354.1 unnamed protein product [Meloidogyne enterolobii] diamond 243 157 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
28139639 28139639 PRJEB65099_P_NODE_5445_length_250_cov_0.881356_g5340_i0 PRJEB65099 5445 250 0.881356 2.20339 Meloidogyne enterolobii 390850 Nematoda Nematoda 141 9.68e-37   NR CAD2201877.1 390850 g5340 i0 94 1.992 83 5 99.6 0 250 2 955 1037 CAD2201877.1 unnamed protein product [Meloidogyne enterolobii] diamond 498 141 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
28202305 28202305 PRJEB65099_P_NODE_5006_length_253_cov_0.866667_g4901_i0 PRJEB65099 5006 253 0.866667 2.19266751 Meloidogyne enterolobii 390850 Nematoda Nematoda 126 1.46e-34   NR CAK5047598.1 390850 g4901 i0 84.5 0.841897233201581 71 11 84.2 0 2 214 104 174 CAK5047598.1 unnamed protein product [Meloidogyne enterolobii] diamond 213 126 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
28928729 28928729 PRJEB65099_P_NODE_5948_length_247_cov_0.896552_g5843_i0 PRJEB65099 5948 247 0.896552 2.21448344 Meloidogyne enterolobii 390850 Nematoda Nematoda 109 4.05e-29   NR CAD2151794.1 390850 g5843 i0 72 0.995951417004049 82 17 92.3 2 230 3 1 82 CAD2151794.1 unnamed protein product [Meloidogyne enterolobii] diamond 246 109 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
29370847 29370847 PRJEB65099_P_NODE_3749_length_288_cov_1.437209_g3644_i0 PRJEB65099 3749 288 1.437209 4.13916192 Dermatophagoides pteronyssinus 6956 Arthropoda Arthropoda 140 2.28e-36   NR KAH9423303.1 6956 g3644 i0 98.6 0.739583333333333 71 1 74 0 213 1 91 161 KAH9423303.1 Inositol hexakisphosphate and diphosphoinositol-pentakisphosphate kinase 2 [Dermatophagoides pteronyssinus] diamond 213 140 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29749356 29749356 PRJEB65099_P_NODE_5311_length_251_cov_0.876404_g5206_i0 PRJEB65099 5311 251 0.876404 2.19977404 Meloidogyne graminicola 189291 Nematoda Nematoda 157 4.029999999999999e-43   NR KAF7632378.1 189291 g5206 i0 92.8 0.99203187250996006 83 6 99.2 0 251 3 33 115 KAF7632378.1 hypothetical protein Mgra_00008227 [Meloidogyne graminicola] diamond 249 157 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne graminicola
30287074 30287074 PRJEB65099_P_NODE_5752_length_248_cov_0.891429_g5647_i0 PRJEB65099 5752 248 0.891429 2.21074392 Meloidogyne enterolobii 390850 Nematoda Nematoda 165 3.36e-47   NR CAD2188016.1 390850 g5647 i0 100 4.95967741935484 82 0 99.2 0 248 3 82 163 CAD2188016.1 unnamed protein product [Meloidogyne enterolobii] diamond 1230 165 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
30381887 30381887 PRJEB65099_P_NODE_6793_length_242_cov_0.923077_g6688_i0 PRJEB65099 6793 242 0.923077 2.23384634 Artemia franciscana 6661 Arthropoda Arthropoda 52.8 1.1e-5   NR XP_065575607.1 6661 g6688 i0 37.3 1.41322314049587 67 38 81.8 2 198 1 89 152 XP_065575607.1 tyrosine-protein kinase Abl-like isoform X3 [Artemia franciscana] diamond 342 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30539415 30539415 PRJEB65099_P_NODE_5953_length_247_cov_0.896552_g5848_i0 PRJEB65099 5953 247 0.896552 2.21448344 Meloidogyne enterolobii 390850 Nematoda Nematoda 110 2.6500000000000004e-27   NR CAD2165589.1 390850 g5848 i0 94.2 1.89473684210526 52 3 63.2 0 3 158 244 295 CAD2165589.1 unnamed protein product [Meloidogyne enterolobii] diamond 468 110 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii
30753628 30753628 PRJEB65099_P_NODE_5234_length_251_cov_0.876404_g5129_i0 PRJEB65099 5234 251 0.876404 2.19977404 Metazoa 33208 Cnidaria other_Eukaryota 68.2 4.59e-11   NR KAK2546729.1 6130 g5129 i0 41.7 3.8605577689243 84 45 96.8 2 1 243 708 790 KAK2546729.1 hypothetical protein P5673_033636, partial [Acropora cervicornis] diamond 969 68.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
31392879 31392879 PRJEB65099_P_NODE_6916_length_242_cov_0.923077_g6811_i0 PRJEB65099 6916 242 0.923077 2.23384634 Leucoraja erinaceus 7782 Chordata Chordata 45.8 0.0029   NR XP_055511116.1 7782 g6811 i0 40.9 4.09090909090909 66 39 81.8 0 202 5 189 254 XP_055511116.1 uncharacterized protein LOC129709027 [Leucoraja erinaceus] diamond 990 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Rajiformes Rajidae Leucoraja Leucoraja erinaceus
32783547 32783547 PRJEB65099_P_NODE_4820_length_254_cov_1.723757_g4715_i0 PRJEB65099 4820 254 1.723757 4.37834278 Daphnia magna 35525 Arthropoda Arthropoda 40.4 0.0427   NR KZR97555.1 35525 g4715 i0 73.9 0.271653543307087 23 6 27.2 0 220 152 2 24 KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna] diamond 69 40.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
32815127 32815127 PRJEB65099_P_NODE_4120_length_276_cov_0.802956_g4015_i0 PRJEB65099 4120 276 0.802956 2.2161585600000002 Meloidogyne enterolobii 390850 Nematoda Nematoda 179 2.03e-54   NR CAD2146809.1 390850 g4015 i0 100 1.97826086956522 91 0 98.9 0 275 3 162 252 CAD2146809.1 unnamed protein product [Meloidogyne enterolobii] diamond 546 179 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Meloidogynidae Meloidogyne Meloidogyne enterolobii

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