RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB673" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB673 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
134981 134981 PRJEB673_P_NODE_9861_length_185_cov_2.153333_g9512_i0 PRJEB673 9861 185 2.153333 3.98366605 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 309 8.49e-80   NTclustered gi|238617602|gb|FJ973377.1| 188950 g9512 i0 96.757 99.4486486486486 185 6 100 0 1 185 1314 1498 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 18398 309 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
10337927 10337927 PRJEB673_P_NODE_12689_length_152_cov_1.350427_g12340_i0 PRJEB673 12689 152 1.350427 2.05264904 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 172 9.14e-39   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g12340 i0 87.919 47.8815789473684 149 14 97 4 1 147 3742 3888 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 7278 172 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
11613381 11613381 PRJEB673_P_NODE_12630_length_152_cov_1.709402_g12281_i0 PRJEB673 12630 152 1.709402 2.59829104 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 265 1.47e-66   NTclustered gi|238617605|gb|FJ973380.1| 45107 g12281 i0 98.026 100.960526315789 152 3 100 0 1 152 1188 1037 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 15346 265 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
14163341 14163341 PRJEB673_P_NODE_8032_length_299_cov_1.803030_g7683_i0 PRJEB673 8032 299 1.80303 5.3910597 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 156 2.06e-33   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g7683 i0 79.237 4.45150501672241 236 39 78 9 1 232 2607 2836 Rosculus vulgaris isolate CCA sequence blastn 1331 156 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
15437392 15437392 PRJEB673_P_NODE_2773_length_596_cov_1.541889_g2470_i0 PRJEB673 2773 596 1.541889 9.18965844 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 604 3.609999999999999e-168   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g2470 i0 99.697 10.7080536912752 330 1 91 0 267 596 830 501 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 6382 604 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
20535878 20535878 PRJEB673_P_NODE_9217_length_206_cov_1.385965_g8868_i0 PRJEB673 9217 206 1.385965 2.8550879 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 244 2.7699999999999997e-60   NTclustered gi|1315527746|gb|MF034898.1| 2065209 g8868 i0 88.235 96.9611650485437 204 24 99 0 1 204 805 1008 Phytocercomonas venanatans actin gene, complete cds blastn 19974 244 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
21811649 21811649 PRJEB673_P_NODE_12798_length_151_cov_1.724138_g12449_i0 PRJEB673 12798 151 1.724138 2.60344838 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 261 1.88e-65   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g12449 i0 98.013 8.08609271523179 151 1 100 1 1 151 1342 1194 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 1221 261 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi

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