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

5 rows where bioproject = "PRJNA404067", tax_clade = "Opisthokonta" and tax_phylum = "Mucoromycota"

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
8068182	8068182	PRJNA404067_P_NODE_42987_length_181_cov_11.500000_g42600_i0	PRJNA404067	42987	181	11.5	20.815	Mucor velutinosus	708070	Fungi	Fungi	82.4	1.96e-11	NTclustered	gi\|2724940447\|ref\|XM_064822572.1\|	708070	g42600	i0	84.337	5.92817679558011	83	13	46	0	1	83	302	384	Mucor velutinosus pseudouridine synthase pus4 (PUS4), partial mRNA	blastn	1073	82.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
19540386	19540386	PRJNA404067_P_NODE_26736_length_218_cov_2.796178_g26349_i0	PRJNA404067	26736	218	2.796178	6.09566804	Rhizophagus irregularis	588596	Fungi	Fungi	65.1	3.79e-12	NR	PKB93886.1	588596	g26349	i0	67.4	0.63302752293578	46	15	63.3	0	3	140	5	50	PKB93886.1 hypothetical protein RhiirA5_303674, partial [Rhizophagus irregularis]	diamond	138	65.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
19540628	19540628	PRJNA404067_P_NODE_39876_length_197_cov_17.143411_g39489_i0	PRJNA404067	39876	197	17.143411	33.77251967	Cokeromyces recurvatus	90255	Fungi	Fungi	152	1.64e-32	NTclustered	gi\|2324061888\|ref\|XM_051531209.1\|	90255	g39489	i0	83.537	81.2893401015228	164	25	83	2	1	163	498	660	Cokeromyces recurvatus 60S ribosomal protein L2 (BX663DRAFT_550341), partial mRNA	blastn	16014	152	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
20207308	20207308	PRJNA404067_P_NODE_10976_length_324_cov_2.604563_g10591_i0	PRJNA404067	10976	324	2.604563	8.43878412	Fungi	4751	Fungi	Fungi	582	8.729999999999998e-162	NTclustered	gi\|1694443677\|ref\|NG_065498.1\|	4841	g10591	i0	99.077	100.320987654321	325	2	100	1	1	324	1103	779	Mucor racemosus NRRL 3640 18S rRNA gene, partial sequence; from TYPE material	blastn	32504	582	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
30960173	30960173	PRJNA404067_P_NODE_31514_length_209_cov_0.864865_g31127_i0	PRJNA404067	31514	209	0.864865	1.80756785	Rhizophagus irregularis	588596	Fungi	Fungi	47	7.18e-4	NR	PKC72021.1	588596	g31127	i0	42.9	0.904306220095694	63	32	90.4	2	193	5	96	154	PKC72021.1 F-actin capping protein, alpha subunit [Rhizophagus irregularis]	diamond	189	47	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis

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