metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA685607" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA685607" and tax_phylum = "Tubulinea"

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
10870518	10870518	PRJNA685607_P_NODE_9309_length_509_cov_1.683486_g8953_i0	PRJNA685607	9309	509	1.683486	8.56894374	Arcella vulgaris	874295	Tubulinea	other_Eukaryota	494	6.88e-135	NTclustered	gi\|304308803\|gb\|HM853734.1\|	874295	g8953	i0	86.607	94.8231827111984	448	58	88	2	55	501	790	344	Arcella vulgaris strain SC clone act02 actin gene, partial cds	blastn	48265	494	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Arcellidae	Arcella	Arcella vulgaris
12145678	12145678	PRJNA685607_P_NODE_51030_length_276_cov_1.320197_g50671_i0	PRJNA685607	51030	276	1.320197	3.64374372	Copromyxa protea	931554	Tubulinea	other_Eukaryota	220	6.57e-53	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g50671	i0	81.455	3.03623188405797	275	45	99	4	5	276	281	10	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	838	220	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
12145684	12145684	PRJNA685607_P_NODE_52870_length_272_cov_2.879397_g52511_i0	PRJNA685607	52870	272	2.879397	7.83195984	Copromyxa protea	931554	Tubulinea	other_Eukaryota	255	1.77e-63	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g52511	i0	85.366	3.15808823529412	246	36	90	0	27	272	1	246	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	859	255	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
16478992	16478992	PRJNA685607_P_NODE_19993_length_376_cov_2.151815_g19635_i0	PRJNA685607	19993	376	2.151815	8.0908244	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	610	4.709999999999998e-170	NTclustered	gi\|399764264\|gb\|JQ271775.1\|	1215986	g19635	i0	99.405	43.4601063829787	336	2	89	0	41	376	1924	1589	Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence	blastn	16341	616	0.99025974025974	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 02 sp. 1HFKJ

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