metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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
3573688	3573688	PRJNA1112809_P_NODE_127823_length_287_cov_1.378505_g124548_i0	PRJNA1112809	127823	287	1.378505	3.95630935	Glomus	4875	Fungi	Fungi	100	9.34e-17	NTclustered	gi\|345452158\|gb\|HQ243244.1\|	231055	g124548	i0	91.667	22.6271777003484	72	6	25	0	216	287	825	754	Uncultured Glomus clone ZHwq2-452 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	6494	100	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae		uncultured Glomus
4045632	4045632	PRJNA1112809_P_NODE_113244_length_307_cov_1.837607_g109969_i0	PRJNA1112809	113244	307	1.837607	5.64145349	Halteromyces radiatus	101107	Fungi	Fungi	241	5.7e-59	NTclustered	gi\|2323751319\|ref\|XM_051546666.1\|	101107	g109969	i0	85.408	26.0814332247557	233	32	76	2	12	243	329	98	Halteromyces radiatus ribosomal protein S11-domain-containing protein (BX664DRAFT_339592), mRNA	blastn	8007	241	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
15522450	15522450	PRJNA1112809_P_NODE_167633_length_250_cov_0.870056_g164358_i0	PRJNA1112809	167633	250	0.870056	2.17514	Rhizopus delemar	936053	Fungi	Fungi	143	1.31e-29	NTclustered	gi\|2797406789\|ref\|XM_067655435.1\|	246409	g164358	i0	77.551	6.576	245	49	97	6	2	243	242	1	Rhizopus delemar RA 99-880 40S ribosomal protein S13 (RO3G_00844), partial mRNA	blastn	1644	143	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
18875306	18875306	PRJNA1112809_P_NODE_82615_length_374_cov_3.720930_g79340_i0	PRJNA1112809	82615	374	3.72093	13.9162782	Glomeraceae	36751	Fungi	Fungi	662	0	NTclustered	gi\|373809267\|emb\|FR871384.1\|	231055	g79340	i0	98.66	99.9090909090909	373	5	99	0	2	374	373	1	Uncultured Glomus partial 28S rRNA gene, clone BROS1-5	blastn	37366	664	0.996987951807229	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae		uncultured Glomus
25249985	25249985	PRJNA1112809_P_NODE_95640_length_340_cov_2.520599_g92365_i0	PRJNA1112809	95640	340	2.520599	8.5700366	Eukaryota	2759	Fungi	Fungi	573	5.54e-159	NTclustered	gi\|373809260\|emb\|FR871377.1\|	231055	g92365	i0	97.885	96.1264705882353	331	7	97	0	10	340	331	1	Uncultured Glomus partial 28S rRNA gene, clone BROS4-5	blastn	32683	573	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae		uncultured Glomus

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