RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA312615" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA312615 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_kingdom 0

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
6755465 6755465 PRJNA312615_P_NODE_15046_length_317_cov_1.082090_g14895_i0 PRJNA312615 15046 317 1.08209 3.4302253 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 518 2.44e-142   NTclustered gi|238617605|gb|FJ973380.1| 45107 g14895 i0 95.963 100.274447949527 322 8 100 4 1 317 2511 2190 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 31787 518 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
16366333 16366333 PRJNA312615_P_NODE_29573_length_225_cov_1.159091_g29422_i0 PRJNA312615 29573 225 1.159091 2.60795475 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 412 7.97e-111   NTclustered gi|219524795|gb|EU709158.1| 563759 g29422 i0 99.556 98.3288888888889 225 1 100 0 1 225 781 557 Cercozoa sp. Panama112 18S ribosomal RNA gene, partial sequence blastn 22124 416 0.990384615384615 Eukaryota Sar   Cercozoa         Cercozoa sp. Panama112
18229623 18229623 PRJNA312615_P_NODE_19715_length_274_cov_1.986667_g19564_i0 PRJNA312615 19715 274 1.986667 5.44346758 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 230 1.0799999999999998e-55   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g19564 i0 82.31 28.5 277 38 100 9 1 274 3994 3726 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 7809 230 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
18229708 18229708 PRJNA312615_P_NODE_22995_length_254_cov_1.863415_g22844_i0 PRJNA312615 22995 254 1.863415 4.7330741 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 291 4.489999999999999e-74   NTclustered gi|301014702|gb|GQ377715.1| 323453 g22844 i0 89.316 38.5551181102362 234 21 91 4 22 253 40 271 Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds blastn 9793 291 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
19504332 19504332 PRJNA312615_P_NODE_39356_length_195_cov_2.465753_g39205_i0 PRJNA312615 39356 195 2.465753 4.80821835 Cercozoa sp. Panama112 563759 SAR_Eukaryotes SAR_Eukaryotes 361 2.46e-95   NTclustered gi|219524795|gb|EU709158.1| 563759 g39205 i0 100 100.005128205128 195 0 100 0 1 195 1569 1375 Cercozoa sp. Panama112 18S ribosomal RNA gene, partial sequence blastn 19501 361 1 Eukaryota Sar   Cercozoa         Cercozoa sp. Panama112
20190178 20190178 PRJNA312615_P_NODE_48556_length_172_cov_1.585366_g48405_i0 PRJNA312615 48556 172 1.585366 2.72682952 Imbricatea 1736114 SAR_Eukaryotes SAR_Eukaryotes 263 6.12e-66   NTclustered gi|238617605|gb|FJ973380.1| 45107 g48405 i0 94.186 88.8546511627907 172 10 100 0 1 172 1471 1642 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 15283 263 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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