metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax

6 rows where analysis = "blastn", bioproject = "PRJEB6584" 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
25660230	25660230	PRJEB6584o_S_NODE_1138_length_567_cov_1038.451128_g1073_i0	PRJEB6584	1138	567	1038.451128	5888.01789576	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	143	3.23e-29	NTclustered	gi\|66805304\|ref\|XM_631293.1\|	352472	g1073	i0	85.135	9.14462081128748	148	13	40	5	125	263	222	75	Dictyostelium discoideum AX4 hypothetical protein (litaf) mRNA, complete cds	blastn	5185	143	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
25661307	25661307	PRJEB6584o_S_NODE_7314_length_313_cov_5.647482_g7206_i0	PRJEB6584	7314	313	5.647482	17.67661866	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	161	4.66e-35	NTclustered	gi\|330842002\|ref\|XM_003292928.1\|	5786	g7206	i0	82.587	16.2012779552716	201	17	63	8	40	237	55	240	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_95723), partial mRNA	blastn	5071	161	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
25752497	25752497	PRJEB6584o_S_NODE_64538_length_160_cov_2.752000_g64430_i0	PRJEB6584	64538	160	2.752	4.4032	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	122	9.97e-24	NTclustered	gi\|161207\|gb\|M21500.1\|SLMACT35	5791	g64430	i0	92.857	53.01875	84	6	53	0	77	160	1163	1080	P.polycephalum actin (Ppa35) mRNA, complete cds	blastn	8483	122	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
26067982	26067982	PRJEB6584e_S_NODE_725_length_281_cov_3.410569_g710_i0	PRJEB6584	725	281	3.410569	9.58369889	Dictyostelium intermedium	361076	Evosea	other_Eukaryota	128	4.18e-25	NTclustered	gi\|2127860748\|ref\|NC_058586.1\|	361076	g710	i0	77.99	2.92526690391459	209	42	74	4	26	232	573	367	Dictyostelium intermedium mitochondrion, complete genome	blastn	822	128	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium intermedium
26204365	26204365	PRJEB6584h_S_NODE_662_length_439_cov_4.269802_g602_i0	PRJEB6584	662	439	4.269802	18.74443078	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	52.8	0.042	NTclustered	gi\|470243001\|ref\|XM_004355171.1\|	261658	g602	i0	100	0.0637813211845103	28	0	6	0	412	439	1653	1626	Cavenderia fasciculata putative protein serine/threonine kinase (dyrk1), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
26341852	26341852	PRJEB6584o_S_NODE_9287_length_284_cov_5.453815_g9179_i0	PRJEB6584	9287	284	5.453815	15.4888346	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	122	1.9699999999999998e-23	NTclustered	gi\|1160571044\|ref\|XM_020575016.1\|	670386	g9179	i0	81.046	1	153	29	54	0	107	259	435	283	Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA	blastn	284	122	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);;