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

5 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
9958531	9958531	PRJNA1126198_P_NODE_362408_length_253_cov_0.866667_g361687_i0	PRJNA1126198	362408	253	0.866667	2.19266751	Opisthokonta	33154	Fungi	Fungi	52.8	0.023	NTclustered	gi\|2323791589\|ref\|XM_051550915.1\|	101098	g361687	i0	100	0.442687747035573	28	0	11	0	44	71	3814	3841	Gamsiella multidivaricata uncharacterized protein (BC939DRAFT_238225), mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
10484674	10484674	PRJNA1126198_P_NODE_190469_length_296_cov_1.381166_g189749_i0	PRJNA1126198	190469	296	1.381166	4.08825136	Gilbertella persicaria	101096	Fungi	Fungi	228	4.2499999999999984e-55	NTclustered	gi\|2323767922\|ref\|XM_051573586.1\|	101096	g189749	i0	80.822	8.94594594594595	292	54	98	2	1	291	621	911	Gilbertella persicaria guanine nucleotide-binding protein subunit beta-2-like 1 (B0P05DRAFT_343640), mRNA	blastn	2648	228	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
15584759	15584759	PRJNA1126198_P_NODE_5833_length_732_cov_1.614568_g5215_i0	PRJNA1126198	5833	732	1.614568	11.81863776	Zychaea mexicana	64656	Fungi	Fungi	99	9.28e-16	NTclustered	gi\|2432156358\|ref\|XM_053120640.1\|	64656	g5215	i0	86.517	0.916666666666667	89	12	12	0	445	533	305	217	Zychaea mexicana 50S ribosomal protein L13e (BDB00DRAFT_786794), partial mRNA	blastn	671	99	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
23234273	23234273	PRJNA1126198_P_NODE_7519_length_656_cov_3.603774_g6872_i0	PRJNA1126198	7519	656	3.603774	23.64075744	Phycomyces blakesleeanus	4837	Fungi	Fungi	342	3.4599999999999996e-89	NTclustered	gi\|1069938230\|ref\|XM_018429293.1\|	763407	g6872	i0	79.707	62.844512195122	478	93	73	4	62	537	3071	3546	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	41226	342	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
24507480	24507480	PRJNA1126198_P_NODE_378980_length_251_cov_0.870787_g378259_i0	PRJNA1126198	378980	251	0.870787	2.18567537	Cokeromyces recurvatus	90255	Fungi	Fungi	156	1.69e-33	NTclustered	gi\|2324047772\|ref\|XM_051525382.1\|	90255	g378259	i0	79.911	24.6573705179283	224	35	87	8	17	235	518	300	Cokeromyces recurvatus ADP,ATP carrier protein (BX663DRAFT_493597), mRNA	blastn	6189	156	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus

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