metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax_superkingdom = "Viruses"

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_genus	tax_species
26913629	26913629	PRJNA1156092_P_NODE_29362_length_244_cov_0.900585_g29232_i0	PRJNA1156092	29362	244	0.900585	2.1974274	uncultured Mediterranean phage uvMED	1407671	Viruses	Viruses	53.1	6.38e-7	NR	BAQ84231.1	1407671	g29232	i0	67.9	0.344262295081967	28	9	34.4	0	135	52	9	36	BAQ84231.1 hypothetical protein [uncultured Mediterranean phage uvMED]	diamond	84	53.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
27324841	27324841	PRJNA1156092_P_NODE_663_length_1077_cov_2.892430_g584_i0	PRJNA1156092	663	1077	2.89243	31.1514711	Atractylodes mild mottle virus	1711685	Viruses	Viruses	133	9.12e-31	NR	YP_009165749.1	1711685	g584	i0	63.7	0.504178272980501	91	33	25.3	0	803	1075	276	366	YP_009165749.1 ORF4 [Atractylodes mild mottle virus]	diamond	543	133	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Caulimovirus	Caulimovirus maculatractylodei
28828045	28828045	PRJNA1156092_P_NODE_18908_length_271_cov_1.166667_g18778_i0	PRJNA1156092	18908	271	1.166667	3.16166757	Chuvivirus	2842604	Viruses	Viruses	138	1.55e-36	NR	WET19887.1	2842604	g18778	i0	69.7	1.97047970479705	89	27	98.5	0	268	2	292	380	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	534	138	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
29914123	29914123	PRJNA1156092_P_NODE_29111_length_244_cov_0.900585_g28981_i0	PRJNA1156092	29111	244	0.900585	2.1974274	Retroviridae sp.	2681591	Viruses	Viruses	77	3.22e-14	NR	XNT20490.1	2681591	g28981	i0	49.4	0.971311475409836	79	34	89.8	2	17	235	450	528	XNT20490.1 MAG: hypothetical protein, partial [Retroviridae sp.]	diamond	237	77	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retroviridae sp.
32411601	32411601	PRJNA1156092_P_NODE_26339_length_247_cov_0.885057_g26209_i0	PRJNA1156092	26339	247	0.885057	2.18609079	Synechococcus phage S-B43	2484638	Viruses	Viruses	62.8	2.79e-9	NR	QDH50644.1	2484638	g26209	i0	42.2	1.09311740890688	90	35	88.7	1	247	29	22	111	QDH50644.1 hypothetical protein [Synechococcus phage S-B43]	diamond	270	62.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae		Synechococcus phage S-B43
32663953	32663953	PRJNA1156092_P_NODE_29580_length_244_cov_0.900585_g29450_i0	PRJNA1156092	29580	244	0.900585	2.1974274	Caudoviricetes sp.	2832643	Viruses	Viruses	99	6.300000000000001e-22	NR	DAX26151.1	2832643	g29450	i0	49.4	0.995901639344262	81	41	99.6	0	243	1	211	291	DAX26151.1 MAG TPA: portal protein [Caudoviricetes sp.]	diamond	243	99	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32821531	32821531	PRJNA1156092_P_NODE_17060_length_284_cov_1.142180_g16930_i0	PRJNA1156092	17060	284	1.14218	3.2437912	Caudoviricetes sp.	2832643	Viruses	Viruses	110	5.49e-29	NR	XOQ88959.1	2832643	g16930	i0	63.6	0.929577464788732	88	30	90.8	1	27	284	1	88	XOQ88959.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	264	110	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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