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

9 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
2170480	2170480	PRJNA915212_P_NODE_10282_length_180_cov_1.557252_g10244_i0	PRJNA915212	10282	180	1.557252	2.8030536	Fimicolochytrium jonesii	1396493	Fungi	Fungi	135	1.4700000000000002e-27	NTclustered	gi\|2432057423\|ref\|XM_053069416.1\|	1396493	g10244	i0	80.556	50.4444444444444	180	32	100	2	1	180	637	461	Fimicolochytrium jonesii hsp71-like protein (EV422DRAFT_516945), mRNA	blastn	9080	135	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
2170563	2170563	PRJNA915212_P_NODE_5242_length_260_cov_2.118483_g5204_i0	PRJNA915212	5242	260	2.118483	5.5080558	Polychytrium aggregatum	110093	Fungi	Fungi	150	8.17e-32	NTclustered	gi\|2432158512\|ref\|XM_053111712.1\|	110093	g5204	i0	78.099	13.75	242	49	93	4	12	252	373	135	Polychytrium aggregatum 40S ribosomal protein S13 (BJ171DRAFT_513016), mRNA	blastn	3575	150	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
3445967	3445967	PRJNA915212_P_NODE_10883_length_174_cov_1.224000_g10845_i0	PRJNA915212	10883	174	1.224	2.12976	Polychytrium aggregatum	110093	Fungi	Fungi	134	5.08e-27	NTclustered	gi\|2432172390\|ref\|XM_053112626.1\|	110093	g10845	i0	90.196	41.264367816092	102	10	59	0	63	164	1390	1289	Polychytrium aggregatum chaperonin Cpn60/TCP-1 family (BJ171DRAFT_525041), mRNA	blastn	7180	134	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
4723652	4723652	PRJNA915212_P_NODE_1344_length_578_cov_1.415879_g1312_i0	PRJNA915212	1344	578	1.415879	8.18378062	Polychytrium aggregatum	110093	Fungi	Fungi	403	1.3699999999999994e-107	NTclustered	gi\|2432130198\|ref\|XM_053115874.1\|	110093	g1312	i0	80	81.6539792387543	550	106	95	4	30	577	1383	836	Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA	blastn	47196	403	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
9822998	9822998	PRJNA915212_P_NODE_1348_length_577_cov_3.128788_g1316_i0	PRJNA915212	1348	577	3.128788	18.05310676	Polychytrium aggregatum	110093	Fungi	Fungi	200	1.92e-46	NTclustered	gi\|2432162630\|ref\|XM_053112000.1\|	110093	g1316	i0	76.485	24.1299826689775	404	73	69	16	78	473	134	523	Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA	blastn	13923	200	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
13648812	13648812	PRJNA915212_P_NODE_9751_length_186_cov_1.109489_g9713_i0	PRJNA915212	9751	186	1.109489	2.06364954	Polychytrium aggregatum	110093	Fungi	Fungi	137	4.27e-28	NTclustered	gi\|2432132411\|ref\|XM_053109501.1\|	110093	g9713	i0	80.682	5.73118279569892	176	34	95	0	11	186	693	518	Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA	blastn	1066	137	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
14923042	14923042	PRJNA915212_P_NODE_1012_length_665_cov_2.446429_g981_i0	PRJNA915212	1012	665	2.446429	16.26875285	Polychytrium aggregatum	110093	Fungi	Fungi	383	2.069999999999999e-101	NTclustered	gi\|2432129870\|ref\|XM_053107267.1\|	110093	g981	i0	82.057	64.4902255639098	457	74	68	8	79	531	688	236	Polychytrium aggregatum ribosomal protein S7 domain-containing protein (BJ171DRAFT_4084), mRNA	blastn	42886	383	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
21297142	21297142	PRJNA915212_P_NODE_4137_length_300_cov_1.211155_g4099_i0	PRJNA915212	4137	300	1.211155	3.633465	Polychytrium aggregatum	110093	Fungi	Fungi	174	5.71e-39	NTclustered	gi\|2432142218\|ref\|XM_053114797.1\|	110093	g4099	i0	80	69.55	245	42	81	5	9	251	262	501	Polychytrium aggregatum ribosomal protein S13/S18-domain-containing protein (BJ171DRAFT_597985), partial mRNA	blastn	20865	174	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
23847424	23847424	PRJNA915212_P_NODE_4879_length_271_cov_1.927928_g4841_i0	PRJNA915212	4879	271	1.927928	5.22468488	Polychytrium aggregatum	110093	Fungi	Fungi	257	4.9100000000000005e-64	NTclustered	gi\|2432142886\|ref\|XM_053110559.1\|	110093	g4841	i0	84.151	84.09963099631	265	42	98	0	4	268	298	34	Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA	blastn	22791	257	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);;