metadata: contig_metadata: 4 rows where bioproject = "PRJNA763243", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA763243", tax_kingdom = "Fungi" 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
27021590	27021590	PRJNA763243_P_NODE_69222_length_224_cov_8.529801_g68876_i0	PRJNA763243	69222	224	8.529801	19.10675424	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	101	4.439999999999999e-23	NR	KAI9188411.1	1313167	g68876	i0	67.2	1.80803571428571	67	22	89.7	0	5	205	69	135	KAI9188411.1 bifunctional farnesyl-diphosphate farnesyltransferase/squalene synthase [Blastocladiella emersonii ATCC 22665]	diamond	405	101	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
28316509	28316509	PRJNA763243_P_NODE_26026_length_318_cov_2.004082_g25680_i0	PRJNA763243	26026	318	2.004082	6.37298076	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	83.2	1.05e-17	NR	KAI9138745.1	1500003	g25680	i0	42	0.943396226415094	100	52	94.3	3	312	13	32	125	KAI9138745.1 hypothetical protein BKA69DRAFT_748852 [Paraphysoderma sedebokerense]	diamond	300	83.2	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
30726254	30726254	PRJNA763243_P_NODE_18034_length_369_cov_1.408784_g17689_i0	PRJNA763243	18034	369	1.408784	5.19841296	Blastocladiaceae	4806	Fungi	Fungi	125	2.44e-34	NR	KAI9222680.1	64508	g17689	i0	61.7	2.69105691056911	107	41	87	0	322	2	3	109	KAI9222680.1 translation protein SH3-like domain-containing protein, partial [Blastocladiella britannica]	diamond	993	125	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
32613965	32613965	PRJNA763243_P_NODE_40860_length_274_cov_71.213930_g40514_i0	PRJNA763243	40860	274	71.21393	195.1261682	Catenaria anguillulae PL171	765915	Fungi	Fungi	169	1.89e-52	NR	ORZ34836.1	765915	g40514	i0	94.3	1.89416058394161	87	5	95.3	0	273	13	23	109	ORZ34836.1 hypothetical protein BCR44DRAFT_30883, partial [Catenaria anguillulae PL171]	diamond	519	169	1	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);;