metadata: contig_metadata: 8 rows where bioproject = "PRJNA631119" and tax

8 rows where bioproject = "PRJNA631119" 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
1879435	1879435	PRJNA631119_P_NODE_34682_length_246_cov_1.757225_g34564_i0	PRJNA631119	34682	246	1.757225	4.3227735	Amoeba proteus	5775	Tubulinea	other_Eukaryota	135	4.079999999999999e-37	NR	AFX84537.1	5775	g34564	i0	83.8	0.975609756097561	80	13	97.6	0	4	243	110	189	AFX84537.1 alpha tubulin, partial [Amoeba proteus]	diamond	240	135	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
3703620	3703620	PRJNA631119_P_NODE_5343_length_492_cov_3.167064_g5225_i0	PRJNA631119	5343	492	3.167064	15.58195488	Amoeba proteus	5775	Tubulinea	other_Eukaryota	258	2.729999999999999e-82	NR	AAP88974.1	5775	g5225	i0	77.9	0.99390243902439	163	34	99.4	1	492	4	137	297	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	489	258	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
4431048	4431048	PRJNA631119_P_NODE_7584_length_426_cov_3.478754_g7466_i0	PRJNA631119	7584	426	3.478754	14.81949204	Lesquereusia modesta	1260108	Tubulinea	other_Eukaryota	457	7.45e-124	NTclustered	gi\|423291984\|gb\|JQ519437.1\|	1260108	g7466	i0	86.223	95.7230046948357	421	58	99	0	6	426	792	372	Lesquereusia modesta clone JG10.65_a1 actin gene, partial cds	blastn	40778	457	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Lesquereusiidae	Lesquereusia	Lesquereusia modesta
23555873	23555873	PRJNA631119_P_NODE_4399_length_533_cov_3.604348_g4284_i0	PRJNA631119	4399	533	3.604348	19.21117484	Copromyxa protea	931554	Tubulinea	other_Eukaryota	453	1.23e-122	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g4284	i0	83.232	17.2739212007505	495	81	93	2	9	502	494	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	9207	453	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
24829491	24829491	PRJNA631119_P_NODE_28560_length_259_cov_1.403226_g28442_i0	PRJNA631119	28560	259	1.403226	3.63435534	Amoeba proteus	5775	Tubulinea	other_Eukaryota	130	4.279999999999999e-34	NR	AAD37351.1	5775	g28442	i0	79	0.938223938223938	81	17	93.8	0	254	12	122	202	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	243	130	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26637647	26637647	PRJNA631119_P_NODE_22801_length_283_cov_1.438095_g22683_i0	PRJNA631119	22801	283	1.438095	4.06980885	Amoeba proteus	5775	Tubulinea	other_Eukaryota	105	3.9e-24	NR	AAD33718.1	5775	g22683	i0	61.3	0.985865724381625	93	36	98.6	0	281	3	782	874	AAD33718.1 myosin heavy chain [Amoeba proteus]	diamond	279	105	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32103992	32103992	PRJNA631119_P_NODE_15698_length_324_cov_2.928287_g15580_i0	PRJNA631119	15698	324	2.928287	9.48764988	Copromyxa protea	931554	Tubulinea	other_Eukaryota	110	1.09e-25	NR	BAN33737.1	931554	g15580	i0	90	0.555555555555556	60	6	55.6	0	1	180	405	464	BAN33737.1 elongation factor-like protein [Copromyxa protea]	diamond	180	110	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
32653774	32653774	PRJNA631119_P_NODE_24080_length_277_cov_2.250000_g23962_i0	PRJNA631119	24080	277	2.25	6.2325	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.3	1.56e-15	NR	AAD37352.1	5775	g23962	i0	57.7	2.74007220216606	71	24	76.9	3	213	1	344	408	AAD37352.1 pepstatin-insensitive carboxyl proteinase 2, partial [Amoeba proteus]	diamond	759	81.3	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);;