RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA688736 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
668241 668241 PRJNA688736_P_NODE_51341_length_234_cov_2.422360_g51056_i0 PRJNA688736 51341 234 2.42236 5.6683224 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 422 1.39e-113   NTclustered gi|759083562|gb|KM222179.1| 1607889 g51056 i0 99.145 99.5470085470085 234 2 100 0 1 234 1677 1444 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 23294 422 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
2452470 2452470 PRJNA688736_P_NODE_17942_length_365_cov_1.691781_g17657_i0 PRJNA688736 17942 365 1.691781 6.17500065 root 1 Root_unresolved Root_unresolved 665 0   NTclustered gi|363412127|gb|JN120201.1| 6026 g17657 i0 99.455 100.550684931507 367 0 100 1 1 365 447 813 Opisthonecta henneguyi isolate 43Opisthonectau1S1S2 18S ribosomal RNA gene, partial sequence blastn 36701 665 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta henneguyi
6281425 6281425 PRJNA688736_P_NODE_29285_length_295_cov_1.783784_g29000_i0 PRJNA688736 29285 295 1.783784 5.2621628 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 540 4.79e-149   NTclustered gi|2651357791|gb|PP174306.1| 41631 g29000 i0 99.661 100.237288135593 295 1 100 0 1 295 2984 2690 Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 29570 540 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
6281538 6281538 PRJNA688736_P_NODE_33425_length_277_cov_3.352941_g33140_i0 PRJNA688736 33425 277 3.352941 9.28764657 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 512 9.73e-141   NTclustered gi|2065561668|gb|MZ540265.1| 44029 g33140 i0 100 99.6028880866426 277 0 100 0 1 277 23 299 Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence blastn 27590 512 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium jenningsi
8830162 8830162 PRJNA688736_P_NODE_19347_length_353_cov_11.435714_g19062_i0 PRJNA688736 19347 353 11.435714 40.36807042 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 652 0   NTclustered gi|1202134875|gb|KY454454.1| 63136 g19062 i0 100 98.9886685552408 353 0 100 0 1 353 8 360 Colpoda steinii 18S ribosomal RNA gene, partial sequence blastn 34943 652 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini
12147493 12147493 PRJNA688736_P_NODE_47730_length_245_cov_0.906977_g47445_i0 PRJNA688736 47730 245 0.906977 2.22209365 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 254 5.65e-63   NTclustered gi|829100487|ref|XM_001007447.3| 312017 g47445 i0 85.306 4.57959183673469 245 36 100 0 1 245 725 481 Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA blastn 1122 254 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
13422031 13422031 PRJNA688736_P_NODE_45531_length_247_cov_0.896552_g45246_i0 PRJNA688736 45531 247 0.896552 2.21448344 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 183 7.59e-42   NTclustered gi|300676719|gb|GQ377693.1| 151077 g45246 i0 82.464 10.1457489878543 211 35 85 2 37 246 420 211 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 2506 183 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
15969970 15969970 PRJNA688736_P_NODE_10213_length_468_cov_1.326582_g9928_i0 PRJNA688736 10213 468 1.326582 6.20840376 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 791 0   NTclustered gi|759083562|gb|KM222179.1| 1607889 g9928 i0 97.222 96.6282051282051 468 12 100 1 1 468 819 353 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 45222 791 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
19794587 19794587 PRJNA688736_P_NODE_26816_length_307_cov_3.324786_g26531_i0 PRJNA688736 26816 307 3.324786 10.20709302 Vorticella sp. 2219883 SAR_Eukaryotes SAR_Eukaryotes 568 2.3e-157   NTclustered gi|2217167749|gb|ON157274.1| 2219883 g26531 i0 100 98.1693811074919 307 0 100 0 1 307 1676 1370 Vorticella sp. isolate BP174 small subunit ribosomal RNA gene, partial sequence blastn 30138 568 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp.
20304302 20304302 PRJNA688736_P_NODE_51696_length_209_cov_5.058824_g51411_i0 PRJNA688736 51696 209 5.058824 10.57294216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 385 1.59e-102   NTclustered gi|1802599794|gb|MT001203.1| 41631 g51411 i0 100 99.6028708133971 208 0 99 0 1 208 1356 1563 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 20817 385 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
21579291 21579291 PRJNA688736_P_NODE_14297_length_403_cov_14.336364_g14012_i0 PRJNA688736 14297 403 14.336364 57.77554692 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 743 0   NTclustered gi|1802599797|gb|MT001206.1| 41631 g14012 i0 100 98.9205955334988 402 0 99 0 1 402 508 909 Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence blastn 39865 743 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
21579762 21579762 PRJNA688736_P_NODE_33117_length_279_cov_1.135922_g32832_i0 PRJNA688736 33117 279 1.135922 3.16922238 Colpodidae 5978 SAR_Eukaryotes SAR_Eukaryotes 459 1.3000000000000002e-124   NTclustered gi|2166921685|gb|OL894853.1| 63136 g32832 i0 96.416 11.2293906810036 279 8 100 2 1 279 789 513 Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 3133 459 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda steini

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