RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA448207" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA448207 · 7 ✖

analysis 1

  • blastn · 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
438558 438558 PRJNA448207_P_NODE_14841_length_330_cov_1.198444_g14678_i0 PRJNA448207 14841 330 1.198444 3.9548652 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 333 9.909999999999998e-87   NTclustered gi|1373861866|ref|XM_024497310.1| 6210 g14678 i0 99.454 0.927272727272727 183 1 55 0 1 183 150 332 Echinococcus granulosus hypothetical protein (EGR_08061), partial mRNA blastn 306 333 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
4265797 4265797 PRJNA448207_P_NODE_27244_length_249_cov_0.875000_g27081_i0 PRJNA448207 27244 249 0.875 2.17875 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 353 5.52e-93   NTclustered gi|1373859962|ref|XM_024496358.1| 6210 g27081 i0 100 1.14859437751004 191 0 100 0 1 191 5880 5690 Echinococcus granulosus Ras-specific guanine nucleotide-releasing factor (EGR_07109), partial mRNA blastn 286 353 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
4920650 4920650 PRJNA448207_S_NODE_1204_length_390_cov_1.000000_g1193_i0 PRJNA448207 1204 390 1 3.9 Metazoa 33208 Platyhelminthes Platyhelminthes 58.4 8.01e-4   NTclustered gi|690513916|emb|LN064537.1| 99802 g1193 i0 100 6.88717948717949 31 0 8 0 189 219 1880 1910 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0002114 blastn 2686 58.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
9366862 9366862 PRJNA448207_P_NODE_7108_length_456_cov_1.151436_g6946_i0 PRJNA448207 7108 456 1.151436 5.25054816 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 52.8 0.044   NTclustered gi|687163270|emb|LN038880.1| 99802 g6946 i0 100 0.0614035087719298 28 0 6 0 327 354 741 768 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0037985 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
10642581 10642581 PRJNA448207_P_NODE_23909_length_260_cov_1.577540_g23746_i0 PRJNA448207 23909 260 1.57754 4.101604 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 327 3.52e-85   NTclustered gi|1373845992|ref|XM_024489373.1| 6210 g23746 i0 100 1.00384615384615 177 0 100 0 84 260 1044 868 Echinococcus granulosus tRNA-specific adenosine deaminase-like protein (EGR_00124), partial mRNA blastn 261 327 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
17016138 17016138 PRJNA448207_P_NODE_30274_length_245_cov_0.895349_g30111_i0 PRJNA448207 30274 245 0.895349 2.19360505 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 211 3.45e-50   NTclustered gi|1373848276|ref|XM_024490515.1| 6210 g30111 i0 99.145 0.477551020408163 117 1 48 0 129 245 2103 1987 Echinococcus granulosus Splicing factor, arginine/serine-rich (EGR_01266), partial mRNA blastn 117 211 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
19564435 19564435 PRJNA448207_P_NODE_19796_length_289_cov_1.185185_g19633_i0 PRJNA448207 19796 289 1.185185 3.42518465 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 207 5.3900000000000004e-49   NTclustered gi|1373864244|ref|XM_024498499.1| 6210 g19633 i0 91.447 40.757785467128 152 12 52 1 15 165 665 816 Echinococcus granulosus hypothetical protein (EGR_09250), partial mRNA blastn 11779 207 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus

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