RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA700095" 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

  • PRJNA700095 · 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
5012473 5012473 PRJNA700095_P_NODE_32224_length_301_cov_0.929825_g30960_i0 PRJNA700095 32224 301 0.929825 2.79877325 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 540 4.899999999999999e-149   NTclustered gi|1837628855|gb|MN158348.1| 5909 g30960 i0 99.003 95.3023255813954 301 3 100 0 1 301 3041 2741 Tetrahymena rostrata strain TRAUS 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 28686 540 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
7061803 7061803 PRJNA700095_P_NODE_39226_length_278_cov_1.200000_g37962_i0 PRJNA700095 39226 278 1.2 3.336 Sathrophilus holtae 692531 SAR_Eukaryotes SAR_Eukaryotes 141 5.310000000000001e-29   NTclustered gi|404425900|gb|JX310029.1| 692531 g37962 i0 76.173 22.0971223021583 277 60 99 6 5 278 1723 1996 Sathrophilus holtae voucher FXP2007102402 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 6143 141 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Cinetochilidae Sathrophilus Sathrophilus holtae
22360553 22360553 PRJNA700095_P_NODE_69298_length_226_cov_2.823529_g68033_i0 PRJNA700095 69298 226 2.823529 6.38117554 Caryotricha sinica 2652903 SAR_Eukaryotes SAR_Eukaryotes 134 6.980000000000001e-27   NTclustered gi|2328859121|gb|OP828526.1| 2652903 g68033 i0 97.436 36.0176991150442 78 2 35 0 1 78 905 982 Caryotricha sinica isolate LCY2018041109 large subunit ribosomal RNA gene, partial sequence blastn 8140 134 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha sinica
22360571 22360571 PRJNA700095_P_NODE_9338_length_640_cov_22.809524_g8122_i0 PRJNA700095 9338 640 22.809524 145.9809536 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1160 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g8122 i0 99.375 90.4703125 640 4 100 0 1 640 997 1636 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 57901 1160 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
22861689 22861689 PRJNA700095_P_NODE_32058_length_301_cov_5.048246_g30794_i0 PRJNA700095 32058 301 5.048246 15.19522046 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 551 2.2699999999999992e-152   NTclustered gi|300078457|gb|GU187051.1| 858371 g30794 i0 100 99.5548172757475 298 0 99 0 1 298 1306 1603 Vorticella sp. SP-2009-4 18S ribosomal RNA gene, partial sequence blastn 29966 556 0.991007194244604 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. SP-2009-4
24135864 24135864 PRJNA700095_P_NODE_12399_length_541_cov_5.241453_g11148_i0 PRJNA700095 12399 541 5.241453 28.35626073 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 1000 0   NTclustered gi|363412159|gb|JN120233.1| 679523 g11148 i0 100 99.9648798521257 541 0 100 0 1 541 997 457 Vorticella gracilis isolate 88vorc2fwhfixgz4S1S2 18S ribosomal RNA gene, partial sequence blastn 54081 1000 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella gracilis

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