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

6 rows where analysis = "blastn", bioproject = "PRJEB76780" 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
1413373	1413373	PRJEB76780_P_NODE_1342_length_715_cov_2.746106_g1249_i0	PRJEB76780	1342	715	2.746106	19.6346579	Rostrostelium ellipticum	361140	Evosea	other_Eukaryota	390	1.33e-103	NTclustered	gi\|117413669\|emb\|AM168485.1\|	361140	g1249	i0	82.251	76.9426573426573	462	73	64	8	260	715	128	586	Rostrostelium ellipticum partial tuba gene for alpha-tubulin, exon 1, isolate AE2	blastn	55014	390	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Rostrostelium	Rostrostelium ellipticum
3964861	3964861	PRJEB76780_P_NODE_10464_length_253_cov_0.866667_g10364_i0	PRJEB76780	10464	253	0.866667	2.19266751	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	137	6.16e-28	NTclustered	gi\|831776054\|ref\|XM_012899232.1\|	1410327	g10364	i0	84.892	47.1106719367589	139	18	55	3	27	164	1076	1212	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	11919	137	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
4824505	4824505	PRJEB76780_P_NODE_6904_length_307_cov_1.474359_g6804_i0	PRJEB76780	6904	307	1.474359	4.52628213	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	279	1.21e-70	NTclustered	gi\|15284031\|dbj\|AB070527.1\|	5791	g6804	i0	83.553	184.824104234528	304	44	99	2	1	304	478	775	Physarum polycephalum ub3 mRNA for ubiquitin 3, complete cds	blastn	56741	279	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
10341790	10341790	PRJEB76780_P_NODE_1749_length_628_cov_1.796396_g1652_i0	PRJEB76780	1749	628	1.796396	11.28136688	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	231	7.459999999999998e-56	NTclustered	gi\|831786008\|ref\|XM_012902515.1\|	1410327	g1652	i0	79.573	1.53980891719745	328	63	52	4	297	622	412	737	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	967	231	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
16715453	16715453	PRJEB76780_P_NODE_2414_length_530_cov_1.706783_g2314_i0	PRJEB76780	2414	530	1.706783	9.0459499	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	294	7.83e-75	NTclustered	gi\|831769224\|ref\|XM_012897186.1\|	1410327	g2314	i0	78.448	58.4716981132075	464	91	86	8	70	527	19	479	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	30990	294	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
16715484	16715484	PRJEB76780_P_NODE_4794_length_371_cov_1.087248_g4694_i0	PRJEB76780	4794	371	1.087248	4.03369008	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	171	9.33e-38	NTclustered	gi\|831765193\|ref\|XM_012895955.1\|	1410327	g4694	i0	76.22	1.84366576819407	328	75	88	1	7	331	1159	1486	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	684	171	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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