RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 10 ✖

tax_clade 1

bioproject 1

  • PRJEB10140 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2561528 2561528 PRJEB10140_P_NODE_145223_length_254_cov_2.824390_g127915_i0 PRJEB10140 145223 254 2.82439 7.1739506 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 470 5.37e-128   NTclustered gi|10782|emb|X54004.1| 5908 g127915 i0 100 59.1692913385827 254 0 100 0 1 254 1927 2180 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 15029 470 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
7665465 7665465 PRJEB10140_P_NODE_53747_length_681_cov_4.205696_g37586_i0 PRJEB10140 53747 681 4.205696 28.64078976 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 366 2.139999999999999e-96   NTclustered gi|28974199|gb|AY204512.1| 94289 g37586 i0 77.922 1.18649045521292 616 116 90 13 1 612 468 1067 Sterkiella histriomuscorum cathepsin B gene, complete cds blastn 808 366 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
11489933 11489933 PRJEB10140_P_NODE_193850_length_200_cov_1.496689_g176541_i0 PRJEB10140 193850 200 1.496689 2.993378 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 237 4.4700000000000005e-58   NTclustered gi|47175724|gb|AY617304.1| 94289 g176541 i0 88 96.61 200 24 100 0 1 200 374 175 Sterkiella histriomuscorum clone UGC1O0001_L01_F genomic sequence blastn 19322 237 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
11490755 11490755 PRJEB10140_P_NODE_275650_length_164_cov_0.904348_g258341_i0 PRJEB10140 275650 164 0.904348 1.48313072 Aspidisca lynceus 2035364 SAR_Eukaryotes SAR_Eukaryotes 303 3.42e-78   NTclustered gi|2328859120|gb|OP828525.1| 2035364 g258341 i0 100 50.2439024390244 164 0 100 0 1 164 69 232 Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence blastn 8240 303 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Aspidiscidae Aspidisca Aspidisca lynceus
11491415 11491415 PRJEB10140_P_NODE_90690_length_403_cov_5.406780_g73401_i0 PRJEB10140 90690 403 5.40678 21.7893234 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 723 0   NTclustered gi|10782|emb|X54004.1| 5908 g73401 i0 99.01 79.9255583126551 404 3 100 1 1 403 2785 2382 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 32210 723 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
14040401 14040401 PRJEB10140_P_NODE_244292_length_169_cov_1.633333_g226983_i0 PRJEB10140 244292 169 1.633333 2.76033277 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.014   NTclustered gi|2386263432|ref|XM_001458707.2| 5888 g226983 i0 100 0.165680473372781 28 0 17 0 129 156 129 156 Paramecium tetraurelia uncharacterized protein (GSPATT00024075001), partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
15313709 15313709 PRJEB10140_P_NODE_118573_length_308_cov_2.868726_g101267_i0 PRJEB10140 118573 308 2.868726 8.83567608 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 553 6.46e-153   NTclustered gi|10782|emb|X54004.1| 5908 g101267 i0 99.026 80.5292207792208 308 3 100 0 1 308 1631 1938 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 24803 553 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
15314259 15314259 PRJEB10140_P_NODE_208893_length_189_cov_1.492857_g191584_i0 PRJEB10140 208893 189 1.492857 2.82149973 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.005   NTclustered gi|829167907|ref|XM_001014996.2| 312017 g191584 i0 100 0.153439153439153 29 0 15 0 110 138 650 678 Tetrahymena thermophila SB210 Sir2 family transcriptional regulator partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
17863398 17863398 PRJEB10140_P_NODE_136095_length_270_cov_1.909502_g118788_i0 PRJEB10140 136095 270 1.909502 5.1556554 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.025   NTclustered gi|145540374|ref|XM_001455840.1| 5888 g118788 i0 100 0.103703703703704 28 0 10 0 159 186 1194 1221 Paramecium tetraurelia uncharacterized protein (GSPATT00021648001), partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
24237574 24237574 PRJEB10140_P_NODE_145060_length_255_cov_1.009709_g127752_i0 PRJEB10140 145060 255 1.009709 2.57475795 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 322 1.6e-83   NTclustered gi|10792|emb|X12768.1| 5908 g127752 i0 89.412 100.078431372549 255 27 100 0 1 255 1271 1017 Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) blastn 25520 322 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis

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