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

9 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax_phylum = "Blastocladiomycota"

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
1252932	1252932	PRJNA928559_P_NODE_200581_length_248_cov_0.891429_g199012_i0	PRJNA928559	200581	248	0.891429	2.21074392	Eukaryota	2759	Fungi	Fungi	124	2.11e-34	NR	KAJ3372542.1	64504	g199012	i0	70.7	50.5766129032258	82	24	99.2	0	3	248	43	124	KAJ3372542.1 Actin- protein 2/3 complex subunit 4 [Allomyces arbusculus]	diamond	12543	125	0.992	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
8556758	8556758	PRJNA928559_P_NODE_33047_length_572_cov_4.621242_g31512_i0	PRJNA928559	33047	572	4.621242	26.43350424	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	186	1.4899999999999995e-55	NR	KAI9142824.1	1500003	g31512	i0	59.3	2.86363636363636	182	54	93.4	2	3	536	94	259	KAI9142824.1 50S ribosomal protein L30e-like protein [Paraphysoderma sedebokerense]	diamond	1638	186	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
9832030	9832030	PRJNA928559_P_NODE_59108_length_452_cov_2.224274_g57541_i0	PRJNA928559	59108	452	2.224274	10.05371848	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	201	6.69e-63	NR	KAI9189827.1	1313167	g57541	i0	67.8	25.4402654867257	146	45	95.6	1	437	6	52	197	KAI9189827.1 ribosomal 40S subunit protein S13 [Blastocladiella emersonii ATCC 22665]	diamond	11499	201	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
26644732	26644732	PRJNA928559_P_NODE_211981_length_243_cov_0.917647_g210412_i0	PRJNA928559	211981	243	0.917647	2.22988221	Catenaria anguillulae PL171	765915	Fungi	Fungi	57.8	1.95e-7	NR	ORZ41021.1	765915	g210412	i0	52.5	0.753086419753086	61	26	75.3	2	240	58	713	770	ORZ41021.1 hypothetical protein BCR44DRAFT_1424220 [Catenaria anguillulae PL171]	diamond	183	57.8	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
28382812	28382812	PRJNA928559_P_NODE_144826_length_293_cov_2.404545_g143257_i0	PRJNA928559	144826	293	2.404545	7.04531685	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	92	2.5600000000000003e-21	NR	KAI9138745.1	1500003	g143257	i0	54.9	1.49488054607509	71	31	71.7	1	212	3	34	104	KAI9138745.1 hypothetical protein BKA69DRAFT_748852 [Paraphysoderma sedebokerense]	diamond	438	92	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
28737402	28737402	PRJNA928559_P_NODE_42187_length_518_cov_22.469663_g40630_i0	PRJNA928559	42187	518	22.469663	116.39285434	Fungi	4751	Fungi	Fungi	121	4.52e-32	NR	KAI9221418.1	64508	g40630	i0	59.8	3.37065637065637	97	39	56.2	0	487	197	14	110	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	1746	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
31225319	31225319	PRJNA928559_P_NODE_204135_length_246_cov_1.352601_g202566_i0	PRJNA928559	204135	246	1.352601	3.32739846	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	85.5	3.43e-17	NR	KAI9146593.1	1500003	g202566	i0	56.3	0.865853658536585	71	31	86.6	0	241	29	981	1051	KAI9146593.1 Oxysterol-binding protein-domain-containing protein [Paraphysoderma sedebokerense]	diamond	213	85.5	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
32111206	32111206	PRJNA928559_P_NODE_143138_length_295_cov_2.369369_g141569_i0	PRJNA928559	143138	295	2.369369	6.98963855	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	89.4	2.18e-18	NR	KAI9142317.1	1500003	g141569	i0	46.3	1.8	95	51	96.6	0	1	285	326	420	KAI9142317.1 peptide chain release factor eRF1/aRF1 [Paraphysoderma sedebokerense]	diamond	531	89.4	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
32245215	32245215	PRJNA928559_P_NODE_184998_length_255_cov_1.335165_g183429_i0	PRJNA928559	184998	255	1.335165	3.40467075	Fungi	4751	Fungi	Fungi	63.5	2.06e-9	NR	ORZ30937.1	765915	g183429	i0	50	3.41176470588235	64	30	75.3	1	63	254	1727	1788	ORZ30937.1 armadillo-type protein [Catenaria anguillulae PL171]	diamond	870	63.9	0.993740219092332	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae

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