RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1009807 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
1429581 1429581 PRJNA1009807_S_NODE_222_length_545_cov_4.519763_g198_i0 PRJNA1009807 222 545 4.519763 24.63270835 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 944 0   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g198 i0 97.989 24.0715596330275 547 5 100 3 1 545 1414 872 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 13119 944 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
5257723 5257723 PRJNA1009807_S_NODE_3305_length_178_cov_3.302158_g3277_i0 PRJNA1009807 3305 178 3.302158 5.87784124 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 329 6.21e-86   NTclustered gi|88792583|gb|DQ386164.1| 372086 g3277 i0 100 97.4438202247191 178 0 100 0 1 178 1773 1950 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 17345 329 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
6532970 6532970 PRJNA1009807_S_NODE_1166_length_282_cov_4.213992_g1138_i0 PRJNA1009807 1166 282 4.213992 11.88345744 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 520 5.93e-143   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g1138 i0 100 6.86879432624113 281 0 99 0 2 282 884 604 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 1937 520 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
11204673 11204673 PRJNA1009807_S_NODE_1489_length_248_cov_8.191388_g1461_i0 PRJNA1009807 1489 248 8.191388 20.31464224 Euglypha 39713 SAR_Eukaryotes SAR_Eukaryotes 453 5.2600000000000005e-123   NTclustered gi|18075905|emb|AJ418782.1| 39714 g1461 i0 99.597 100.004032258065 248 1 100 0 1 248 1009 762 Euglypha rotunda 18S rRNA gene, strain Costa Rica blastn 24801 453 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
12908476 12908476 PRJNA1009807_S_NODE_1211_length_275_cov_3.122881_g1183_i0 PRJNA1009807 1211 275 3.122881 8.58792275 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 180 1.11e-40   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1183 i0 79.57 23.5163636363636 279 35 100 16 1 275 3996 3736 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 6467 180 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
14183483 14183483 PRJNA1009807_S_NODE_592_length_376_cov_8.284866_g564_i0 PRJNA1009807 592 376 8.284866 31.15109616 Verrucomonas longifila 629764 SAR_Eukaryotes SAR_Eukaryotes 204 9.34e-48   NTclustered gi|290760489|gb|GQ144692.1| 629764 g564 i0 81.673 55.7659574468085 251 40 66 6 75 323 1245 1491 Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence blastn 20968 204 1 Eukaryota Sar   Cercozoa Thecofilosea Ventricleftida   Verrucomonas Verrucomonas longifila
15457409 15457409 PRJNA1009807_S_NODE_3393_length_176_cov_2.883212_g3365_i0 PRJNA1009807 3393 176 2.883212 5.07445312 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 305 1.03e-78   NTclustered gi|290760485|gb|GQ144688.1| 741089 g3365 i0 98.276 95.8522727272727 174 3 99 0 3 176 2100 1927 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 16870 305 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
18006534 18006534 PRJNA1009807_S_NODE_1055_length_295_cov_4.347656_g1027_i0 PRJNA1009807 1055 295 4.347656 12.8255852 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 545 1.03e-150   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g1027 i0 100 22.6372881355932 295 0 100 0 1 295 1640 1934 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 6678 545 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
20555988 20555988 PRJNA1009807_S_NODE_3297_length_178_cov_5.143885_g3269_i0 PRJNA1009807 3297 178 5.143885 9.1561153 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 329 6.21e-86   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g3269 i0 100 2.99438202247191 178 0 100 0 1 178 124 301 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 533 329 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
21403506 21403506 PRJNA1009807_S_NODE_4817_length_153_cov_2.789474_g4789_i0 PRJNA1009807 4817 153 2.789474 4.26789522 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 283 4.0799999999999995e-72   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g4789 i0 100 4.94117647058824 153 0 100 0 1 153 440 592 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 756 283 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.

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