metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Pisuviricota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
2994367	2994367	PRJNA473201_P_NODE_33623_length_342_cov_1.211896_g32881_i0	PRJNA473201	33623	342	1.211896	4.14468432	Crogonang virus 66	3063073	Viruses	Viruses	189	3.23e-53	NR	WPR18337.1	3063073	g32881	i0	87.6	2.97368421052632	113	12	99.1	1	340	2	517	627	WPR18337.1 MAG: capsid protein, partial [Crogonang virus 66]	diamond	1017	189	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Crogonang virus 66
29381404	29381404	PRJNA473201_P_NODE_10349_length_629_cov_1.309353_g9617_i0	PRJNA473201	10349	629	1.309353	8.23583037	Sacri virus	2744404	Viruses	Viruses	132	1.2799999999999999e-31	NR	BCG55387.1	2744404	g9617	i0	41.8	0.934817170111288	196	101	92.1	6	629	51	540	725	BCG55387.1 capsid protein precursor, partial [Sacri virus]	diamond	588	132	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Sacri virus
30565946	30565946	PRJNA473201_P_NODE_73993_length_247_cov_0.885057_g73251_i0	PRJNA473201	73993	247	0.885057	2.18609079	Viruses	10239	Viruses	Viruses	95.9	8.02e-21	NR	QRI44262.1	2715102	g73251	i0	61.3	2.73279352226721	75	29	91.1	0	225	1	478	552	QRI44262.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.]	diamond	675	96.7	0.991726990692865	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Marnaviridae sp.
30629290	30629290	PRJNA473201_P_NODE_32213_length_349_cov_1.097826_g31471_i0	PRJNA473201	32213	349	1.097826	3.83141274	Viruses	10239	Viruses	Viruses	122	1.38e-29	NR	URG14668.1	1530251	g31471	i0	71.3	2.82808022922636	80	23	68.8	0	3	242	675	754	URG14668.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	987	123	0.991869918699187	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
31687991	31687991	PRJNA473201_P_NODE_17337_length_478_cov_1.711111_g16595_i0	PRJNA473201	17337	478	1.711111	8.17911058	Crogonang virus 66	3063073	Viruses	Viruses	298	8.88e-92	NR	WPR18337.1	3063073	g16595	i0	89.9	0.997907949790795	159	16	99.8	0	478	2	731	889	WPR18337.1 MAG: capsid protein, partial [Crogonang virus 66]	diamond	477	298	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Crogonang virus 66

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