RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA280983 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
5475058 5475058 PRJNA280983_P_NODE_7985_length_198_cov_1.845638_g7870_i0 PRJNA280983 7985 198 1.845638 3.65436324 Metazoa 33208 Arthropoda Arthropoda 132 4.21e-34   NR AXR98455.1 6728 g7870 i0 96.9 5.90909090909091 65 2 98.5 0 196 2 49 113 AXR98455.1 heat shock protein 70 kDa isoform 2, partial [Procambarus clarkii] diamond 1170 133 0.992481203007519 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
11850281 11850281 PRJNA280983_P_NODE_3850_length_343_cov_1.170068_g3735_i0 PRJNA280983 3850 343 1.170068 4.01333324 Tenebrio molitor 7067 Arthropoda Arthropoda 87 1.86e-18   NR XP_068907020.1 7067 g3735 i0 64.9 0.498542274052478 57 19 49.9 1 114 284 149 204 XP_068907020.1 peritrophin-1-like [Tenebrio molitor] diamond 171 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
26630960 26630960 PRJNA280983_P_NODE_9021_length_179_cov_1.569231_g8906_i0 PRJNA280983 9021 179 1.569231 2.80892349 Eretmocerus hayati 131215 Arthropoda Arthropoda 91.3 4.72e-21   NR KAJ8684826.1 131215 g8906 i0 72.9 2.98324022346369 59 16 98.9 0 179 3 60 118 KAJ8684826.1 hypothetical protein QAD02_020619 [Eretmocerus hayati] diamond 534 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Aphelinidae Eretmocerus Eretmocerus hayati
26789390 26789390 PRJNA280983_P_NODE_3281_length_377_cov_1.554878_g3166_i0 PRJNA280983 3281 377 1.554878 5.86189006 Procambarus clarkii 6728 Arthropoda Arthropoda 232 8.85e-68   NR AYD41603.1 6728 g3166 i0 89.6 0.994694960212202 125 13 99.5 0 377 3 441 565 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 375 232 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
27484928 27484928 PRJNA280983_P_NODE_11143_length_162_cov_0.902655_g11028_i0 PRJNA280983 11143 162 0.902655 1.4623011 Oppia nitens 1686743 Arthropoda Arthropoda 67.4 2.54e-11   NR XP_054154164.1 1686743 g11028 i0 56.4 2 55 22 98.1 1 1 159 246 300 XP_054154164.1 replication protein A 70 kDa DNA-binding subunit-like [Oppia nitens] diamond 324 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
27895254 27895254 PRJNA280983_P_NODE_3645_length_354_cov_1.337705_g3530_i0 PRJNA280983 3645 354 1.337705 4.7354757 Procambarus clarkii 6728 Arthropoda Arthropoda 211 1.62e-60   NR AYD41603.1 6728 g3530 i0 91.5 0.991525423728814 117 10 99.2 0 353 3 1059 1175 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 351 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
28242518 28242518 PRJNA280983_P_NODE_11446_length_161_cov_0.910714_g11331_i0 PRJNA280983 11446 161 0.910714 1.46624954 Drosophila nasuta 42062 Arthropoda Arthropoda 89.4 2.9e-19   NR XP_060649581.1 42062 g11331 i0 76.9 0.968944099378882 52 12 96.9 0 157 2 301 352 XP_060649581.1 uncharacterized protein LOC132786888 [Drosophila nasuta] diamond 156 89.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila nasuta
28432169 28432169 PRJNA280983_P_NODE_2586_length_438_cov_1.519280_g2471_i0 PRJNA280983 2586 438 1.51928 6.6544464 Procambarus clarkii 6728 Arthropoda Arthropoda 256 5.08e-76   NR AYD41603.1 6728 g2471 i0 89 1 146 16 100 0 1 438 242 387 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 438 256 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
28558585 28558585 PRJNA280983_P_NODE_9167_length_176_cov_2.007874_g9052_i0 PRJNA280983 9167 176 2.007874 3.53385824 Procambarus clarkii 6728 Arthropoda Arthropoda 112 6.0700000000000006e-27   NR AYD41603.1 6728 g9052 i0 93.1 0.988636363636364 58 4 98.9 0 2 175 1381 1438 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 174 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
29063735 29063735 PRJNA280983_P_NODE_5508_length_266_cov_1.276498_g5393_i0 PRJNA280983 5508 266 1.276498 3.39548468 Procambarus clarkii 6728 Arthropoda Arthropoda 150 5.109999999999999e-40   NR AYD41603.1 6728 g5393 i0 86.4 0.992481203007519 88 12 99.2 0 3 266 574 661 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 264 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
29095312 29095312 PRJNA280983_P_NODE_4748_length_297_cov_1.149194_g4633_i0 PRJNA280983 4748 297 1.149194 3.41310618 Procambarus clarkii 6728 Arthropoda Arthropoda 166 4.28e-45   NR AYD41603.1 6728 g4633 i0 84.7 0.98989898989899 98 15 99 0 2 295 1167 1264 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 294 166 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
30200267 30200267 PRJNA280983_P_NODE_7692_length_204_cov_1.619355_g7577_i0 PRJNA280983 7692 204 1.619355 3.3034842 Anopheles albimanus 7167 Arthropoda Arthropoda 90.9 1.58e-19   NR XP_035783023.1 7167 g7577 i0 64.6 1.91176470588235 65 23 95.6 0 196 2 264 328 XP_035783023.1 26S proteasome non-ATPase regulatory subunit 11-like [Anopheles albimanus] diamond 390 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
30249998 30249998 PRJNA280983_P_NODE_9272_length_175_cov_0.992063_g9157_i0 PRJNA280983 9272 175 0.992063 1.73611025 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 51.2 7.82e-6   NR XP_014209968.1 29053 g9157 i0 52.2 1.56 46 22 78.9 0 37 174 2 47 XP_014209968.1 60S ribosomal protein L17 [Copidosoma floridanum] diamond 273 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Encyrtidae Copidosoma Copidosoma floridanum
30327391 30327391 PRJNA280983_P_NODE_10952_length_163_cov_0.894737_g10837_i0 PRJNA280983 10952 163 0.894737 1.45842131 Cinara cedri 506608 Arthropoda Arthropoda 41.2 0.0433   NR VVC35859.1 506608 g10837 i0 47.3 1.01226993865031 55 26 97.5 2 161 3 443 496 VVC35859.1 Major facilitator superfamily,Major facilitator superfamily domain,Major facilitator, sugar transporter- [Cinara cedri] diamond 165 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
30390494 30390494 PRJNA280983_P_NODE_6013_length_249_cov_1.275000_g5898_i0 PRJNA280983 6013 249 1.275 3.17475 Procambarus clarkii 6728 Arthropoda Arthropoda 139 6.29e-36   NR AYD41603.1 6728 g5898 i0 80.7 1 83 16 100 0 1 249 155 237 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 249 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
31102684 31102684 PRJNA280983_P_NODE_8015_length_198_cov_1.026846_g7900_i0 PRJNA280983 8015 198 1.026846 2.03315508 Metazoa 33208 Arthropoda Arthropoda 108 1.29e-28   NR NP_001037568.1 7091 g7900 i0 74.6 11.469696969697 63 16 95.5 0 194 6 49 111 NP_001037568.1 ribosomal protein S12 [Bombyx mori] diamond 2271 108 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
31496420 31496420 PRJNA280983_P_NODE_11356_length_161_cov_0.910714_g11241_i0 PRJNA280983 11356 161 0.910714 1.46624954 Stegodyphus dumicola 202533 Arthropoda Arthropoda 65.5 3.76e-11   NR XP_035232678.1 202533 g11241 i0 54.7 2.90683229813665 53 24 98.8 0 1 159 43 95 XP_035232678.1 thioredoxin domain-containing protein 9-like [Stegodyphus dumicola] diamond 468 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
32508867 32508867 PRJNA280983_P_NODE_10139_length_166_cov_0.871795_g10024_i0 PRJNA280983 10139 166 0.871795 1.4471797 Drosophila birchii 46829 Arthropoda Arthropoda 72.8 9.53e-15   NR KAH8249125.1 46829 g10024 i0 62.3 0.957831325301205 53 20 95.8 0 8 166 43 95 KAH8249125.1 hypothetical protein KR032_006264 [Drosophila birchii] diamond 159 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila birchii
32715399 32715399 PRJNA280983_P_NODE_6720_length_229_cov_1.133333_g6605_i0 PRJNA280983 6720 229 1.133333 2.59533257 Insecta 50557 Arthropoda Arthropoda 85.5 1.64e-17   NR CAD7393346.1 61476 g6605 i0 82.2 2.92139737991266 45 8 59 0 228 94 143 187 CAD7393346.1 unnamed protein product [Timema cristinae] diamond 669 86.3 0.990730011587486 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema cristinae
32886516 32886516 PRJNA280983_P_NODE_4260_length_322_cov_1.567766_g4145_i0 PRJNA280983 4260 322 1.567766 5.04820652 Melitaea cinxia 113334 Arthropoda Arthropoda 68.6 8.25e-11   NR XP_045450465.1 113334 g4145 i0 64.1 0.363354037267081 39 14 36.3 0 7 123 143 181 XP_045450465.1 chondroitin proteoglycan 2-like [Melitaea cinxia] diamond 117 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Melitaea Melitaea cinxia

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