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

5 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Evosea"

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
1923899	1923899	PRJNA675331_P_NODE_3522_length_499_cov_2.377934_g3351_i0	PRJNA675331	3522	499	2.377934	11.86589066	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	575	2.3399999999999996e-159	NTclustered	gi\|66821302\|ref\|XM_639054.1\|	352472	g3351	i0	87.959	98.4428857715431	490	56	98	3	1	488	390	878	Dictyostelium discoideum AX4 hypothetical protein (act9) mRNA, complete cds	blastn	49123	575	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
3720193	3720193	PRJNA675331_P_NODE_11103_length_302_cov_1.192140_g10931_i0	PRJNA675331	11103	302	1.19214	3.6002628	Eumycetozoa	142796	Evosea	other_Eukaryota	215	3.39e-51	NTclustered	gi\|66800824\|ref\|XM_629336.1\|	352472	g10931	i0	79.801	12.3245033112583	302	55	99	6	1	299	32	330	Dictyostelium discoideum AX4 Ras GTPase (rasD) mRNA, complete cds	blastn	3722	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
4475808	4475808	PRJNA675331_P_NODE_7404_length_357_cov_1.626761_g7232_i0	PRJNA675331	7404	357	1.626761	5.80753677	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	193	1.91e-44	NTclustered	gi\|330845015\|ref\|XM_003294352.1\|	5786	g7232	i0	82.949	8.97478991596639	217	34	61	3	80	295	553	767	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_51485), mRNA	blastn	3204	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13401783	13401783	PRJNA675331_P_NODE_10771_length_306_cov_0.991416_g10599_i0	PRJNA675331	10771	306	0.991416	3.03373296	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	189	2.08e-43	NTclustered	gi\|470240985\|ref\|XM_004354438.1\|	261658	g10599	i0	77.994	4.22222222222222	309	62	100	6	1	306	891	1196	Cavenderia fasciculata S-adenosyl-L-homocysteine hydrolase (sahA), partial mRNA	blastn	1292	189	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
24873883	24873883	PRJNA675331_P_NODE_17480_length_254_cov_1.530387_g17308_i0	PRJNA675331	17480	254	1.530387	3.88718298	Heterostelium album	2086695	Evosea	other_Eukaryota	259	1.27e-64	NTclustered	gi\|1160557950\|ref\|XM_020575808.1\|	670386	g17308	i0	85.317	132.629921259843	252	35	99	2	4	254	692	442	Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA	blastn	33688	259	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album

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