metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax

5 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_phylum = "Discosea"

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_order	tax_family	tax_genus	tax_species
27569605	27569605	PRJDB9741_P_NODE_15024_length_186_cov_3.291971_g14707_i0	PRJDB9741	15024	186	3.291971	6.12306606	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	79.7	8.07e-16	NR	XP_004356622.1	1257118	g14707	i0	57.6	0.951612903225806	59	25	95.2	0	184	8	31	89	XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff]	diamond	177	79.7	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29243134	29243134	PRJDB9741_P_NODE_15549_length_186_cov_1.036496_g15232_i0	PRJDB9741	15549	186	1.036496	1.92788256	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47.4	4.03e-4	NR	XP_004333857.1	1257118	g15232	i0	39.1	1.03225806451613	64	34	100	2	186	1	233	293	XP_004333857.1 uncharacterized protein ACA1_272950, partial [Acanthamoeba castellanii str. Neff]	diamond	192	47.4	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29274499	29274499	PRJDB9741_P_NODE_7629_length_227_cov_2.292135_g7312_i0	PRJDB9741	7629	227	2.292135	5.20314645	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	79.7	4.49e-17	NR	1F2K_A	5755	g7312	i0	74.5	1.34801762114537	51	13	67.4	0	226	74	75	125	1F2K_A Chain A, PROFILIN II [Acanthamoeba castellanii]	diamond	306	79.7	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29463695	29463695	PRJDB9741_P_NODE_37990_length_162_cov_0.902655_g37673_i0	PRJDB9741	37990	162	0.902655	1.4623011	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	108	5.33e-28	NR	XP_004334642.1	1257118	g37673	i0	92.5	0.981481481481482	53	4	98.1	0	3	161	47	99	XP_004334642.1 Ras family GTPase [Acanthamoeba castellanii str. Neff]	diamond	159	108	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32498827	32498827	PRJDB9741_P_NODE_5619_length_266_cov_1.175115_g5303_i0	PRJDB9741	5619	266	1.175115	3.1258059	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	134	3.69e-35	NR	XP_004334520.1	1257118	g5303	i0	67.8	0.981203007518797	87	28	98.1	0	264	4	301	387	XP_004334520.1 CMF receptor CMFR1, putative [Acanthamoeba castellanii str. Neff]	diamond	261	134	1	Eukaryota	Amoebozoa	Discosea	Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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