RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB14803" and tax_phylum = "Bryozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bryozoa · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14803 · 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
2571344 2571344 PRJEB14803_P_NODE_31743_length_191_cov_1.365385_g31277_i0 PRJEB14803 31743 191 1.365385 2.60788535 Metazoa 33208 Bryozoa other_Eukaryota 71.2 1.65e-12   NR KAF6024678.1 10212 g31277 i0 55.2 9.91099476439791 58 26 91.1 0 185 12 103 160 KAF6024678.1 MAP3K20 [Bugula neritina] diamond 1893 71.2 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
9913988 9913988 PRJEB14803_P_NODE_43148_length_158_cov_1.626016_g42682_i0 PRJEB14803 43148 158 1.626016 2.56910528 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.5 9.98e-18   NR KAF6028072.1 10212 g42682 i0 74.5 18.4746835443038 51 13 96.8 0 155 3 68 118 KAF6028072.1 ABCC5 [Bugula neritina] diamond 2919 85.9 0.9953434225844 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
26589623 26589623 PRJEB14803_P_NODE_29461_length_200_cov_1.454545_g28995_i0 PRJEB14803 29461 200 1.454545 2.90909 Bugula neritina 10212 Bryozoa other_Eukaryota 82 2.28e-17   NR KAF6017493.1 10212 g28995 i0 56.1 0.99 66 29 99 0 198 1 1 66 KAF6017493.1 COMMD4 [Bugula neritina] diamond 198 82 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
26646576 26646576 PRJEB14803_P_NODE_16881_length_289_cov_4.795276_g16415_i0 PRJEB14803 16881 289 4.795276 13.85834764 Opisthokonta 33154 Bryozoa other_Eukaryota 137 7.56e-38   NR KAF6026194.1 10212 g16415 i0 80.8 25.121107266436 78 15 81 0 54 287 1 78 KAF6026194.1 PSMA6 [Bugula neritina] diamond 7260 137 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
26811610 26811610 PRJEB14803_P_NODE_25941_length_217_cov_1.868132_g25475_i0 PRJEB14803 25941 217 1.868132 4.05384644 Watersipora subatra 2589382 Bryozoa other_Eukaryota 95.9 4.6e-23   NR XP_067928744.1 2589382 g25475 i0 62.3 5.7926267281106 69 26 95.4 0 6 212 25 93 XP_067928744.1 small ribosomal subunit protein eS10-like [Watersipora subatra] diamond 1257 95.9 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
27437811 27437811 PRJEB14803_P_NODE_34203_length_182_cov_1.768707_g33737_i0 PRJEB14803 34203 182 1.768707 3.21904674 Metazoa 33208 Bryozoa other_Eukaryota 43.9 0.00496   NR XP_067937049.1 2589382 g33737 i0 40.4 4.68131868131868 47 26 77.5 1 37 177 36 80 XP_067937049.1 probable splicing factor, arginine/serine-rich 6 [Watersipora subatra] diamond 852 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
27500852 27500852 PRJEB14803_P_NODE_23643_length_231_cov_1.954082_g23177_i0 PRJEB14803 23643 231 1.954082 4.51392942 Metazoa 33208 Bryozoa other_Eukaryota 59.7 3.41e-8   NR KAF6034152.1 10212 g23177 i0 37.2 7.32467532467532 78 45 96.1 2 222 1 425 502 KAF6034152.1 FAF1 [Bugula neritina] diamond 1692 59.7 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
27563562 27563562 PRJEB14803_P_NODE_25444_length_220_cov_1.691892_g24978_i0 PRJEB14803 25444 220 1.691892 3.7221624 Metazoa 33208 Bryozoa other_Eukaryota 46.2 1.5e-4   NR KAF6020980.1 10212 g24978 i0 47.4 4.24090909090909 38 20 51.8 0 26 139 27 64 KAF6020980.1 hypothetical protein EB796_020627 [Bugula neritina] diamond 933 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
28511099 28511099 PRJEB14803_P_NODE_41987_length_161_cov_1.222222_g41521_i0 PRJEB14803 41987 161 1.222222 1.96777742 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.9 2.36e-8   NR KAF6020554.1 10212 g41521 i0 50 2.72049689440994 46 23 85.7 0 2 139 9 54 KAF6020554.1 XDH [Bugula neritina] diamond 438 58.9 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
28580719 28580719 PRJEB14803_P_NODE_27587_length_209_cov_1.126437_g27121_i0 PRJEB14803 27587 209 1.126437 2.35425333 Bugula neritina 10212 Bryozoa other_Eukaryota 62.4 2.75e-9   NR KAF6017088.1 10212 g27121 i0 43.3 0.961722488038278 67 38 96.2 0 6 206 101 167 KAF6017088.1 LTV1 [Bugula neritina] diamond 201 62.4 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
29243744 29243744 PRJEB14803_P_NODE_47489_length_150_cov_1.304348_g47023_i0 PRJEB14803 47489 150 1.304348 1.956522 Watersipora subatra 2589382 Bryozoa other_Eukaryota 47 3.41e-4   NR XP_067935708.1 2589382 g47023 i0 42 1 50 28 98 1 147 1 145 194 XP_067935708.1 uncharacterized protein [Watersipora subatra] diamond 150 47 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
29306729 29306729 PRJEB14803_P_NODE_22389_length_240_cov_1.726829_g21923_i0 PRJEB14803 22389 240 1.726829 4.1443896 Watersipora subatra 2589382 Bryozoa other_Eukaryota 73.2 6.83e-13   NR XP_067932472.1 2589382 g21923 i0 51.3 0.975 78 38 97.5 0 239 6 899 976 XP_067932472.1 ATP-dependent translocase ABCB1-like [Watersipora subatra] diamond 234 73.2 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
30374722 30374722 PRJEB14803_P_NODE_46972_length_151_cov_1.258621_g46506_i0 PRJEB14803 46972 151 1.258621 1.90051771 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.8 2.53e-7   NR KAF6041169.1 10212 g46506 i0 64.3 15.8344370860927 42 15 83.4 0 2 127 389 430 KAF6041169.1 MVP [Bugula neritina] diamond 2391 56.2 0.99288256227758 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
30791420 30791420 PRJEB14803_P_NODE_44254_length_156_cov_1.322314_g43788_i0 PRJEB14803 44254 156 1.322314 2.06280984 Bugula neritina 10212 Bryozoa other_Eukaryota 42.7 0.0114   NR KAF6029276.1 10212 g43788 i0 45.7 0.884615384615385 46 23 84.6 1 15 146 318 363 KAF6029276.1 FLII [Bugula neritina] diamond 138 42.7 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
30981218 30981218 PRJEB14803_P_NODE_9694_length_416_cov_2.808399_g9230_i0 PRJEB14803 9694 416 2.808399 11.68293984 Watersipora subatra 2589382 Bryozoa other_Eukaryota 116 4.97e-27   NR XP_067937856.1 2589382 g9230 i0 45.8 1.02403846153846 142 71 98.1 2 5 412 826 967 XP_067937856.1 alanine--tRNA ligase, cytoplasmic-like [Watersipora subatra] diamond 426 116 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra
31992894 31992894 PRJEB14803_P_NODE_22878_length_236_cov_1.791045_g22412_i0 PRJEB14803 22878 236 1.791045 4.2268662 Bugula neritina 10212 Bryozoa other_Eukaryota 113 8.77e-31   NR KAF6032788.1 10212 g22412 i0 73.7 1.93220338983051 76 20 96.6 0 233 6 4 79 KAF6032788.1 RPL32 [Bugula neritina] diamond 456 113 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Bugulidae Bugula Bugula neritina
32656584 32656584 PRJEB14803_P_NODE_22000_length_243_cov_1.346154_g21534_i0 PRJEB14803 22000 243 1.346154 3.27115422 Watersipora subatra 2589382 Bryozoa other_Eukaryota 68.9 2.17e-11   NR XP_067949714.1 2589382 g21534 i0 42 0.851851851851852 69 39 84 1 2 205 411 479 XP_067949714.1 transient receptor potential cation channel subfamily V member 5-like [Watersipora subatra] diamond 207 68.9 1 Eukaryota Opisthokonta Metazoa Bryozoa Gymnolaemata Cheilostomatida Watersiporidae Watersipora Watersipora subatra

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