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

5 rows where analysis = "blastn", bioproject = "PRJNA999747" 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
980598	980598	PRJNA999747_S_NODE_721_length_330_cov_3.013378_g689_i0	PRJNA999747	721	330	3.013378	9.9441474	Guttulinopsis rogosa	2231170	SAR_Eukaryotes	SAR_Eukaryotes	571	1.9299999999999998e-158	NTclustered	gi\|1402550485\|gb\|MH488771.1\|	2231170	g689	i0	98.165	47.4151515151515	327	6	99	0	4	330	1636	1962	Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	15647	571	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Guttulinopsis	Guttulinopsis rogosa
2255825	2255825	PRJNA999747_S_NODE_1182_length_275_cov_5.909836_g1150_i0	PRJNA999747	1182	275	5.909836	16.252049	Guttulinopsis rogosa	2231170	SAR_Eukaryotes	SAR_Eukaryotes	497	2.7e-136	NTclustered	gi\|1402550485\|gb\|MH488771.1\|	2231170	g1150	i0	100	6.93090909090909	269	0	98	0	4	272	410	142	Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	1906	497	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Guttulinopsis	Guttulinopsis rogosa
12459767	12459767	PRJNA999747_S_NODE_570_length_358_cov_84.941896_g538_i0	PRJNA999747	570	358	84.941896	304.09198768	Rosculus vulgaris	2231165	SAR_Eukaryotes	SAR_Eukaryotes	274	6.65e-69	NTclustered	gi\|1402550474\|gb\|MH488760.1\|	2231165	g538	i0	81.03	55.8659217877095	369	48	99	14	4	358	2241	2601	Rosculus vulgaris isolate CCA sequence	blastn	20000	274	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus vulgaris
23932996	23932996	PRJNA999747_S_NODE_2359_length_200_cov_4.023669_g2327_i0	PRJNA999747	2359	200	4.023669	8.047338	Verrucomonas longifila	629764	SAR_Eukaryotes	SAR_Eukaryotes	161	2.77e-35	NTclustered	gi\|290760489\|gb\|GQ144692.1\|	629764	g2327	i0	84.337	78.265	166	24	83	2	1	166	1408	1245	Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence	blastn	15653	161	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Ventricleftida		Verrucomonas	Verrucomonas longifila
24225811	24225811	PRJNA999747_S_NODE_2559_length_193_cov_4.975309_g2527_i0	PRJNA999747	2559	193	4.975309	9.60234637	Guttulinopsis	1144921	SAR_Eukaryotes	SAR_Eukaryotes	346	6.82e-91	NTclustered	gi\|1402550487\|gb\|MH488773.1\|	2231167	g2527	i0	100	8.58031088082902	187	0	97	0	4	190	1060	874	Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence	blastn	1656	346	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Guttulinopsis	Guttulinopsis sp.

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