RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA902848 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
1247019 1247019 PRJNA902848_P_NODE_20641_length_211_cov_11.427536_g20591_i0 PRJNA902848 20641 211 11.427536 24.11210096 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 390 3.459999999999999e-104   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g20591 i0 100 100.004739336493 211 0 100 0 1 211 1367 1577 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 21101 390 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
5075149 5075149 PRJNA902848_P_NODE_20664_length_200_cov_13.535433_g20614_i0 PRJNA902848 20664 200 13.535433 27.070866 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 370 4.22e-98   NTclustered gi|1802599794|gb|MT001203.1| 41631 g20614 i0 100 100.075 200 0 100 0 1 200 1563 1364 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 20015 370 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
5985500 5985500 PRJNA902848_P_NODE_7925_length_312_cov_9.635983_g7875_i0 PRJNA902848 7925 312 9.635983 30.06426696 Frontonia canadensis 1590099 SAR_Eukaryotes SAR_Eukaryotes 370 7.09e-98   NTclustered gi|742270343|gb|KJ475286.1| 1590099 g7875 i0 88.141 100.173076923077 312 35 100 2 1 312 883 1192 Frontonia canadensis isolate S21L large subunit ribosomal RNA gene, partial sequence blastn 31254 370 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Frontoniidae Frontonia Frontonia canadensis
5985518 5985518 PRJNA902848_P_NODE_8725_length_301_cov_4.350877_g8675_i0 PRJNA902848 8725 301 4.350877 13.09613977 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 444 3.9599999999999996e-120   NTclustered gi|512134943|gb|JX178902.1| 1295638 g8675 i0 93.355 90.6644518272425 301 19 100 1 1 301 1633 1334 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 27290 444 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
7260323 7260323 PRJNA902848_P_NODE_9706_length_288_cov_2.827907_g9656_i0 PRJNA902848 9706 288 2.827907 8.14437216 Conchophthirus curtus 2675438 SAR_Eukaryotes SAR_Eukaryotes 189 1.95e-43   NTclustered gi|2518630383|gb|OR129888.1| 2675438 g9656 i0 80.153 12.2013888888889 262 45 90 7 1 259 1159 902 Conchophthirus curtus isolate HO 30 UC internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 3514 189 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Conchophthiridae Conchophthirus Conchophthirus curtus
14001094 14001094 PRJNA902848_P_NODE_8251_length_308_cov_1.136170_g8201_i0 PRJNA902848 8251 308 1.13617 3.4994036 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 564 2.99e-156   NTclustered gi|363412153|gb|JN120227.1| 60850 g8201 i0 99.675 99.0064935064935 308 1 100 0 1 308 512 819 Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence blastn 30494 564 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
16184874 16184874 PRJNA902848_P_NODE_2993_length_449_cov_8.085106_g2943_i0 PRJNA902848 2993 449 8.085106 36.30212594 Cardiostomatella vermiformis 311390 SAR_Eukaryotes SAR_Eukaryotes 507 7.72e-139   NTclustered gi|404425895|gb|JX310024.1| 311390 g2943 i0 89.021 93.5523385300668 419 33 92 11 1 413 2020 2431 Cardiostomatella vermiformis voucher FXP2007101002 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 42005 507 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Loxocephalidae Cardiostomatella Cardiostomatella vermiformis
20008853 20008853 PRJNA902848_P_NODE_996_length_672_cov_8.966611_g949_i0 PRJNA902848 996 672 8.966611 60.25562592 Frontonia paramagna 1590102 SAR_Eukaryotes SAR_Eukaryotes 518 5.49e-142   NTclustered gi|1908106363|gb|MW031798.1| 1590102 g949 i0 89.423 87.9136904761905 416 37 91 7 223 638 1435 1843 Frontonia paramagna isolate SM2017091201 large subunit ribosomal RNA gene, partial sequence blastn 59078 518 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Frontoniidae Frontonia Frontonia paramagna
20373322 20373322 PRJNA902848_P_NODE_2016_length_518_cov_7.649438_g1967_i0 PRJNA902848 2016 518 7.649438 39.62408884 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 953 0   NTclustered gi|1802599797|gb|MT001206.1| 41631 g1967 i0 100 99.6216216216216 516 0 99 0 1 516 509 1024 Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence blastn 51604 953 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda 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);;