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

5 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax_phylum = "Endomyxa"

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
7829709	7829709	PRJNA1059246_P_NODE_42707_length_323_cov_1.060000_g42081_i0	PRJNA1059246	42707	323	1.06	3.4238	Arachnula sp. CL12	862247	SAR_Eukaryotes	SAR_Eukaryotes	424	5.58e-114	NTclustered	gi\|302026178\|gb\|GQ377695.1\|	862247	g42081	i0	90.402	87.3467492260062	323	29	99	2	1	322	513	192	Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds	blastn	28213	424	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
11655974	11655974	PRJNA1059246_P_NODE_68690_length_245_cov_0.883721_g68064_i0	PRJNA1059246	68690	245	0.883721	2.16511645	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	91.6	4.69e-14	NTclustered	gi\|1023748055\|gb\|KU169244.1\|	37360	g68064	i0	88.158	4.33877551020408	76	9	31	0	158	233	62	137	Plasmodiophora brassicae isolate pathotype P5 peptidyl-prolyl cis-trans isomerase gene, complete cds	blastn	1063	91.6	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
18028627	18028627	PRJNA1059246_P_NODE_21755_length_485_cov_1.441748_g21136_i0	PRJNA1059246	21755	485	1.441748	6.9924778	Arachnula sp. CL22	862246	SAR_Eukaryotes	SAR_Eukaryotes	305	3.29e-78	NTclustered	gi\|301014696\|gb\|GQ377694.1\|	862246	g21136	i0	86.219	64.4453608247423	283	37	58	2	26	307	284	3	Arachnula sp. CL22 ribosomal protein S23a (rps23a) mRNA, partial cds	blastn	31256	305	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL22
18029155	18029155	PRJNA1059246_P_NODE_6855_length_939_cov_4.654734_g6382_i0	PRJNA1059246	6855	939	4.654734	43.70795226	Arachnula sp. CL12	862247	SAR_Eukaryotes	SAR_Eukaryotes	617	7.47e-172	NTclustered	gi\|302026178\|gb\|GQ377695.1\|	862247	g6382	i0	79.067	75.6634717784877	922	175	97	16	5	916	389	1302	Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds	blastn	71048	617	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
19302420	19302420	PRJNA1059246_P_NODE_11816_length_694_cov_2.541063_g11244_i0	PRJNA1059246	11816	694	2.541063	17.63497722	Arachnula sp. CL12	862247	SAR_Eukaryotes	SAR_Eukaryotes	595	2.5499999999999995e-165	NTclustered	gi\|302026178\|gb\|GQ377695.1\|	862247	g11244	i0	82.235	49.1743515850144	698	116	100	5	1	694	1088	395	Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds	blastn	34127	595	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12

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