RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB50332 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
6497705 6497705 PRJEB50332_P_NODE_4546_length_282_cov_2.162896_g4464_i0 PRJEB50332 4546 282 2.162896 6.09936672 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.5 1.58e-20   NR ELT91123.1 283909 g4464 i0 69.6 4.37234042553191 79 22 81.9 2 282 52 452 530 ELT91123.1 hypothetical protein CAPTEDRAFT_150478 [Capitella teleta] diamond 1233 95.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
19245035 19245035 PRJEB50332_P_NODE_216_length_1076_cov_3.430542_g175_i0 PRJEB50332 216 1076 3.430542 36.91263192 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 276 4.279999999999999e-87   NR AAN28680.1 13286 g175 i0 48.6 3.57156133828996 348 144 88.9 13 1012 56 10 351 AAN28680.1 cathepsin L [Theromyzon tessulatum] diamond 3843 278 0.992805755395683 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Theromyzon Theromyzon tessulatum
27690620 27690620 PRJEB50332_P_NODE_10984_length_219_cov_1.246835_g10902_i0 PRJEB50332 10984 219 1.246835 2.73056865 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.6 3.4e-7   NR ELT89513.1 283909 g10902 i0 60.4 1.91780821917808 48 19 65.8 0 9 152 411 458 ELT89513.1 hypothetical protein CAPTEDRAFT_196397 [Capitella teleta] diamond 420 56.6 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
28233456 28233456 PRJEB50332_P_NODE_9606_length_226_cov_2.357576_g9524_i0 PRJEB50332 9606 226 2.357576 5.32812176 Owenia fusiformis 6347 Annelida Annelida 60.5 1.27e-8   NR CAH1780818.1 6347 g9524 i0 40.4 0.756637168141593 57 34 75.7 0 46 216 7 63 CAH1780818.1 unnamed protein product [Owenia fusiformis] diamond 171 60.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis
29591027 29591027 PRJEB50332_P_NODE_13950_length_208_cov_3.408163_g13868_i0 PRJEB50332 13950 208 3.408163 7.08897904 Capitella teleta 283909 Annelida Annelida 56.2 5.17e-8   NR ELU09549.1 283909 g13868 i0 54.8 0.605769230769231 42 19 60.6 0 128 3 12 53 ELU09549.1 hypothetical protein CAPTEDRAFT_136883 [Capitella teleta] diamond 126 56.2 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Capitellidae Capitella Capitella teleta
30823426 30823426 PRJEB50332_P_NODE_16534_length_204_cov_0.909091_g16452_i0 PRJEB50332 16534 204 0.909091 1.85454564 Dimorphilus gyrociliatus 2664684 Annelida Annelida 45.8 0.00185   NR CAD5120732.1 2664684 g16452 i0 40.8 0.720588235294118 49 27 69.1 1 153 13 37 85 CAD5120732.1 DgyrCDS9293 [Dimorphilus gyrociliatus] diamond 147 45.8 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus
31993326 31993326 PRJEB50332_P_NODE_13378_length_210_cov_0.872483_g13296_i0 PRJEB50332 13378 210 0.872483 1.8322143 Paralvinella palmiformis 53620 Annelida Annelida 98.2 3.16e-22   NR KAK2149874.1 53620 g13296 i0 64.2 3.81428571428571 67 24 95.7 0 9 209 82 148 KAK2149874.1 hypothetical protein LSH36_433g02024 [Paralvinella palmiformis] diamond 801 98.2 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis

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