metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax_phylum = "Chytridiomycota"

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
5993678	5993678	PRJNA908278_P_NODE_6665_length_456_cov_2.221932_g6562_i0	PRJNA908278	6665	456	2.221932	10.13200992	Polychytrium aggregatum	110093	Fungi	Fungi	54.7	0.012	NTclustered	gi\|2432144566\|ref\|XM_053115345.1\|	110093	g6562	i0	100	0.0635964912280702	29	0	6	0	372	400	553	581	Polychytrium aggregatum ran-specific GTPase-activating protein (BJ171DRAFT_616054), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
8543104	8543104	PRJNA908278_P_NODE_14987_length_325_cov_1.460317_g14884_i0	PRJNA908278	14987	325	1.460317	4.74603025	Polychytrium aggregatum	110093	Fungi	Fungi	239	2.18e-58	NTclustered	gi\|2432132805\|ref\|XM_053109589.1\|	110093	g14884	i0	85.841	13.8276923076923	226	30	69	2	2	226	435	659	Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_490208), mRNA	blastn	4494	239	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
8901941	8901941	PRJNA908278_P_NODE_18767_length_295_cov_1.734234_g18664_i0	PRJNA908278	18767	295	1.734234	5.1159903	Fungi	4751	Fungi	Fungi	89.8	2.09e-13	NTclustered	gi\|2432164996\|ref\|XM_053112147.1\|	110093	g18664	i0	74.231	36.4610169491525	260	45	83	18	18	263	408	157	Polychytrium aggregatum 60S acidic ribosomal protein P2 (BJ171DRAFT_517561), mRNA	blastn	10756	89.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
14918192	14918192	PRJNA908278_P_NODE_16572_length_312_cov_1.158996_g16469_i0	PRJNA908278	16572	312	1.158996	3.61606752	Polychytrium aggregatum	110093	Fungi	Fungi	313	1.21e-80	NTclustered	gi\|2432142886\|ref\|XM_053110559.1\|	110093	g16469	i0	85.43	93.0641025641026	302	42	96	2	1	301	337	37	Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA	blastn	29036	313	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
17468751	17468751	PRJNA908278_P_NODE_8274_length_414_cov_3.387097_g8171_i0	PRJNA908278	8274	414	3.387097	14.02258158	Synchytrium sp.	1971732	Fungi	Fungi	104	1.08e-17	NTclustered	gi\|1168020523\|gb\|KY800404.1\|	1971732	g8171	i0	78.528	0.393719806763285	163	31	39	4	30	190	1066	906	Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence	blastn	163	104	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium sp.
22567387	22567387	PRJNA908278_P_NODE_24958_length_259_cov_1.258065_g24855_i0	PRJNA908278	24958	259	1.258065	3.25838835	Polychytrium aggregatum	110093	Fungi	Fungi	222	1.6999999999999998e-53	NTclustered	gi\|2432129762\|ref\|XM_053108984.1\|	110093	g24855	i0	82.308	51.0656370656371	260	42	99	4	1	258	326	69	Polychytrium aggregatum 60S ribosomal protein L37 (BJ171DRAFT_484391), mRNA	blastn	13226	222	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
23842614	23842614	PRJNA908278_P_NODE_35639_length_241_cov_0.916667_g35536_i0	PRJNA908278	35639	241	0.916667	2.20916747	Polychytrium aggregatum	110093	Fungi	Fungi	191	4.41e-44	NTclustered	gi\|2432145138\|ref\|XM_053110794.1\|	110093	g35536	i0	80.992	17.207468879668	242	44	100	2	1	241	561	321	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA	blastn	4147	191	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
25116253	25116253	PRJNA908278_P_NODE_18220_length_299_cov_1.407080_g18117_i0	PRJNA908278	18220	299	1.40708	4.2071692	Polychytrium aggregatum	110093	Fungi	Fungi	335	2.47e-87	NTclustered	gi\|2432171462\|ref\|XM_053112561.1\|	110093	g18117	i0	87.543	79.9866220735786	289	36	97	0	9	297	1774	2062	Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA	blastn	23916	335	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
25116254	25116254	PRJNA908278_P_NODE_18600_length_296_cov_3.053812_g18497_i0	PRJNA908278	18600	296	3.053812	9.03928352	Polychytrium aggregatum	110093	Fungi	Fungi	89.8	2.09e-13	NTclustered	gi\|2432158676\|ref\|XM_053113190.1\|	110093	g18497	i0	93.333	16.4695945945946	60	4	20	0	132	191	129	70	Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA	blastn	4875	89.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum

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