metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax_clade = "Discoba"

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
9478080	9478080	PRJNA564013_P_NODE_240328_length_269_cov_9.182692_g237476_i0	PRJNA564013	240328	269	9.182692	24.70144148	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	150	2.6399999999999998e-40	NR	NP_066529.1	5762	g237476	i0	80.9	0.992565055762082	89	16	99.3	1	269	3	79	166	NP_066529.1 ribosomal protein S11 [Naegleria gruberi]	diamond	267	150	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
26921092	26921092	PRJNA564013_P_NODE_326042_length_210_cov_3.134228_g323190_i0	PRJNA564013	326042	210	3.134228	6.5818788	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	125	1.85e-35	NR	NP_066535.1	5762	g323190	i0	84.1	0.985714285714286	69	11	98.6	0	207	1	27	95	NP_066535.1 NADH dehydrogenase subunit 3 [Naegleria gruberi]	diamond	207	125	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28879174	28879174	PRJNA564013_P_NODE_214548_length_292_cov_8.549784_g211697_i0	PRJNA564013	214548	292	8.549784	24.96536928	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	70.1	1.55e-11	NR	XP_002676703.1	5762	g211697	i0	36.9	0.863013698630137	84	53	86.3	0	267	16	98	181	XP_002676703.1 uncharacterized protein NAEGRDRAFT_67966 [Naegleria gruberi]	diamond	252	70.1	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29398254	29398254	PRJNA564013_P_NODE_88429_length_432_cov_24.245283_g85598_i0	PRJNA564013	88429	432	24.245283	104.73962256	Naegleria	5761	Heterolobosea	other_Eukaryota	98.2	1.36e-20	NR	XP_002680550.1	5762	g85598	i0	54.5	1.83333333333333	88	40	61.1	0	278	15	466	553	XP_002680550.1 DNA dependent protein kinase catalytic subunit [Naegleria gruberi]	diamond	792	98.2	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
30693314	30693314	PRJNA564013_P_NODE_154813_length_347_cov_5.244755_g151964_i0	PRJNA564013	154813	347	5.244755	18.19929985	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	49.3	3.17e-4	NR	XP_044559438.1	5763	g151964	i0	54.5	1.30547550432277	44	20	38	0	275	144	2	45	XP_044559438.1 uncharacterized protein FDP41_006199 [Naegleria fowleri]	diamond	453	49.7	0.991951710261569	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
31343245	31343245	PRJNA564013_P_NODE_190276_length_315_cov_5.566929_g187425_i0	PRJNA564013	190276	315	5.566929	17.53582635	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	72.8	2.35e-12	NR	KAL0480953.1	1008807	g187425	i0	66	0.476190476190476	50	17	47.6	0	7	156	412	461	KAL0480953.1 hypothetical protein AKO1_013613 [Acrasis kona]	diamond	150	72.8	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31691125	31691125	PRJNA564013_P_NODE_37417_length_631_cov_5.252632_g34741_i0	PRJNA564013	37417	631	5.252632	33.14410792	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	48.1	0.0104	NR	XP_002676403.1	5762	g34741	i0	25	0.741679873217116	156	92	73.7	3	506	42	85	216	XP_002676403.1 uncharacterized protein NAEGRDRAFT_68462 [Naegleria gruberi]	diamond	468	48.1	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
31704938	31704938	PRJNA564013_P_NODE_41497_length_604_cov_3.427256_g38781_i0	PRJNA564013	41497	604	3.427256	20.70062624	Naegleria	5761	Heterolobosea	other_Eukaryota	99.8	4.3399999999999996e-23	NR	NP_066524.1	5762	g38781	i0	46.9	1.07781456953642	113	58	55.1	1	1	333	10	122	NP_066524.1 ribosomal protein L14 [Naegleria gruberi]	diamond	651	100	0.998	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32324259	32324259	PRJNA564013_P_NODE_356439_length_194_cov_2.932331_g353587_i0	PRJNA564013	356439	194	2.932331	5.68872214	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	43.1	0.0146	NR	XP_028878919.1	67003	g353587	i0	44.2	0.664948453608247	43	24	66.5	0	64	192	1229	1271	XP_028878919.1 SLACS reverse transcriptase, putative [Trypanosoma theileri]	diamond	129	43.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri

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