RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA738523 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
14748449 14748449 PRJNA738523_P_NODE_12472_length_248_cov_0.880000_g12401_i0 PRJNA738523 12472 248 0.88 2.1824 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 237 5.77e-58   NTclustered gi|471220213|ref|XM_004025132.1| 5932 g12401 i0 84.362 32.7137096774194 243 36 98 2 1 242 112 353 Ichthyophthirius multifiliis hypothetical protein (IMG5_190240) mRNA, complete cds blastn 8113 237 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
19846482 19846482 PRJNA738523_P_NODE_13956_length_245_cov_0.895349_g13885_i0 PRJNA738523 13956 245 0.895349 2.19360505 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 244 3.4e-60   NTclustered gi|1725297735|gb|MN295600.1| 282688 g13885 i0 85.47 1.91020408163265 234 34 96 0 6 239 1126 1359 Philasterides dicentrarchi trichocyst matrix protein T2-A gene, complete cds blastn 468 244 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
25424346 25424346 PRJNA738523_P_NODE_3240_length_373_cov_1.796667_g3169_i0 PRJNA738523 3240 373 1.796667 6.70156791 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 357 6.71e-94   NTclustered gi|10158|emb|X06653.1| 5949 g3169 i0 84.239 96.1179624664879 368 57 98 1 5 371 146 513 Stylonychia macronuclear beta-1 tubulin gene blastn 35852 359 0.994428969359331 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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