metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB81463" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB81463" 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
4825461	4825461	PRJEB81463_P_NODE_8144_length_352_cov_2.118280_g7872_i0	PRJEB81463	8144	352	2.11828	7.4563456	Allomyces arbusculus	64504	Fungi	Fungi	151	2.7199999999999993e-43	NR	KAJ3366916.1	64504	g7872	i0	63.7	0.963068181818182	113	41	96.3	0	340	2	1	113	KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus]	diamond	339	151	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
27571397	27571397	PRJEB81463_P_NODE_10244_length_315_cov_2.061983_g9972_i0	PRJEB81463	10244	315	2.061983	6.49524645	Allomyces macrogynus ATCC 38327	578462	Fungi	Fungi	110	4.91e-26	NR	KNE54594.1	578462	g9972	i0	48.5	0.980952380952381	103	51	98.1	1	314	6	218	318	KNE54594.1 hypothetical protein AMAG_00559 [Allomyces macrogynus ATCC 38327]	diamond	309	110	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
27698105	27698105	PRJEB81463_P_NODE_7724_length_361_cov_3.885417_g7452_i0	PRJEB81463	7724	361	3.885417	14.02635537	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	136	1.06e-35	NR	KAI9175415.1	1313167	g7452	i0	63.6	0.822714681440443	99	36	82.3	0	297	1	127	225	KAI9175415.1 hypothetical protein H9P43_006776 [Blastocladiella emersonii ATCC 22665]	diamond	297	136	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
29024213	29024213	PRJEB81463_P_NODE_2628_length_621_cov_1.419708_g2363_i0	PRJEB81463	2628	621	1.419708	8.81638668	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	174	1.08e-49	NR	KAI9189101.1	1313167	g2363	i0	47.6	9.27536231884058	187	88	88.9	3	611	60	126	305	KAI9189101.1 ADP/ATP carrier protein [Blastocladiella emersonii ATCC 22665]	diamond	5760	174	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
30982325	30982325	PRJEB81463_P_NODE_20574_length_252_cov_2.441341_g20302_i0	PRJEB81463	20574	252	2.441341	6.15217932	Paraphysoderma sedebokerense	1500003	Fungi	Fungi	120	2.24e-32	NR	KAI9139274.1	1500003	g20302	i0	67.5	0.988095238095238	83	26	97.6	1	246	1	4	86	KAI9139274.1 ribosomal L18ae/LX protein domain-containing protein [Paraphysoderma sedebokerense]	diamond	249	120	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Physodermatomycetes	Physodermatales	Physodermataceae	Paraphysoderma	Paraphysoderma sedebokerense
31607207	31607207	PRJEB81463_P_NODE_19216_length_256_cov_3.202186_g18944_i0	PRJEB81463	19216	256	3.202186	8.19759616	Fungi	4751	Fungi	Fungi	108	1.31e-28	NR	KAI9221418.1	64508	g18944	i0	62.4	28.86328125	85	32	99.6	0	256	2	23	107	KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica]	diamond	7389	108	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella britannica
32025808	32025808	PRJEB81463_P_NODE_17658_length_264_cov_1.204188_g17386_i0	PRJEB81463	17658	264	1.204188	3.17905632	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	100	2e-23	NR	KAI9179977.1	1313167	g17386	i0	52.8	2.03409090909091	89	41	100	1	264	1	206	294	KAI9179977.1 Arp complex subunit [Blastocladiella emersonii ATCC 22665]	diamond	537	100	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
32878492	32878492	PRJEB81463_P_NODE_20980_length_252_cov_0.871508_g20708_i0	PRJEB81463	20980	252	0.871508	2.19620016	Catenaria anguillulae PL171	765915	Fungi	Fungi	94.7	1.7100000000000003e-21	NR	ORZ31606.1	765915	g20708	i0	57.1	1	84	35	98.8	1	2	250	139	222	ORZ31606.1 ribosomal protein S3Ae [Catenaria anguillulae PL171]	diamond	252	94.7	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);;