RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1087264" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1087264 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
194048 194048 PRJNA1087264_P_NODE_19181_length_163_cov_0.894737_g19099_i0 PRJNA1087264 19181 163 0.894737 1.45842131 Thaumatomonas seravini 188939 SAR_Eukaryotes SAR_Eukaryotes 176 7.73e-40   NTclustered gi|160337323|gb|EF455755.1| 188939 g19099 i0 87.919 74.4233128834356 149 18 91 0 3 151 714 566 Thaumatomonas seravini actin gene, partial cds blastn 12131 176 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas seravini
194132 194132 PRJNA1087264_P_NODE_741_length_774_cov_2.579310_g672_i0 PRJNA1087264 741 774 2.57931 19.9638594 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 998 0   NTclustered gi|300676732|gb|GQ377662.1| 188950 g672 i0 91.46 85.7351421188631 726 62 94 0 1 726 121 846 Bodomorpha minima alpha-tubulin (Atub) gene, partial cds blastn 66359 998 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
20595112 20595112 PRJNA1087264_P_NODE_20017_length_162_cov_1.353982_g19935_i0 PRJNA1087264 20017 162 1.353982 2.19345084 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 185 1.2699999999999999e-42   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g19935 i0 88.272 41.9691358024691 162 9 100 4 1 162 3914 3763 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 6799 185 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
23146251 23146251 PRJNA1087264_P_NODE_219_length_1317_cov_1.686120_g183_i0 PRJNA1087264 219 1317 1.68612 22.2062004 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 1090 0   NTclustered gi|302026154|gb|GQ377660.1| 188950 g183 i0 88.69 77.3310554290053 893 101 68 0 325 1217 893 1 Bodomorpha minima beta-tubulin (Btub) gene, partial cds blastn 101845 1090 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24419906 24419906 PRJNA1087264_P_NODE_4820_length_294_cov_1.457143_g4738_i0 PRJNA1087264 4820 294 1.457143 4.28400042 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 427 3.88e-115   NTclustered gi|238617605|gb|FJ973380.1| 45107 g4738 i0 92.905 78.0986394557823 296 18 100 3 1 294 2507 2213 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 22961 427 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);;