RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1255065" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1255065 · 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
2328972 2328972 PRJNA1255065_P_NODE_98562_length_175_cov_6.992063_g96334_i0 PRJNA1255065 98562 175 6.992063 12.23611025 Macrostomum 39217 Platyhelminthes Platyhelminthes 324 2.83e-84   NTclustered gi|926460157|gb|KR132223.1| 282301 g96334 i0 100 94.4914285714286 175 0 100 0 1 175 4998 5172 Macrostomum lignano clone c100550_g1_i1 mRNA sequence blastn 16536 324 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
3603833 3603833 PRJNA1255065_P_NODE_54323_length_268_cov_5.452055_g52095_i0 PRJNA1255065 54323 268 5.452055 14.6115074 Macrostomum 39217 Platyhelminthes Platyhelminthes 496 9.429999999999999e-136   NTclustered gi|1063887689|gb|KX769148.1| 1892733 g52095 i0 100 100.190298507463 268 0 100 0 1 268 784 517 Macrostomum chongqingensis clone CQ18s1 18S ribosomal RNA gene, partial sequence blastn 26851 496 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum chongqingensis
4187410 4187410 PRJNA1255065_P_NODE_36064_length_390_cov_1.472141_g33843_i0 PRJNA1255065 36064 390 1.472141 5.7413499 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 669 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g33843 i0 97.692 47.8307692307692 390 8 100 1 1 390 8952 8564 Stenostomum sthenum mitochondrion, complete genome blastn 18654 669 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
13114205 13114205 PRJNA1255065_P_NODE_37851_length_372_cov_11.269350_g35630_i0 PRJNA1255065 37851 372 11.26935 41.921982 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 612 1.2899999999999999e-170   NTclustered gi|926460157|gb|KR132223.1| 282301 g35630 i0 96.496 65.5295698924731 371 12 99 1 1 371 163 532 Macrostomum lignano clone c100550_g1_i1 mRNA sequence blastn 24377 612 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
15663301 15663301 PRJNA1255065_P_NODE_51533_length_281_cov_9.232759_g49307_i0 PRJNA1255065 51533 281 9.232759 25.94405279 Macrostomum sinensis 1964814 Platyhelminthes Platyhelminthes 520 5.909999999999999e-143   NTclustered gi|1152728271|gb|KY579355.1| 1964814 g49307 i0 100 99.0071174377224 281 0 100 0 1 281 6 286 Macrostomum sinensis voucher ZGDK2 18S ribosomal RNA gene, partial sequence blastn 27821 520 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum sinensis
16355886 16355886 PRJNA1255065_P_NODE_73873_length_211_cov_2.351852_g71645_i0 PRJNA1255065 73873 211 2.351852 4.96240772 Macrostomum 39217 Platyhelminthes Platyhelminthes 329 7.65e-86   NTclustered gi|588313885|gb|KC869843.1| 1468207 g71645 i0 94.811 101.919431279621 212 10 100 1 1 211 2671 2882 Macrostomum sp. CEL-2014 28S ribosomal RNA gene, partial sequence blastn 21505 331 0.993957703927492 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum sp. CEL-2014
20762207 20762207 PRJNA1255065_P_NODE_88697_length_188_cov_1.115108_g86469_i0 PRJNA1255065 88697 188 1.115108 2.09640304 Macrostomum hystrix 683711 Platyhelminthes Platyhelminthes 141 3.34e-29   NTclustered gi|848094765|gb|KP730477.1| 683711 g86469 i0 80.749 8.22340425531915 187 31 98 5 5 188 391 207 Macrostomum hystrix voucher MTP LS 68 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 1546 141 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum hystrix
21455256 21455256 PRJNA1255065_P_NODE_60957_length_243_cov_7.768041_g58729_i0 PRJNA1255065 60957 243 7.768041 18.87633963 Macrostomum 39217 Platyhelminthes Platyhelminthes 449 6.65e-122   NTclustered gi|1837893399|gb|MT428900.1| 2614291 g58729 i0 100 99.9341563786008 243 0 100 0 1 243 260 18 Macrostomum baoanense voucher MTP_LS_3531 large subunit ribosomal RNA gene, partial sequence blastn 24284 449 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum baoanense
22037349 22037349 PRJNA1255065_P_NODE_85938_length_191_cov_2.197183_g83710_i0 PRJNA1255065 85938 191 2.197183 4.19661953 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 326 8.77e-85   NTclustered gi|926460157|gb|KR132223.1| 282301 g83710 i0 97.382 67.8952879581152 191 5 100 0 1 191 4582 4772 Macrostomum lignano clone c100550_g1_i1 mRNA sequence blastn 12968 326 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
22730185 22730185 PRJNA1255065_P_NODE_49098_length_294_cov_12.624490_g46872_i0 PRJNA1255065 49098 294 12.62449 37.1160006 Macrostomidae 39216 Platyhelminthes Platyhelminthes 544 3.69e-150   NTclustered gi|1837893421|gb|MT428922.1| 683709 g46872 i0 100 99.9931972789116 294 0 100 0 1 294 787 1080 Macrostomum finlandense voucher MTP_LS_3448 large subunit ribosomal RNA gene, partial sequence blastn 29398 544 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum finlandense
23312759 23312759 PRJNA1255065_P_NODE_75359_length_208_cov_27.842767_g73131_i0 PRJNA1255065 75359 208 27.842767 57.91295536 Macrostomum sp. CEL-2014 1468207 Platyhelminthes Platyhelminthes 311 2.7200000000000003e-80   NTclustered gi|588313885|gb|KC869843.1| 1468207 g73131 i0 93.75 30.1009615384615 208 12 100 1 1 208 2394 2188 Macrostomum sp. CEL-2014 28S ribosomal RNA gene, partial sequence blastn 6261 311 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum sp. CEL-2014
24587010 24587010 PRJNA1255065_P_NODE_92700_length_182_cov_2.796992_g90472_i0 PRJNA1255065 92700 182 2.796992 5.09052544 Macrostomum zhaoqingensis 1892734 Platyhelminthes Platyhelminthes 335 1.3699999999999997e-87   NTclustered gi|1063887697|gb|KX769156.1| 1892734 g90472 i0 100 99.7692307692308 181 0 99 0 2 182 520 340 Macrostomum zhaoqingensis clone ZQ28s4 28S ribosomal RNA gene, partial sequence blastn 18158 335 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum zhaoqingensis
27390065 27390065 PRJNA1255065_P_NODE_109543_length_169_cov_0.866667_g107315_i0 PRJNA1255065 109543 169 0.866667 1.46466723 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 45.4 0.00154   NR PAA57464.1 282301 g107315 i0 90.5 0.372781065088757 21 2 37.3 0 168 106 115 135 PAA57464.1 hypothetical protein BOX15_Mlig025138g2 [Macrostomum lignano] diamond 63 45.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28147814 28147814 PRJNA1255065_P_NODE_144465_length_163_cov_0.912281_g142237_i0 PRJNA1255065 144465 163 0.912281 1.48701803 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 60.1 9.64e-9   NR PAA88228.1 282301 g142237 i0 59.3 1.69325153374233 54 19 99.4 1 1 162 436 486 PAA88228.1 hypothetical protein BOX15_Mlig021765g1 [Macrostomum lignano] diamond 276 60.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
28400263 28400263 PRJNA1255065_P_NODE_144426_length_163_cov_0.912281_g142198_i0 PRJNA1255065 144426 163 0.912281 1.48701803 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 52 1.29e-6   NR XP_024345032.1 6210 g142198 i0 73 0.680981595092024 37 10 68.1 0 51 161 84 120 XP_024345032.1 hypothetical protein EGR_11314 [Echinococcus granulosus] diamond 111 52 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus
29189760 29189760 PRJNA1255065_P_NODE_114269_length_168_cov_0.873950_g112041_i0 PRJNA1255065 114269 168 0.87395 1.468236 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 50.8 1.87e-5   NR PAA57971.1 282301 g112041 i0 66.7 1.76785714285714 33 11 58.9 0 3 101 1769 1801 PAA57971.1 hypothetical protein BOX15_Mlig026265g1 [Macrostomum lignano] diamond 297 50.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
29947486 29947486 PRJNA1255065_P_NODE_115331_length_168_cov_0.873950_g113103_i0 PRJNA1255065 115331 168 0.87395 1.468236 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 107 2.9200000000000003e-26   NR PAA94567.1 282301 g113103 i0 85.5 0.982142857142857 55 8 98.2 0 166 2 65 119 PAA94567.1 hypothetical protein BOX15_Mlig029059g1 [Macrostomum lignano] diamond 165 107 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano

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