RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJDB4470", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJDB4470 · 13 ✖

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
2256622 2256622 PRJDB4470_P_NODE_65382_length_233_cov_1.413043_g64227_i0 PRJDB4470 65382 233 1.413043 3.29239019 Litostomatea 5988 SAR_Eukaryotes SAR_Eukaryotes 348 2.37e-91   NTclustered gi|1226859313|gb|MF474356.1| 394801 g64227 i0 93.59 72.519313304721 234 13 100 2 1 233 1334 1566 Lacrymaria marina isolate QZS2013110504 large subunit ribosomal RNA gene, partial sequence blastn 16897 348 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Lacrymariidae Lacrymaria Lacrymaria marina
5111851 5111851 PRJDB4470_P_NODE_34425_length_382_cov_9.315315_g33276_i0 PRJDB4470 34425 382 9.315315 35.5845033 Dysteria brasiliensis 497733 SAR_Eukaryotes SAR_Eukaryotes 311 5.4400000000000005e-80   NTclustered gi|1216628402|gb|KX099196.1| 497733 g33276 i0 84.858 69.9528795811518 317 38 82 7 1 312 312 1 Dysteria brasiliensis clone DB3 28S ribosomal RNA gene, partial sequence blastn 26722 311 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Dysteriidae Dysteria Dysteria brasiliensis
8936859 8936859 PRJDB4470_P_NODE_88408_length_185_cov_1.500000_g87253_i0 PRJDB4470 88408 185 1.5 2.775 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 296 6.61e-76   NTclustered gi|1837628855|gb|MN158348.1| 5909 g87253 i0 100 83.3351351351351 160 0 86 0 26 185 4204 4363 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 15417 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
10212536 10212536 PRJDB4470_P_NODE_65009_length_234_cov_1.664865_g63854_i0 PRJDB4470 65009 234 1.664865 3.8957841 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|829099384|ref|XM_971547.2| 312017 g63854 i0 100 0.123931623931624 29 0 12 0 69 97 1809 1837 Tetrahymena thermophila SB210 MIR domain protein partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
10212802 10212802 PRJDB4470_P_NODE_97749_length_172_cov_1.658537_g96594_i0 PRJDB4470 97749 172 1.658537 2.85268364 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.014   NTclustered gi|145505128|ref|XM_001438494.1| 5888 g96594 i0 100 0.325581395348837 28 0 16 0 112 139 294 267 Paramecium tetraurelia uncharacterized protein (GSPATT00000846001), partial mRNA blastn 56 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
16284074 16284074 PRJDB4470_P_NODE_78693_length_201_cov_3.203947_g77538_i0 PRJDB4470 78693 201 3.203947 6.43993347 root 1 Root_unresolved Root_unresolved 337 4.309999999999999e-88   NTclustered gi|10832|emb|X54512.1| 5911 g77538 i0 100 84.5970149253731 182 0 91 0 20 201 8128 8309 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 17004 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
19134891 19134891 PRJDB4470_P_NODE_27176_length_447_cov_42.331658_g26038_i0 PRJDB4470 27176 447 42.331658 189.22251126 Epistylis sp. 6 2979169 SAR_Eukaryotes SAR_Eukaryotes 702 0   NTclustered gi|2304601482|gb|OP458303.1| 2979169 g26038 i0 98.254 88.2170022371365 401 7 90 0 47 447 1 401 Epistylis sp. 6 large subunit ribosomal RNA gene, partial sequence blastn 39433 702 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. 6
20410385 20410385 PRJDB4470_P_NODE_72157_length_215_cov_2.463855_g71002_i0 PRJDB4470 72157 215 2.463855 5.29728825 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 359 9.969999999999999e-95   NTclustered gi|299830252|ref|NC_014262.1| 5885 g71002 i0 100 30.3720930232558 194 0 90 0 22 215 15220 15027 Paramecium caudatum mitochondrion, complete genome blastn 6530 359 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
27348758 27348758 PRJDB4470_P_NODE_55023_length_268_cov_1.922374_g53868_i0 PRJDB4470 55023 268 1.922374 5.15196232 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 89.7 6.16e-19   NR CAD8092539.1 65129 g53868 i0 58.6 0.783582089552239 70 29 78.4 0 3 212 257 326 CAD8092539.1 unnamed protein product [Paramecium sonneborni] diamond 210 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28637427 28637427 PRJDB4470_P_NODE_53147_length_276_cov_1.145374_g51992_i0 PRJDB4470 53147 276 1.145374 3.16123224 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.021   NR CAD8148685.1 43138 g51992 i0 38.4 1.58695652173913 73 39 79.3 1 275 57 363 429 CAD8148685.1 unnamed protein product [Paramecium pentaurelia] diamond 438 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29937809 29937809 PRJDB4470_P_NODE_81031_length_197_cov_1.405405_g79876_i0 PRJDB4470 81031 197 1.405405 2.76864785 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00117   NR XP_001446247.1 5888 g79876 i0 48.8 0.654822335025381 43 22 65.5 0 32 160 194 236 XP_001446247.1 uncharacterized protein GSPATT00001891001 [Paramecium tetraurelia] diamond 129 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32087236 32087236 PRJDB4470_P_NODE_62638_length_241_cov_2.046875_g61483_i0 PRJDB4470 62638 241 2.046875 4.93296875 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.53e-11   NR TNV71297.1 5974 g61483 i0 71.4 0.522821576763486 42 12 52.3 0 25 150 144 185 TNV71297.1 hypothetical protein FGO68_gene13476 [Halteria grandinella] diamond 126 67.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32719280 32719280 PRJDB4470_P_NODE_124540_length_162_cov_0.893805_g123385_i0 PRJDB4470 124540 162 0.893805 1.4479641 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.05e-7   NR CAG9335420.1 1481888 g123385 i0 45.1 1.90740740740741 51 28 94.4 0 158 6 26 76 CAG9335420.1 unnamed protein product [Blepharisma stoltei] diamond 309 55.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei

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