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

5 rows where analysis = "diamond", bioproject = "PRJNA573544" and tax_clade = "Opisthokonta"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27314530	27314530	PRJNA573544_P_NODE_4503_length_273_cov_1.235000_g4485_i0	PRJNA573544	4503	273	1.235	3.37155	Cryptococcus	5206	Fungi	Fungi	89.4	2.14e-18	NR	OXG99136.1	1230057	g4485	i0	63.8	1.91208791208791	58	21	63.7	0	175	2	110	167	OXG99136.1 flavin-containing monooxygenase [Cryptococcus neoformans var. grubii A2-102-5]	diamond	522	89.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus neoformans
28027156	28027156	PRJNA573544_P_NODE_7845_length_243_cov_0.917647_g7827_i0	PRJNA573544	7845	243	0.917647	2.22988221	Jaminaea rosea	1569628	Fungi	Fungi	79	6.7e-15	NR	XP_025364911.1	1569628	g7827	i0	71.4	0.864197530864197	70	14	81.5	3	198	1	8	75	XP_025364911.1 MFS general substrate transporter [Jaminaea rosea]	diamond	210	79	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Jaminaea	Jaminaea rosea
30742991	30742991	PRJNA573544_P_NODE_7554_length_244_cov_0.912281_g7536_i0	PRJNA573544	7554	244	0.912281	2.22596564	Extremus antarcticus	702011	Fungi	Fungi	96.3	5e-21	NR	KAK3057624.1	702011	g7536	i0	62.5	0.983606557377049	80	29	98.4	1	5	244	4	82	KAK3057624.1 transcriptional regulator opi1 [Extremus antarcticus]	diamond	240	96.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Extremaceae	Extremus	Extremus antarcticus
31104033	31104033	PRJNA573544_P_NODE_6195_length_249_cov_1.437500_g6177_i0	PRJNA573544	6195	249	1.4375	3.579375	Cotesia	32390	Arthropoda	Arthropoda	80.9	8.74e-17	NR	XP_044574885.1	32391	g6177	i0	60	5.06024096385542	70	26	84.3	2	248	39	118	185	XP_044574885.1 peroxiredoxin-5, mitochondrial [Cotesia glomerata]	diamond	1260	80.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Cotesia	Cotesia glomerata
31691366	31691366	PRJNA573544_P_NODE_6577_length_248_cov_0.891429_g6559_i0	PRJNA573544	6577	248	0.891429	2.21074392	Parastagonospora nodorum SN15	321614	Fungi	Fungi	120	1.07e-29	NR	XP_001794956.1	321614	g6559	i0	82.2	0.883064516129032	73	13	88.3	0	220	2	291	363	XP_001794956.1 hypothetical protein SNOG_04541 [Parastagonospora nodorum SN15]	diamond	219	120	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Parastagonospora	Parastagonospora nodorum

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