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

4 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
3683034	3683034	PRJNA564013_P_NODE_163943_length_339_cov_3.924460_g161093_i0	PRJNA564013	163943	339	3.92446	13.3039194	Physariida	5789	Evosea	other_Eukaryota	233	1.07e-56	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g161093	i0	87.204	2.36578171091445	211	19	61	8	1	207	5608	5814	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	802	233	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
6929033	6929033	PRJNA564013_P_NODE_315446_length_216_cov_2.296774_g312594_i0	PRJNA564013	315446	216	2.296774	4.96103184	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	100	6.71e-17	NTclustered	gi\|470252539\|ref\|XM_004359310.1\|	261658	g312594	i0	80.916	3.66203703703704	131	21	60	4	23	151	397	525	Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA	blastn	791	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
15160872	15160872	PRJNA564013_P_NODE_339132_length_204_cov_4.083916_g336280_i0	PRJNA564013	339132	204	4.083916	8.33118864	Physariida	5789	Evosea	other_Eukaryota	147	7.939999999999999e-31	NTclustered	gi\|37515398\|emb\|AJ584697.1\|	159720	g336280	i0	86.567	26.828431372549	134	16	66	2	61	194	9539	9670	Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1	blastn	5473	147	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Fuligo	Fuligo septica
23500700	23500700	PRJNA564013_P_NODE_178419_length_326_cov_5.271698_g175569_i0	PRJNA564013	178419	326	5.271698	17.18573548	Entamoeba terrapinae	110771	Evosea	other_Eukaryota	128	4.95e-25	NTclustered	gi\|148923265\|gb\|EF421319.1\|	110771	g175569	i0	94.048	2.55828220858896	84	5	26	0	32	115	728	645	Entamoeba terrapinae strain M tRNA array unit SQCK genomic sequence	blastn	834	128	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba terrapinae

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