metadata: contig_metadata: 5 rows where bioproject = "PRJNA1031674", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA1031674", 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
9094419	9094419	PRJNA1031674_P_NODE_6008_length_352_cov_1.103943_g5797_i0	PRJNA1031674	6008	352	1.103943	3.88587936	Pseudocohnilembus persalinus	266149	SAR_Eukaryotes	SAR_Eukaryotes	158	6.85e-34	NTclustered	gi\|2072713056\|gb\|MH608212.2\|	266149	g5797	i0	84.906	30.2727272727273	159	21	45	2	3	161	25014	25169	Pseudocohnilembus persalinus mitochondrion	blastn	10656	158	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Pseudocohnilembidae	Pseudocohnilembus	Pseudocohnilembus persalinus
10370093	10370093	PRJNA1031674_P_NODE_6049_length_351_cov_1.766187_g5838_i0	PRJNA1031674	6049	351	1.766187	6.19931637	Cryptocaryon irritans	153251	SAR_Eukaryotes	SAR_Eukaryotes	292	1.8e-74	NTclustered	gi\|2431531581\|ref\|NC_070360.1\|	153251	g5838	i0	86.496	63.6581196581197	274	27	76	8	1	268	6127	5858	Cryptocaryon irritans mitochondrion, complete genome	blastn	22344	292	1	Eukaryota	Sar	Ciliophora				Cryptocaryon	Cryptocaryon irritans
19292527	19292527	PRJNA1031674_P_NODE_21916_length_251_cov_1.679775_g21705_i0	PRJNA1031674	21916	251	1.679775	4.21623525	Uronema marinum	35107	SAR_Eukaryotes	SAR_Eukaryotes	165	2.8e-36	NTclustered	gi\|1464314795\|ref\|NC_039174.1\|	35107	g21705	i0	78.988	51.7490039840637	257	43	99	10	1	250	8420	8168	Uronema marinum mitochondrion, complete genome	blastn	12989	165	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Philasterida	Uronematidae	Uronema	Uronema marinum
27098294	27098294	PRJNA1031674_P_NODE_22162_length_251_cov_0.865169_g21951_i0	PRJNA1031674	22162	251	0.865169	2.17157419	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	95.1	1.58e-20	NR	XP_001031526.2	312017	g21951	i0	83.9	0.741035856573705	62	10	74.1	0	22	207	3908	3969	XP_001031526.2 dynein heavy chain 1, axonemal protein [Tetrahymena thermophila SB210]	diamond	186	95.1	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila
27256322	27256322	PRJNA1031674_P_NODE_19063_length_262_cov_2.513228_g18852_i0	PRJNA1031674	19063	262	2.513228	6.58465736	Tetrahymena thermophila SB21	5911	SAR_Eukaryotes	SAR_Eukaryotes	92.4	4.31e-21	NR	XP_001018241.2	312017	g18852	i0	50.6	0.973282442748092	85	42	97.3	0	260	6	105	189	XP_001018241.2 hypothetical protein TTHERM_00283850 [Tetrahymena thermophila SB210]	diamond	255	92.4	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena thermophila

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