metadata: contig_metadata: 7 rows where bioproject = "PRJNA1196384", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA1196384", tax_clade = "Sar" and tax_phylum = "Ciliophora"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
322768	322768	PRJNA1196384_S_NODE_8161_length_152_cov_1.330435_g8097_i0	PRJNA1196384	8161	152	1.330435	2.0222612	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	104	3.38e-18	NTclustered	gi\|2386245158\|ref\|XM_001446884.2\|	5888	g8097	i0	79.739	1.82236842105263	153	23	98	8	4	152	614	466	Paramecium tetraurelia uncharacterized protein (GSPATT00014470001), partial mRNA	blastn	277	104	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
6700553	6700553	PRJNA1196384_S_NODE_2226_length_260_cov_2.354260_g2162_i0	PRJNA1196384	2226	260	2.35426	6.121076	Paramecium tetraurelia	5888	SAR_Eukaryotes	SAR_Eukaryotes	189	1.7299999999999996e-43	NTclustered	gi\|1460089\|emb\|X99489.1\|	5888	g2162	i0	80	31.7961538461538	260	48	99	4	1	258	700	957	Paramecium tetraurelia alphaPT1 gene for alpha-tubulin	blastn	8267	189	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Peniculida	Parameciidae	Paramecium	Paramecium tetraurelia
18174284	18174284	PRJNA1196384_S_NODE_2815_length_231_cov_1.747423_g2751_i0	PRJNA1196384	2815	231	1.747423	4.03654713	Sterkiella histriomuscorum	94289	SAR_Eukaryotes	SAR_Eukaryotes	156	1.53e-33	NTclustered	gi\|21215210\|gb\|AF510207.1\|	94289	g2751	i0	88.372	50.4761904761905	129	15	56	0	103	231	1488	1360	Sterkiella histriomuscorum beta-tubulin gene, complete cds	blastn	11660	156	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Sterkiella	Sterkiella histriomuscorum
21999521	21999521	PRJNA1196384_S_NODE_7578_length_156_cov_1.285714_g7514_i0	PRJNA1196384	7578	156	1.285714	2.00571384	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	83.6	2.38e-17	NR	OMJ95410.1	5963	g7514	i0	78.7	8.44230769230769	47	10	90.4	0	154	14	141	187	OMJ95410.1 hypothetical protein SteCoe_1171 [Stentor coeruleus]	diamond	1317	83.6	1	Eukaryota	Sar	Ciliophora	Heterotrichea	Heterotrichida	Stentoridae	Stentor	Stentor coeruleus
27483275	27483275	PRJNA1196384_S_NODE_4023_length_198_cov_1.813665_g3959_i0	PRJNA1196384	4023	198	1.813665	3.5910567	Stylonychia lemnae	5949	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.58e-9	NR	CDW83682.1	5949	g3959	i0	58.5	3.48484848484848	53	22	80.3	0	168	10	44	96	CDW83682.1 60s ribosomal protein [Stylonychia lemnae]	diamond	690	60.8	1	Eukaryota	Sar	Ciliophora	Spirotrichea	Sporadotrichida	Oxytrichidae	Stylonychia	Stylonychia lemnae
31494708	31494708	PRJNA1196384_S_NODE_6116_length_168_cov_1.786260_g6052_i0	PRJNA1196384	6116	168	1.78626	3.0009168	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	101	2.1599999999999998e-24	NR	KRX09922.1	266149	g6052	i0	72.7	0.982142857142857	55	15	98.2	0	167	3	202	256	KRX09922.1 Lysozyme-like domain [Pseudocohnilembus persalinus]	diamond	165	101	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
31766515	31766515	PRJNA1196384_S_NODE_2477_length_247_cov_1.280952_g2413_i0	PRJNA1196384	2477	247	1.280952	3.16395144	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.6	2.92e-11	NR	KAL4500908.1	2486642	g2413	i0	40.9	4.90688259109312	88	45	98.4	2	243	1	196	283	KAL4500908.1 hypothetical protein ABPG72_020142 [Tetrahymena utriculariae]	diamond	1212	68.9	0.995645863570392	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena utriculariae

Advanced export

JSON shape: default, array, newline-delimited

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