RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB55250 · 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
10324833 10324833 PRJEB55250_P_NODE_3149_length_376_cov_1.118812_g3025_i0 PRJEB55250 3149 376 1.118812 4.20673312 Trombidiformes 83136 Arthropoda Arthropoda 166 7.34e-49   NR RWS10781.1 1965070 g3025 i0 66.9 1.98670212765957 124 41 98.9 0 4 375 38 161 RWS10781.1 ribosomal protein-like protein, partial [Dinothrombium tinctorium] diamond 747 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
27532371 27532371 PRJEB55250_P_NODE_13603_length_247_cov_0.885057_g13479_i0 PRJEB55250 13603 247 0.885057 2.18609079 Insecta 50557 Arthropoda Arthropoda 69.3 1.11e-11   NR KAL4717768.1 72366 g13479 i0 48.6 9.68016194331984 72 37 87.4 0 26 241 20 91 KAL4717768.1 hypothetical protein ACJJTC_000917 [Scirpophaga incertulas] diamond 2391 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Scirpophaga Scirpophaga incertulas
27728953 27728953 PRJEB55250_P_NODE_11684_length_251_cov_0.865169_g11560_i0 PRJEB55250 11684 251 0.865169 2.17157419 Schistocerca gregaria 7010 Arthropoda Arthropoda 45.4 0.00452   NR XP_049849277.1 7010 g11560 i0 47.8 0.549800796812749 46 22 52.6 1 136 5 30 75 XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] diamond 138 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28044290 28044290 PRJEB55250_P_NODE_12165_length_250_cov_0.870056_g12041_i0 PRJEB55250 12165 250 0.870056 2.17514 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 97.4 2.3700000000000003e-21   NR GLV38013.1 49296 g12041 i0 63 0.972 81 30 97.2 0 244 2 647 727 GLV38013.1 uncharacterized protein CBL_07811 [Carabus blaptoides fortunei] diamond 243 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
28233474 28233474 PRJEB55250_P_NODE_13546_length_247_cov_0.885057_g13422_i0 PRJEB55250 13546 247 0.885057 2.18609079 Meladema coriacea 107907 Arthropoda Arthropoda 132 8.83e-38   NR CAJ17403.1 107907 g13422 i0 91.3 1.7004048582996 69 6 83.8 0 209 3 1 69 CAJ17403.1 ribosomal protein L28e [Meladema coriacea] diamond 420 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Dytiscidae Meladema Meladema coriacea
28644373 28644373 PRJEB55250_P_NODE_14647_length_245_cov_0.895349_g14523_i0 PRJEB55250 14647 245 0.895349 2.19360505 Schistocerca gregaria 7010 Arthropoda Arthropoda 56.6 4.92e-7   NR XP_049848239.1 7010 g14523 i0 31 0.869387755102041 71 49 86.9 0 1 213 482 552 XP_049848239.1 uncharacterized protein LOC126313330 [Schistocerca gregaria] diamond 213 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29401997 29401997 PRJEB55250_P_NODE_8089_length_276_cov_0.960591_g7965_i0 PRJEB55250 8089 276 0.960591 2.65123116 Exocentrus adspersus 1586481 Arthropoda Arthropoda 91.7 2.6e-19   NR KAJ8924928.1 1586481 g7965 i0 49.4 2.83695652173913 89 45 96.7 0 275 9 331 419 KAJ8924928.1 hypothetical protein NQ315_001091 [Exocentrus adspersus] diamond 783 91.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Exocentrus Exocentrus adspersus
29559730 29559730 PRJEB55250_P_NODE_6290_length_290_cov_1.327189_g6166_i0 PRJEB55250 6290 290 1.327189 3.8488481 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 43.5 0.00514   NR XP_015910180.1 114398 g6166 i0 37.7 0.631034482758621 61 36 63.1 1 2 184 16 74 XP_015910180.1 cytochrome b-c1 complex subunit 8 [Parasteatoda tepidariorum] diamond 183 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
29963704 29963704 PRJEB55250_P_NODE_6471_length_288_cov_1.879070_g6347_i0 PRJEB55250 6471 288 1.87907 5.4117216 Arachnida 6854 Arthropoda Arthropoda 131 5.48e-34   NR XP_015789961.1 32264 g6347 i0 62.8 7.16666666666667 94 35 97.9 0 7 288 30 123 XP_015789961.1 probable medium-chain specific acyl-CoA dehydrogenase, mitochondrial isoform X2 [Tetranychus urticae] diamond 2064 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
30539080 30539080 PRJEB55250_P_NODE_15593_length_243_cov_0.905882_g15469_i0 PRJEB55250 15593 243 0.905882 2.20129326 Drosophila bipectinata 42026 Arthropoda Arthropoda 43.5 0.0202   NR XP_017105683.2 42026 g15469 i0 33.3 1.40740740740741 57 38 70.4 0 48 218 226 282 XP_017105683.2 rab3 GTPase-activating protein non-catalytic subunit [Drosophila bipectinata] diamond 342 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila bipectinata
31234057 31234057 PRJEB55250_P_NODE_16515_length_241_cov_0.916667_g16391_i0 PRJEB55250 16515 241 0.916667 2.20916747 Schistocerca gregaria 7010 Arthropoda Arthropoda 87 8.68e-18   NR XP_049849277.1 7010 g16391 i0 51.3 0.995850622406639 80 37 97.1 1 234 1 204 283 XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] diamond 240 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32681896 32681896 PRJEB55250_P_NODE_6000_length_294_cov_1.416290_g5876_i0 PRJEB55250 6000 294 1.41629 4.1638926 Metazoa 33208 Arthropoda Arthropoda 88.6 3.99e-19   NR RXG61010.1 13347 g5876 i0 54.3 3.30612244897959 81 37 82.7 0 244 2 144 224 RXG61010.1 hypothetical protein Avbf_14182 [Armadillidium vulgare] diamond 972 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium vulgare
32846254 32846254 PRJEB55250_P_NODE_14700_length_245_cov_0.895349_g14576_i0 PRJEB55250 14700 245 0.895349 2.19360505 Schistocerca gregaria 7010 Arthropoda Arthropoda 85.5 3.17e-17   NR XP_049849277.1 7010 g14576 i0 52.5 0.979591836734694 80 30 96.7 2 238 2 62 134 XP_049849277.1 uncharacterized protein LOC126318325 [Schistocerca gregaria] diamond 240 85.5 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);;