metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax_phylum = "Tubulinea"

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
2143274	2143274	PRJNA893346_P_NODE_14782_length_405_cov_1.234940_g14294_i0	PRJNA893346	14782	405	1.23494	5.001507	Amoeba proteus	5775	Tubulinea	other_Eukaryota	185	1.59e-54	NR	AAP88974.1	5775	g14294	i0	74.4	4.77777777777778	129	30	94.8	2	403	20	137	263	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	1935	185	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
3419148	3419148	PRJNA893346_P_NODE_36003_length_247_cov_0.885057_g35513_i0	PRJNA893346	36003	247	0.885057	2.18609079	Amoeba proteus	5775	Tubulinea	other_Eukaryota	116	4.08e-28	NR	AAD33718.1	5775	g35513	i0	75.3	0.983805668016194	81	19	97.2	1	246	7	220	300	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	243	116	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
9796412	9796412	PRJNA893346_P_NODE_4328_length_781_cov_1.307910_g3897_i0	PRJNA893346	4328	781	1.30791	10.2147771	Amoeba proteus	5775	Tubulinea	other_Eukaryota	422	3.1599999999999986e-145	NR	AAP88974.1	5775	g3897	i0	80	0.998719590268886	260	50	99.9	1	1	780	94	351	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	780	422	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
21269664	21269664	PRJNA893346_P_NODE_1057_length_1506_cov_5.411724_g878_i0	PRJNA893346	1057	1506	5.411724	81.50056344	Copromyxa protea	931554	Tubulinea	other_Eukaryota	757	2.36e-272	NR	BAN33737.1	931554	g878	i0	79.3	0.924302788844621	464	91	91.4	1	36	1412	1	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	1392	757	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
22544627	22544627	PRJNA893346_P_NODE_1098_length_1486_cov_5.529370_g878_i1	PRJNA893346	1098	1486	5.52937	82.1664382	Copromyxa protea	931554	Tubulinea	other_Eukaryota	758	1.3199999999999996e-272	NR	BAN33737.1	931554	g878	i1	79.3	0.936742934051144	464	91	92.7	1	1471	95	1	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	1392	758	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
31477858	31477858	PRJNA893346_P_NODE_35436_length_248_cov_0.880000_g34946_i0	PRJNA893346	35436	248	0.88	2.1824	Amoeba proteus	5775	Tubulinea	other_Eukaryota	81.6	8.18e-16	NR	AAD33718.1	5775	g34946	i0	54.3	0.846774193548387	70	28	84.7	1	214	5	581	646	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	210	81.6	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus

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