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

5 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
1865260	1865260	PRJNA611476_P_NODE_32002_length_366_cov_4.713311_g31211_i0	PRJNA611476	32002	366	4.713311	17.25071826	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	239	2.48e-58	NTclustered	gi\|300676716\|gb\|GQ377714.1\|	323453	g31211	i0	86.574	0.590163934426229	216	29	59	0	151	366	454	239	Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds	blastn	216	239	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
15891852	15891852	PRJNA611476_P_NODE_10693_length_596_cov_1.766730_g9909_i0	PRJNA611476	10693	596	1.76673	10.5297108	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	817	0	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g9909	i0	91.362	74.4110738255034	602	44	99	5	2	596	1277	1877	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	44349	817	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
17167376	17167376	PRJNA611476_P_NODE_44694_length_322_cov_2.473896_g43903_i0	PRJNA611476	44694	322	2.473896	7.96594512	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	296	1.26e-75	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g43903	i0	83.742	34.9751552795031	326	40	100	11	1	322	3722	4038	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	11262	296	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
19716279	19716279	PRJNA611476_P_NODE_61476_length_282_cov_1.473684_g60685_i0	PRJNA611476	61476	282	1.473684	4.15578888	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	459	1.31e-124	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g60685	i0	95.819	101.684397163121	287	7	100	4	1	282	2158	2444	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	28675	459	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
20992318	20992318	PRJNA611476_P_NODE_8197_length_677_cov_4.844371_g7423_i0	PRJNA611476	8197	677	4.844371	32.79639167	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	551	5.459999999999998e-152	NTclustered	gi\|301014702\|gb\|GQ377715.1\|	323453	g7423	i0	88.791	49.1536189069424	455	44	67	7	216	666	491	40	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

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