RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 8 ✖

tax_clade 1

bioproject 1

  • PRJDB4470 · 8 ✖

analysis 1

  • blastn · 8 ✖

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

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