RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630162 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
27523021 27523021 PRJNA630162_P_NODE_159663_length_162_cov_1.477876_g158140_i0 PRJNA630162 159663 162 1.477876 2.39415912 Owenia fusiformis 6347 Annelida Annelida 43.5 0.00666   NR CAH1780764.1 6347 g158140 i0 53.8 0.722222222222222 39 18 72.2 0 118 2 952 990 CAH1780764.1 unnamed protein product [Owenia fusiformis] diamond 117 43.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
27870275 27870275 PRJNA630162_P_NODE_161085_length_162_cov_0.920354_g159562_i0 PRJNA630162 161085 162 0.920354 1.49097348 Dimorphilus gyrociliatus 2664684 Annelida Annelida 57 1.13e-7   NR CAD5111377.1 2664684 g159562 i0 87.1 3.74074074074074 31 4 57.4 0 65 157 41 71 CAD5111377.1 DgyrCDS693 [Dimorphilus gyrociliatus] diamond 606 57 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
27914515 27914515 PRJNA630162_P_NODE_135045_length_168_cov_1.319328_g133522_i0 PRJNA630162 135045 168 1.319328 2.21647104 root 1 Root_unresolved Root_unresolved 48.1 1.62e-4   NR ELU11326.1 283909 g133522 i0 52.2 3.26785714285714 46 22 82.1 0 163 26 128 173 ELU11326.1 hypothetical protein CAPTEDRAFT_210610 [Capitella teleta] diamond 549 48.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
28028362 28028362 PRJNA630162_P_NODE_155085_length_163_cov_1.526316_g153562_i0 PRJNA630162 155085 163 1.526316 2.48789508 Paralvinella palmiformis 53620 Annelida Annelida 74.7 6.74e-14   NR KAK2163233.1 53620 g153562 i0 58.5 29.2638036809816 53 22 97.5 0 160 2 371 423 KAK2163233.1 hypothetical protein LSH36_83g01069 [Paralvinella palmiformis] diamond 4770 74.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
28501932 28501932 PRJNA630162_P_NODE_149907_length_164_cov_2.339130_g148384_i0 PRJNA630162 149907 164 2.33913 3.8361732 Helobdella robusta 6412 Annelida Annelida 85.9 7.95e-18   NR XP_009022448.1 6412 g148384 i0 68.5 0.98780487804878 54 17 98.8 0 162 1 10 63 XP_009022448.1 hypothetical protein HELRODRAFT_66664 [Helobdella robusta] diamond 162 85.9 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
28817349 28817349 PRJNA630162_P_NODE_40888_length_278_cov_1.803493_g39365_i0 PRJNA630162 40888 278 1.803493 5.01371054 Paralvinella palmiformis 53620 Annelida Annelida 75.5 9.26e-15   NR KAK2152403.1 53620 g39365 i0 49.4 0.852517985611511 79 40 85.3 0 26 262 3 81 KAK2152403.1 hypothetical protein LSH36_330g11062 [Paralvinella palmiformis] diamond 237 75.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
29196631 29196631 PRJNA630162_P_NODE_151229_length_164_cov_1.356522_g149706_i0 PRJNA630162 151229 164 1.356522 2.22469608 Owenia fusiformis 6347 Annelida Annelida 45.1 0.00197   NR CAH1791761.1 6347 g149706 i0 40.4 0.951219512195122 52 28 89.6 1 147 1 168 219 CAH1791761.1 unnamed protein product [Owenia fusiformis] diamond 156 45.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
30649216 30649216 PRJNA630162_P_NODE_48773_length_252_cov_5.985222_g47250_i0 PRJNA630162 48773 252 5.985222 15.08275944 Capitella teleta 283909 Annelida Annelida 50.1 6.75e-6   NR ELT98715.1 283909 g47250 i0 50 1.20238095238095 52 25 60.7 1 4 156 11 62 ELT98715.1 hypothetical protein CAPTEDRAFT_61794, partial [Capitella teleta] diamond 303 50.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
32008940 32008940 PRJNA630162_P_NODE_133638_length_168_cov_2.529412_g132115_i0 PRJNA630162 133638 168 2.529412 4.24941216 Dimorphilus gyrociliatus 2664684 Annelida Annelida 51.2 1.37e-5   NR CAD5118963.1 2664684 g132115 i0 47.6 0.75 42 22 75 0 33 158 1111 1152 CAD5118963.1 DgyrCDS7634 [Dimorphilus gyrociliatus] diamond 126 51.2 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
32306750 32306750 PRJNA630162_P_NODE_66919_length_216_cov_2.443114_g65396_i0 PRJNA630162 66919 216 2.443114 5.27712624 Opisthokonta 33154 Annelida Annelida 45.4 0.00193   NR ELT88620.1 283909 g65396 i0 58.3 4.05555555555556 48 20 66.7 0 3 146 142 189 ELT88620.1 hypothetical protein CAPTEDRAFT_223849 [Capitella teleta] diamond 876 45.8 0.991266375545852 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
32528162 32528162 PRJNA630162_P_NODE_64959_length_219_cov_2.870588_g63436_i0 PRJNA630162 64959 219 2.870588 6.28658772 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 49.7 1.28e-5   NR ADY18367.1 104710 g63436 i0 79.3 2.0958904109589 29 6 39.7 0 131 217 1 29 ADY18367.1 ribosomal protein rps23, partial [Glycera tridactyla] diamond 459 49.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Phyllodocida Glyceridae Glycera Glycera tridactyla
32830390 32830390 PRJNA630162_P_NODE_163880_length_160_cov_2.594595_g162357_i0 PRJNA630162 163880 160 2.594595 4.151352 Capitella teleta 283909 Annelida Annelida 58.9 6.59e-10   NR ELT98715.1 283909 g162357 i0 75 1.2 32 8 60 0 13 108 2 33 ELT98715.1 hypothetical protein CAPTEDRAFT_61794, partial [Capitella teleta] diamond 192 58.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta

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