metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax_phylum = "Cercozoa"

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
8065144	8065144	PRJNA395690_P_NODE_4827_length_362_cov_1.214058_g4678_i0	PRJNA395690	4827	362	1.214058	4.39488996	Mesofila sp. ATCC PRA-54	439948	SAR_Eukaryotes	SAR_Eukaryotes	303	8.58e-78	NTclustered	gi\|160337351\|gb\|EF455772.1\|	439948	g4678	i0	81.868	100.085635359116	364	62	100	4	1	362	284	645	Dimorpha sp. ATCC PRA-54 clone 1 actin gene, partial cds	blastn	36231	303	1	Eukaryota	Sar	Cercozoa			Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
15714476	15714476	PRJNA395690_P_NODE_4333_length_379_cov_13.169697_g4184_i0	PRJNA395690	4333	379	13.169697	49.91315163	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	291	7.03e-74	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g4184	i0	83.81	29.8707124010554	315	41	82	10	1	310	3730	4039	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	11321	291	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
16989077	16989077	PRJNA395690_P_NODE_23254_length_179_cov_1.176923_g23102_i0	PRJNA395690	23254	179	1.176923	2.10669217	Mesofila sp. ATCC PRA-54	439948	SAR_Eukaryotes	SAR_Eukaryotes	183	5.15e-42	NTclustered	gi\|160337355\|gb\|EF455774.1\|	439948	g23102	i0	85.632	97.659217877095	174	25	97	0	1	174	18	191	Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds	blastn	17481	183	1	Eukaryota	Sar	Cercozoa			Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
18263182	18263182	PRJNA395690_P_NODE_17075_length_196_cov_2.081633_g16923_i0	PRJNA395690	17075	196	2.081633	4.08000068	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	171	4.49e-38	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g16923	i0	86.792	30.4540816326531	159	13	79	5	1	155	1641	1795	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	5969	171	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
23363558	23363558	PRJNA395690_P_NODE_11719_length_237_cov_5.638298_g11567_i0	PRJNA395690	11719	237	5.638298	13.36276626	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	385	1.85e-102	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g11567	i0	97.345	94.7341772151899	226	6	95	0	1	226	1551	1326	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	22452	385	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa

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