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

9 rows where analysis = "blastn", bioproject = "PRJNA879067" 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
2130321	2130321	PRJNA879067_P_NODE_40542_length_617_cov_2.829044_g37094_i0	PRJNA879067	40542	617	2.829044	17.45520148	Rhizophagus irregularis	588596	Fungi	Fungi	89.8	4.66e-13	NTclustered	gi\|2749779773\|ref\|XM_066148999.1\|	588596	g37094	i0	80.87	0.376012965964344	115	21	19	1	64	178	844	957	Rhizophagus irregularis uncharacterized protein (OCT59_020164), partial mRNA	blastn	232	89.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
4684767	4684767	PRJNA879067_P_NODE_90584_length_296_cov_1.923767_g87098_i0	PRJNA879067	90584	296	1.923767	5.69435032	Mucor velutinosus	708070	Fungi	Fungi	331	3.15e-86	NTclustered	gi\|2724954767\|ref\|XM_064825574.1\|	708070	g87098	i0	91.949	2.52364864864865	236	19	80	0	1	236	236	1	Mucor velutinosus uncharacterized protein (ATC70_006298), partial mRNA	blastn	747	331	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
11058701	11058701	PRJNA879067_P_NODE_40549_length_617_cov_2.424632_g37101_i0	PRJNA879067	40549	617	2.424632	14.95997944	Mucor indicus	64623	Fungi	Fungi	723	0	NTclustered	gi\|2627921281\|ref\|NC_084441.1\|	64623	g37101	i0	95	72.012965964343607	460	23	93	0	1	460	6321	5862	Mucor indicus mitochondrion, complete genome	blastn	44432	723	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor indicus
11443016	11443016	PRJNA879067_P_NODE_78869_length_344_cov_1.557196_g75383_i0	PRJNA879067	78869	344	1.557196	5.35675424	Eukaryota	2759	Fungi	Fungi	176	1.85e-39	NTclustered	gi\|658131649\|emb\|HF968975.1\|	4874	g75383	i0	86.145	51.9593023255814	166	20	48	3	83	247	2024	1861	Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 3, clone BL2_4_2	blastn	17874	176	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
12335631	12335631	PRJNA879067_P_NODE_97510_length_271_cov_2.075758_g94024_i0	PRJNA879067	97510	271	2.075758	5.62530418	Lobosporangium transversale	64571	Fungi	Fungi	279	1.05e-70	NTclustered	gi\|1227141226\|ref\|XM_022024583.1\|	64571	g94024	i0	86.905	3.2029520295203	252	29	92	3	1	248	254	3	Lobosporangium transversale 60S ribosomal protein L14 (BCR41DRAFT_356073), mRNA	blastn	868	279	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
13609292	13609292	PRJNA879067_P_NODE_62811_length_431_cov_1.075419_g59326_i0	PRJNA879067	62811	431	1.075419	4.63505589	Parasitella parasitica	35722	Fungi	Fungi	752	0	NTclustered	gi\|689358021\|ref\|NC_024944.1\|	35722	g59326	i0	98.144	99.4524361948956	431	8	100	0	1	431	40185	39755	Parasitella parasitica strain CBS 412.66 mitochondrion, complete genome	blastn	42864	752	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Parasitella	Parasitella parasitica
15266790	15266790	PRJNA879067_P_NODE_25852_length_848_cov_9.286452_g22648_i0	PRJNA879067	25852	848	9.286452	78.74911296	Mortierellaceae	4854	Fungi	Fungi	610	1.1199999999999995e-169	NTclustered	gi\|1929277566\|gb\|MN878155.1\|	64525	g22648	i0	82.027	86.5035377358491	740	111	86	18	90	818	1	729	Podila minutissima strain AD077A elongation factor 1-alpha (EF1a) gene, partial cds	blastn	73355	616	0.99025974025974	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila minutissima
16158716	16158716	PRJNA879067_P_NODE_76853_length_353_cov_1.803571_g73367_i0	PRJNA879067	76853	353	1.803571	6.36660563	Cokeromyces recurvatus	90255	Fungi	Fungi	58.4	7.17e-4	NTclustered	gi\|2324078615\|ref\|XM_051530884.1\|	90255	g73367	i0	100	0.0878186968838527	31	0	9	0	320	350	1028	1058	Cokeromyces recurvatus uncharacterized protein (BX663DRAFT_544230), mRNA	blastn	31	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
25080535	25080535	PRJNA879067_P_NODE_24880_length_870_cov_11.464241_g21715_i0	PRJNA879067	24880	870	11.464241	99.7388967	Absidia healeyae	2733465	Fungi	Fungi	128	1.42e-24	NTclustered	gi\|1838434290\|gb\|MT436028.1\|	2733465	g21715	i0	86.957	13.6195402298851	115	13	13	2	754	867	4345	4458	Absidia healeyae strain UoMAU1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	11849	128	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia healeyae

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