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

5 rows where analysis = "blastn", bioproject = "PRJNA781427" 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
12691580	12691580	PRJNA781427_P_NODE_67130_length_269_cov_0.933673_g66246_i0	PRJNA781427	67130	269	0.933673	2.51158037	Fungi	4751	Fungi	Fungi	492	1.23e-134	NTclustered	gi\|62361829\|gb\|AY882560.1\|	27381	g66246	i0	99.628	30.2118959107807	269	1	100	0	1	269	706	974	Glomus mosseae putative amino acid permease mRNA, complete cds	blastn	8127	492	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis mosseae
18613433	18613433	PRJNA781427_P_NODE_87315_length_245_cov_0.895349_g86431_i0	PRJNA781427	87315	245	0.895349	2.19360505	Rhizopus delemar	936053	Fungi	Fungi	156	1.64e-33	NTclustered	gi\|2797475328\|ref\|XM_067666830.1\|	246409	g86431	i0	98.851	0.355102040816327	87	1	36	0	59	145	67	153	Rhizopus delemar RA 99-880 uncharacterized protein (RO3G_12246), partial mRNA	blastn	87	156	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
19888453	19888453	PRJNA781427_P_NODE_78576_length_249_cov_0.875000_g77692_i0	PRJNA781427	78576	249	0.875	2.17875	Rhizopus delemar	936053	Fungi	Fungi	438	1.4799999999999996e-118	NTclustered	gi\|2797443467\|ref\|XM_067660028.1\|	246409	g77692	i0	99.177	0.975903614457831	243	2	98	0	1	243	260	502	Rhizopus delemar RA 99-880 uncharacterized protein (RO3G_05438), partial mRNA	blastn	243	438	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
21163066	21163066	PRJNA781427_P_NODE_36177_length_382_cov_1.245955_g35295_i0	PRJNA781427	36177	382	1.245955	4.7595481	Lobosporangium transversale	64571	Fungi	Fungi	298	4.24e-76	NTclustered	gi\|1227140522\|ref\|XM_022024460.1\|	64571	g35295	i0	84.314	19.6282722513089	306	46	80	2	2	306	327	631	Lobosporangium transversale ADP-ribosylation factor family-domain-containing protein (BCR41DRAFT_355168), mRNA	blastn	7498	298	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
22438755	22438755	PRJNA781427_P_NODE_71578_length_257_cov_1.255435_g70694_i0	PRJNA781427	71578	257	1.255435	3.22646795	Umbelopsis ramanniana	41833	Fungi	Fungi	58.4	5.02e-4	NTclustered	gi\|2323683426\|ref\|XM_051587025.1\|	1314678	g70694	i0	88	0.194552529182879	50	4	19	2	38	86	147	99	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_229045), mRNA	blastn	50	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana

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