metadata: contig_metadata: 5 rows where bioproject = "PRJNA683902", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA683902", tax_clade = "Opisthokonta" 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
9593894	9593894	PRJNA683902_S_NODE_22468_length_218_cov_8.972376_g22024_i0	PRJNA683902	22468	218	8.972376	19.55977968	Gromochytrium mamkaevae	1486924	Fungi	Fungi	104	5.25e-18	NTclustered	gi\|612507318\|gb\|KF586842.1\|	1486924	g22024	i0	94.118	10.0779816513761	68	4	31	0	3	70	6198	6131	Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	2197	104	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Gromochytriales	Gromochytriaceae	Gromochytrium	Gromochytrium mamkaevae
28282094	28282094	PRJNA683902_S_NODE_10466_length_437_cov_3.925000_g10025_i0	PRJNA683902	10466	437	3.925	17.15225	Powellomyces hirtus	109895	Fungi	Fungi	133	5.959999999999999e-37	NR	KAI8920797.1	109895	g10025	i0	66.7	2.01830663615561	99	33	68	0	437	141	26	124	KAI8920797.1 ribosomal protein S27a, partial [Powellomyces hirtus]	diamond	882	133	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
29588141	29588141	PRJNA683902_S_NODE_19410_length_244_cov_3.454106_g18966_i0	PRJNA683902	19410	244	3.454106	8.42801864	root	1	Root_unresolved	Root_unresolved	67	1.29e-11	NR	KAJ3045844.1	64517	g18966	i0	52.2	2.44672131147541	69	32	84.8	1	244	38	90	157	KAJ3045844.1 Histone H2AX [Rhizophlyctis rosea]	diamond	597	67.4	0.99406528189911	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
32010452	32010452	PRJNA683902_S_NODE_22238_length_220_cov_2.322404_g21794_i0	PRJNA683902	22238	220	2.322404	5.1092888	Polyrhizophydium stewartii	2732419	Fungi	Fungi	92.8	2.98e-22	NR	KAL2916487.1	2732419	g21794	i0	67.6	0.968181818181818	71	21	96.8	1	213	1	29	97	KAL2916487.1 60S ribosomal protein L26A [Polyrhizophydium stewartii]	diamond	213	92.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii
32105310	32105310	PRJNA683902_S_NODE_28438_length_185_cov_1.554054_g27994_i0	PRJNA683902	28438	185	1.554054	2.8749999	Irineochytrium annulatum	109884	Fungi	Fungi	81.3	4.49e-16	NR	KAJ3194857.1	109884	g27994	i0	64.1	5.87027027027027	64	20	98.9	1	3	185	409	472	KAJ3194857.1 T-complex protein 1 subunit theta [Irineochytrium annulatum]	diamond	1086	81.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Irineochytrium	Irineochytrium annulatum

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