metadata: contig_metadata: 5 rows where bioproject = "PRJNA1025141" and tax

5 rows where bioproject = "PRJNA1025141" 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
1437518	1437518	PRJNA1025141_P_NODE_2182_length_556_cov_1.296066_g2122_i0	PRJNA1025141	2182	556	1.296066	7.20612696	Blastocladiella emersonii	4808	Fungi	Fungi	364	6.189999999999998e-96	NTclustered	gi\|91242961\|gb\|DQ454112.1\|	4808	g2122	i0	80.122	72.5179856115108	493	95	88	3	67	556	849	357	Blastocladiella emersonii heat shock protein Hsp70-7 mRNA, partial cds	blastn	40320	364	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
2713253	2713253	PRJNA1025141_P_NODE_6863_length_304_cov_1.333333_g6802_i0	PRJNA1025141	6863	304	1.333333	4.05333232	Allomyces arbusculus	64504	Fungi	Fungi	158	2.7299999999999998e-46	NR	KAJ3366916.1	64504	g6802	i0	74.3	0.996710526315789	101	26	99.7	0	303	1	3	103	KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus]	diamond	303	158	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
15465485	15465485	PRJNA1025141_P_NODE_1053_length_805_cov_2.030055_g1003_i0	PRJNA1025141	1053	805	2.030055	16.34194275	Blastocladiella emersonii ATCC 22665	1313167	Fungi	Fungi	179	7.569999999999999e-48	NR	KAI9183267.1	1313167	g1003	i0	44.4	4.05465838509317	248	127	89.8	5	803	81	180	423	KAI9183267.1 Protein phosphatase PP2A regulatory subunit B [Blastocladiella emersonii ATCC 22665]	diamond	3264	179	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
27406638	27406638	PRJNA1025141_P_NODE_7003_length_300_cov_2.643172_g6942_i0	PRJNA1025141	7003	300	2.643172	7.929516	Allomyces	28581	Fungi	Fungi	78.6	1.69e-14	NR	KAJ3376117.1	64504	g6942	i0	38.8	4.12	103	59	100	3	1	300	7	108	KAJ3376117.1 hypothetical protein GGF31_000184 [Allomyces arbusculus]	diamond	1236	78.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
29087839	29087839	PRJNA1025141_P_NODE_12028_length_244_cov_0.900585_g11967_i0	PRJNA1025141	12028	244	0.900585	2.1974274	Coelomomyces lativittatus	945690	Fungi	Fungi	56.6	4.8e-7	NR	KAJ1503898.1	945690	g11967	i0	40	1.35245901639344	55	33	67.6	0	40	204	359	413	KAJ1503898.1 hypothetical protein HMI54_007641 [Coelomomyces lativittatus]	diamond	330	56.6	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Coelomomycetaceae	Coelomomyces	Coelomomyces lativittatus

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