RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1020854 · 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
1435533 1435533 PRJNA1020854_S_NODE_15742_length_292_cov_19.414449_g12978_i0 PRJNA1020854 15742 292 19.414449 56.69019108 uncultured haptorid ciliate 282486 SAR_Eukaryotes SAR_Eukaryotes 429 1.07e-115   NTclustered gi|2006880526|emb|HG995482.1| 282486 g12978 i0 93.174 100.513698630137 293 18 100 2 1 292 726 435 uncultured haptorid ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone 05109c93 blastn 29350 429 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida     uncultured haptorid ciliate
4831418 4831418 PRJNA1020854_S_NODE_37464_length_164_cov_2.540741_g34700_i0 PRJNA1020854 37464 164 2.540741 4.16681524 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 124 2.86e-24   NTclustered gi|126142828|gb|EF070284.1| 5898 g34700 i0 80.488 21.7560975609756 164 30 99 2 2 164 1629 1791 Tetrahymena furgasoni strain GL(amicronucleate) cytochrome oxidase subunit I (cox1) gene, partial cds; mitochondrial blastn 3568 124 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena furgasoni
10363970 10363970 PRJNA1020854_S_NODE_18169_length_263_cov_17.833333_g15405_i0 PRJNA1020854 18169 263 17.833333 46.90166579 Halodinium verrucatum 2448773 SAR_Eukaryotes SAR_Eukaryotes 244 3.69e-60   NTclustered gi|1489895921|dbj|LC424402.1| 2448773 g15405 i0 86.818 56.9087452471483 220 27 83 2 12 230 219 1 Halodinium verrucatum KC36_KC37 gene for 28S ribosomal RNA, partial sequence blastn 14967 244 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida   Halodinium Halodinium verrucatum
13756742 13756742 PRJNA1020854_S_NODE_30531_length_186_cov_18.369427_g27767_i0 PRJNA1020854 30531 186 18.369427 34.16713422 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 300 5.1400000000000004e-77   NTclustered gi|115353907|gb|DQ868347.1| 77619 g27767 i0 99.394 89.1021505376344 165 1 89 0 22 186 610 774 Vorticella microstoma 18S small subunit ribosomal RNA gene, partial sequence blastn 16573 300 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella microstoma
18013168 18013168 PRJNA1020854_S_NODE_7915_length_518_cov_1089.292434_g5269_i0 PRJNA1020854 7915 518 1089.292434 5642.53480812 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 765 0   NTclustered gi|759083562|gb|KM222179.1| 1607889 g5269 i0 98.611 80.6563706563707 432 6 83 0 10 441 432 1 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 41780 765 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
18854959 18854959 PRJNA1020854_S_NODE_27275_length_200_cov_15.625731_g24511_i0 PRJNA1020854 27275 200 15.625731 31.251462 root 1 Root_unresolved Root_unresolved 327 2.58e-85   NTclustered gi|10832|emb|X54512.1| 5911 g24511 i0 100 91.375 177 0 89 0 24 200 8294 8118 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 18275 327 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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