RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJEB12296", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 9 ✖

tax_clade 1

bioproject 1

  • PRJEB12296 · 9 ✖

analysis 1

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
25500840 25500840 PRJEB12296_S_NODE_745_length_397_cov_5295.240331_g714_i0 PRJEB12296 745 397 5295.240331 21022.10411407 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 307 7.350000000000001e-79   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g714 i0 83.381 27.0780856423174 349 40 86 13 35 377 2196 2532 Rosculus vulgaris isolate CCA sequence blastn 10750 307 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
25636718 25636718 PRJEB12296_S_NODE_962_length_368_cov_7368.384384_g930_i0 PRJEB12296 962 368 7368.384384 27115.65453312 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 270 8.869999999999999e-68   NTclustered gi|1315527750|gb|MF034900.1| 2065209 g930 i0 83.279 45.4239130434783 305 40 80 9 73 368 9663 9361 Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 16716 270 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
25772864 25772864 PRJEB12296_S_NODE_7411_length_187_cov_1.598684_g7379_i0 PRJEB12296 7411 187 1.598684 2.98953908 uncultured Euglyphida 765883 SAR_Eukaryotes SAR_Eukaryotes 331 1.84e-86   NTclustered gi|959360502|gb|KT272675.1| 765883 g7379 i0 98.919 97.2566844919786 185 2 99 0 3 187 200 16 Uncultured Euglyphida clone Is1_2 18S ribosomal RNA gene, partial sequence blastn 18187 331 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida     uncultured Euglyphida
25772875 25772875 PRJEB12296_S_NODE_8467_length_180_cov_1.710345_g8435_i0 PRJEB12296 8467 180 1.710345 3.078621 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 150 5.26e-32   NTclustered gi|160337400|gb|EF455798.1| 439948 g8435 i0 81.667 98.0277777777778 180 33 100 0 1 180 775 596 Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds blastn 17645 150 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
25908816 25908816 PRJEB12296_S_NODE_12604_length_164_cov_5.015504_g12572_i0 PRJEB12296 12604 164 5.015504 8.22542656 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 298 1.59e-76   NTclustered gi|88792583|gb|DQ386164.1| 372086 g12572 i0 99.39 101.115853658537 164 1 100 0 1 164 1533 1370 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 16583 298 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
26045095 26045095 PRJEB12296_S_NODE_525_length_445_cov_4.834146_g497_i0 PRJEB12296 525 445 4.834146 21.5119497 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 752 0   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g497 i0 99.756 19.5865168539326 410 1 92 0 34 443 962 1371 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 8716 752 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
26045138 26045138 PRJEB12296_S_NODE_693_length_407_cov_3.526882_g662_i0 PRJEB12296 693 407 3.526882 14.35440974 Verrucomonas longifila 629764 SAR_Eukaryotes SAR_Eukaryotes 204 1.0199999999999999e-47   NTclustered gi|290760489|gb|GQ144692.1| 629764 g662 i0 81.673 51.5184275184275 251 40 61 6 126 374 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
26287249 26287249 PRJEB12296_S_NODE_15062_length_158_cov_2.398374_g15030_i0 PRJEB12296 15062 158 2.398374 3.78943092 Lotharella 74819 SAR_Eukaryotes SAR_Eukaryotes 124 2.73e-24   NTclustered gi|220983373|dbj|AB453009.1| 74820 g15030 i0 85.714 28.8987341772152 119 16 75 1 36 153 3094 2976 Lotharella vacuolata gene for nuclear large subunit ribosomal RNA, partial sequence blastn 4566 124 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella vacuolata
26453114 26453114 PRJEB12296_S_NODE_1552_length_321_cov_13.000000_g1520_i0 PRJEB12296 1552 321 13 41.73 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 590 5.159999999999998e-164   NTclustered gi|262262832|gb|FJ790725.1| 466266 g1520 i0 100 98.7632398753894 319 0 99 0 1 319 383 65 Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence blastn 31703 590 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda

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