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

9 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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
2880278	2880278	PRJNA1204310_P_NODE_43623_length_280_cov_2.927536_g43326_i0	PRJNA1204310	43623	280	2.927536	8.1971008	Fimicolochytrium jonesii	1396493	Fungi	Fungi	106	1.95e-18	NTclustered	gi\|2432058563\|ref\|XM_053065718.1\|	1396493	g43326	i0	78.824	15.3785714285714	170	27	60	7	55	221	255	92	Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA	blastn	4306	106	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
6707182	6707182	PRJNA1204310_P_NODE_43886_length_279_cov_2.597087_g43589_i0	PRJNA1204310	43886	279	2.597087	7.24587273	Fimicolochytrium jonesii	1396493	Fungi	Fungi	148	3.19e-31	NTclustered	gi\|2432090693\|ref\|XM_053070959.1\|	1396493	g43589	i0	78.049	70.6989247311828	246	46	87	8	1	242	331	90	Fimicolochytrium jonesii 40S ribosomal protein S15 (EV422DRAFT_538211), mRNA	blastn	19725	148	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
11807566	11807566	PRJNA1204310_P_NODE_26090_length_361_cov_1.354167_g25793_i0	PRJNA1204310	26090	361	1.354167	4.88854287	Polychytrium aggregatum	110093	Fungi	Fungi	289	2.3999999999999994e-73	NTclustered	gi\|2432131711\|ref\|XM_053109357.1\|	110093	g25793	i0	82.477	81.9722991689751	331	56	91	2	1	330	462	133	Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA	blastn	29592	289	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
11807713	11807713	PRJNA1204310_P_NODE_31970_length_330_cov_1.151751_g31673_i0	PRJNA1204310	31970	330	1.151751	3.8007783	Polychytrium aggregatum	110093	Fungi	Fungi	180	1.3699999999999996e-40	NTclustered	gi\|2432162630\|ref\|XM_053112000.1\|	110093	g31673	i0	78.472	41.8393939393939	288	52	87	6	34	319	523	244	Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA	blastn	13807	180	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
13082703	13082703	PRJNA1204310_P_NODE_30951_length_335_cov_1.190840_g30654_i0	PRJNA1204310	30951	335	1.19084	3.989314	Fimicolochytrium jonesii	1396493	Fungi	Fungi	219	2.9399999999999992e-52	NTclustered	gi\|2432111638\|ref\|XM_053071593.1\|	1396493	g30654	i0	81.022	15.8417910447761	274	52	82	0	1	274	411	684	Fimicolochytrium jonesii 40S ribosomal protein S2 (EV422DRAFT_547289), mRNA	blastn	5307	219	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
13083518	13083518	PRJNA1204310_P_NODE_8931_length_583_cov_5.931373_g8642_i0	PRJNA1204310	8931	583	5.931373	34.57990459	Fimicolochytrium jonesii	1396493	Fungi	Fungi	303	1.44e-77	NTclustered	gi\|2432072949\|ref\|XM_053073468.1\|	1396493	g8642	i0	79.31	63.3447684391081	435	88	74	2	70	503	680	247	Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA	blastn	36930	303	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
14357602	14357602	PRJNA1204310_P_NODE_11532_length_517_cov_7.797297_g11235_i0	PRJNA1204310	11532	517	7.797297	40.31202549	Polychytrium aggregatum	110093	Fungi	Fungi	246	2.16e-60	NTclustered	gi\|2432155310\|ref\|XM_053111519.1\|	110093	g11235	i0	79.714	12.715667311412	350	63	67	8	92	437	420	75	Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA	blastn	6574	246	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
18180622	18180622	PRJNA1204310_P_NODE_28635_length_347_cov_0.937956_g28338_i0	PRJNA1204310	28635	347	0.937956	3.25470732	Polychytrium aggregatum	110093	Fungi	Fungi	174	6.72e-39	NTclustered	gi\|2432132317\|ref\|XM_053107399.1\|	110093	g28338	i0	77.441	2.70605187319885	297	63	85	4	53	347	2262	1968	Polychytrium aggregatum Glutamate/Leucine/Phenylalanine/Valine dehydrogenase-domain-containing protein (BJ171DRAFT_419602), partial mRNA	blastn	939	174	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
19454720	19454720	PRJNA1204310_P_NODE_11716_length_514_cov_2.188209_g11419_i0	PRJNA1204310	11716	514	2.188209	11.24739426	Polychytrium aggregatum	110093	Fungi	Fungi	302	4.53e-77	NTclustered	gi\|2432171462\|ref\|XM_053112561.1\|	110093	g11419	i0	79.56	71.7937743190661	455	67	86	22	73	514	2132	1691	Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA	blastn	36902	302	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);;