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

5 rows where analysis = "blastn", bioproject = "PRJNA421571" 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_order	tax_family	tax_genus	tax_species
5527469	5527469	PRJNA421571_P_NODE_69525_length_305_cov_1.452586_g66976_i0	PRJNA421571	69525	305	1.452586	4.4303873	Mesofila sp. ATCC PRA-54	439948	SAR_Eukaryotes	SAR_Eukaryotes	368	2.49e-97	NTclustered	gi\|160337355\|gb\|EF455774.1\|	439948	g66976	i0	88.487	96.1114754098361	304	35	99	0	1	304	550	247	Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds	blastn	29314	368	1	Eukaryota	Sar	Cercozoa		Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
6801287	6801287	PRJNA421571_P_NODE_6126_length_1507_cov_2.684798_g5189_i0	PRJNA421571	6126	1507	2.684798	40.45990586	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	802	0	NTclustered	gi\|300676723\|gb\|GQ377712.1\|	323453	g5189	i0	84.211	4.13868613138686	836	120	55	11	560	1389	833	4	Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds	blastn	6237	802	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
9350652	9350652	PRJNA421571_P_NODE_28788_length_608_cov_3.254206_g26275_i0	PRJNA421571	28788	608	3.254206	19.78557248	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	551	4.869999999999998e-152	NTclustered	gi\|301014702\|gb\|GQ377715.1\|	323453	g26275	i0	88.791	54.7319078947368	455	44	74	7	22	472	40	491	Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds	blastn	33277	551	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
10625730	10625730	PRJNA421571_P_NODE_102729_length_243_cov_3.847059_g100180_i0	PRJNA421571	102729	243	3.847059	9.34835337	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	182	2.68e-41	NTclustered	gi\|300676720\|gb\|GQ377713.1\|	323453	g100180	i0	92.188	85.3991769547325	128	10	53	0	116	243	4	131	Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence	blastn	20752	182	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
11901521	11901521	PRJNA421571_P_NODE_32470_length_553_cov_2.141667_g29934_i0	PRJNA421571	32470	553	2.141667	11.84341851	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	466	1.64e-126	NTclustered	gi\|300676716\|gb\|GQ377714.1\|	323453	g29934	i0	87.019	62.8408679927667	416	50	75	3	12	427	43	454	Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds	blastn	34751	466	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74

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