metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA597223" 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
3692083	3692083	PRJNA597223_P_NODE_163_length_2992_cov_15.492729_g100_i0	PRJNA597223	163	2992	15.492729	463.54245168	Opisthokonta	33154	Fungi	Fungi	80.5	1.43e-9	NTclustered	gi\|57116339\|gb\|AY847625.1\|	4847	g100	i0	82.609	0.584558823529412	92	14	3	2	822	912	894	984	Rhizopus microsporus var. oligosporus 28S ribosomal RNA gene, partial sequence; 28S-18S intergenic spacer, complete sequence; and 18S ribosomal RNA gene, partial sequence	blastn	1749	80.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
6947692	6947692	PRJNA597223_P_NODE_73526_length_166_cov_0.938931_g71680_i0	PRJNA597223	73526	166	0.938931	1.55862546	Gilbertella persicaria	101096	Fungi	Fungi	169	1.32e-37	NTclustered	gi\|2323767062\|ref\|XM_051580778.1\|	101096	g71680	i0	85.366	69.6385542168675	164	22	98	2	2	164	1780	1618	Gilbertella persicaria transitional endoplasmic reticulum ATPase (B0P05DRAFT_563993), mRNA	blastn	11560	169	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
13894884	13894884	PRJNA597223_P_NODE_80871_length_157_cov_1.065574_g79025_i0	PRJNA597223	80871	157	1.065574	1.67295118	Gigasporaceae	36753	Fungi	Fungi	84.2	4.59e-12	NTclustered	gi\|658131649\|emb\|HF968975.1\|	4874	g79025	i0	96.078	10.0828025477707	51	2	32	0	1	51	2202	2152	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 3, clone BL2_4_2	blastn	1583	84.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
15168839	15168839	PRJNA597223_P_NODE_38152_length_233_cov_2.742424_g36306_i0	PRJNA597223	38152	233	2.742424	6.38984792	Mucor	4830	Fungi	Fungi	346	8.54e-91	NTclustered	gi\|2647494356\|gb\|PP111974.1\|	97098	g36306	i0	96.635	85.725321888412	208	7	89	0	1	208	210	3	Mucor plumbeus isolate CCF 2991 large subunit ribosomal RNA gene, partial sequence	blastn	19974	346	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
15168983	15168983	PRJNA597223_P_NODE_78052_length_160_cov_1.504000_g76206_i0	PRJNA597223	78052	160	1.504	2.4064	Mucor	4830	Fungi	Fungi	296	5.55e-76	NTclustered	gi\|168378\|gb\|M26190.1\|MRARRHA	4841	g76206	i0	100	15.9625	160	0	100	0	1	160	2121	1962	M.racemosus (Zygomycetes) 25S ribosomal RNA gene	blastn	2554	296	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
20971257	20971257	PRJNA597223_P_NODE_32117_length_262_cov_2.444934_g30271_i0	PRJNA597223	32117	262	2.444934	6.40572708	Rhizomucor pusillus	4840	Fungi	Fungi	100	8.42e-17	NTclustered	gi\|2837748244\|ref\|XM_069380414.1\|	4840	g30271	i0	93.939	3.97328244274809	66	4	25	0	196	261	660	595	Rhizomucor pusillus 40S ribosomal uS13 domain-containing protein (VTP01DRAFT_2000), partial mRNA	blastn	1041	100	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
23521257	23521257	PRJNA597223_P_NODE_22539_length_334_cov_10.882943_g20697_i0	PRJNA597223	22539	334	10.882943	36.34902962	Mucor racemosus	4841	Fungi	Fungi	427	4.48e-115	NTclustered	gi\|225134681\|gb\|FJ345353.1\|	4841	g20697	i0	92.157	49.4700598802395	306	12	91	6	31	333	3679	3975	Mucor racemosus strain ATCC 42647 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	16523	427	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
24092680	24092680	PRJNA597223_P_NODE_43859_length_213_cov_3.078652_g42013_i0	PRJNA597223	43859	213	3.078652	6.55752876	Fungi	4751	Fungi	Fungi	182	2.29e-41	NTclustered	gi\|358001175\|gb\|JN938898.1\|	4841	g42013	i0	100	90.4788732394366	98	0	91	0	116	213	452	355	Mucor racemosus strain DAOM 229663 28S ribosomal RNA (LSU) gene, partial sequence	blastn	19272	182	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus
25366964	25366964	PRJNA597223_P_NODE_19500_length_368_cov_2.393393_g17672_i0	PRJNA597223	19500	368	2.393393	8.80768624	Fungi	4751	Fungi	Fungi	649	0	NTclustered	gi\|1694443677\|ref\|NG_065498.1\|	4841	g17672	i0	99.718	96.1875	354	1	96	0	7	360	572	925	Mucor racemosus NRRL 3640 18S rRNA gene, partial sequence; from TYPE material	blastn	35397	649	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor racemosus

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