metadata: contig_metadata: 6 rows where analysis = "diamond" and bioproject = "PRJNA505837"

6 rows where analysis = "diamond" and bioproject = "PRJNA505837"

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
27519476	27519476	PRJNA505837_S_NODE_343_length_248_cov_3.707763_g328_i0	PRJNA505837	343	248	3.707763	9.19525224	Mucor ambiguus	91626	Fungi	Fungi	151	1.12e-44	NR	GAN07079.1	91626	g328	i0	95.1	0.991935483870968	82	4	99.2	0	2	247	61	142	GAN07079.1 conserved hypothetical protein [Mucor ambiguus]	diamond	246	151	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor ambiguus
28656224	28656224	PRJNA505837_S_NODE_527_length_198_cov_4.887574_g512_i0	PRJNA505837	527	198	4.887574	9.67739652	Mucor lusitanicus	29924	Fungi	Fungi	146	1.53e-43	NR	KAF1796850.1	29924	g512	i0	100	2	66	0	100	0	1	198	53	118	KAF1796850.1 hypothetical protein FB192DRAFT_1403992 [Mucor lusitanicus]	diamond	396	146	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
29413809	29413809	PRJNA505837_S_NODE_49_length_570_cov_4.569316_g39_i0	PRJNA505837	49	570	4.569316	26.0451012	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	137	1.84e-33	NR	AVM87441.1	3063761	g39	i0	40.8	2.10526315789474	201	101	98.4	5	3	563	987	1183	AVM87441.1 polyprotein [Wenling rattails picornavirus]	diamond	1200	137	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
30266992	30266992	PRJNA505837_S_NODE_572_length_191_cov_1.839506_g557_i0	PRJNA505837	572	191	1.839506	3.51345646	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	76.3	2.89e-14	NR	AVM87439.1	3063761	g557	i0	63.6	1.03664921465969	66	21	99	1	189	1	480	545	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	198	76.3	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
30993430	30993430	PRJNA505837_S_NODE_394_length_230_cov_4.875622_g379_i0	PRJNA505837	394	230	4.875622	11.2139306	Mucor lusitanicus	29924	Fungi	Fungi	96.3	3.5999999999999986e-24	NR	KAF1799313.1	29924	g379	i0	100	0.6	46	0	60	0	3	140	31	76	KAF1799313.1 hypothetical protein FB192DRAFT_1386114 [Mucor lusitanicus]	diamond	138	96.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
32290472	32290472	PRJNA505837_S_NODE_279_length_270_cov_3.460581_g264_i0	PRJNA505837	279	270	3.460581	9.3435687	Mucor lusitanicus CBS 277.49	747725	Fungi	Fungi	80.1	3.41e-17	NR	OAC99592.1	747725	g264	i0	97.4	0.433333333333333	39	1	43.3	0	250	134	1	39	OAC99592.1 hypothetical protein MUCCIDRAFT_114785 [Mucor lusitanicus CBS 277.49]	diamond	117	80.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus

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