metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_phylum = "Cressdnaviricota"

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
3316852	3316852	PRJNA784979_S_NODE_883_length_600_cov_1.500907_g843_i0	PRJNA784979	883	600	1.500907	9.005442	Cressdnaviricota sp.	2748378	Viruses	Viruses	347	9.939999999999996e-119	NR	WAE43074.1	2748378	g843	i0	78.8	0.99	198	42	99	0	598	5	73	270	WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.]	diamond	594	347	1	Viruses		Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
26705232	26705232	PRJNA784979_S_NODE_2441_length_294_cov_1.469388_g2399_i0	PRJNA784979	2441	294	1.469388	4.32000072	Cynopterus sphinx circular DNA virus 1	3064082	Viruses	Viruses	133	4.02e-36	NR	WOE49740.1	3064083	g2399	i0	66	0.959183673469388	94	32	95.9	0	283	2	1	94	WOE49740.1 MAG: putative replicase protein [Cynopterus sphinx circular DNA virus 10]	diamond	282	133	1	Viruses		Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10
26832178	26832178	PRJNA784979_S_NODE_9541_length_171_cov_1.040984_g9499_i0	PRJNA784979	9541	171	1.040984	1.78008264	Parvo-like hybrid virus UC4	1395615	Viruses	Viruses	74.3	8.67e-14	NR	QJI53854.1	1395615	g9499	i0	62.3	0.929824561403509	53	20	93	0	170	12	300	352	QJI53854.1 MAG: replication protein [Parvo-like hybrid virus UC4]	diamond	159	74.3	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Nicoomyvirus moldensis
27116640	27116640	PRJNA784979_S_NODE_3122_length_262_cov_1.150235_g3080_i0	PRJNA784979	3122	262	1.150235	3.0136157	Parvo-like hybrid virus UC4	1395615	Viruses	Viruses	114	7.68e-28	NR	QJI53849.1	1395615	g3080	i0	86	0.652671755725191	57	8	65.3	0	256	86	335	391	QJI53849.1 MAG: replication protein [Parvo-like hybrid virus UC4]	diamond	171	114	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Nicoomyvirus moldensis
27211482	27211482	PRJNA784979_S_NODE_7802_length_183_cov_2.029851_g7760_i0	PRJNA784979	7802	183	2.029851	3.71462733	Cressdnaviricota sp.	2748378	Viruses	Viruses	45.4	0.00156	NR	AXH77215.1	2748378	g7760	i0	42.3	3.27868852459016	52	29	83.6	1	30	182	110	161	AXH77215.1 MAG: putative replication initiation protein [Cressdnaviricota sp.]	diamond	600	45.4	1	Viruses		Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
27274949	27274949	PRJNA784979_S_NODE_2923_length_270_cov_1.520362_g2881_i0	PRJNA784979	2923	270	1.520362	4.1049774	Cressdnaviricota sp.	2748378	Viruses	Viruses	44.3	0.013	NR	WAE43074.1	2748378	g2881	i0	59.3	0.3	27	11	30	0	186	266	1	27	WAE43074.1 MAG: replication associated protein [Cressdnaviricota sp.]	diamond	81	44.3	1	Viruses		Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
27622485	27622485	PRJNA784979_S_NODE_2244_length_309_cov_1.965385_g2202_i0	PRJNA784979	2244	309	1.965385	6.07303965	Cynopterus sphinx circular DNA virus 1	3064082	Viruses	Viruses	87	1.67e-17	NR	WOE49739.1	3064083	g2202	i0	45.1	0.990291262135922	102	55	98.1	1	7	309	66	167	WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10]	diamond	306	87	1	Viruses		Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10
28032956	28032956	PRJNA784979_S_NODE_1585_length_382_cov_1.576577_g1543_i0	PRJNA784979	1585	382	1.576577	6.02252414	Cynopterus sphinx circular DNA virus 1	3064082	Viruses	Viruses	223	7.32e-69	NR	WOE49739.1	3064083	g1543	i0	86.3	0.973821989528796	124	17	97.4	0	11	382	253	376	WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10]	diamond	372	223	1	Viruses		Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10
28159324	28159324	PRJNA784979_S_NODE_4025_length_233_cov_1.418478_g3983_i0	PRJNA784979	4025	233	1.418478	3.30505374	Cremevirales sp.	2809069	Viruses	Viruses	89	4.16e-19	NR	XOF00289.1	2809069	g3983	i0	48.1	2.94849785407725	77	40	99.1	0	3	233	147	223	XOF00289.1 MAG: hypothetical protein [Cremevirales sp.]	diamond	687	89	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cremevirales			Cremevirales sp.
29421863	29421863	PRJNA784979_S_NODE_12709_length_162_cov_1.283186_g12667_i0	PRJNA784979	12709	162	1.283186	2.07876132	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	72.4	2.95e-13	NR	QTZ83196.1	3003968	g12667	i0	72.1	0.796296296296296	43	12	79.6	0	24	152	22	64	QTZ83196.1 MAG: capsid protein [Grus japonensis parvo-like hybrid virus]	diamond	129	72.4	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
31001606	31001606	PRJNA784979_S_NODE_12514_length_163_cov_0.877193_g12472_i0	PRJNA784979	12514	163	0.877193	1.42982459	Parvo-like hybrid virus UC4	1395615	Viruses	Viruses	42.4	0.0174	NR	QJI53850.1	1395615	g12472	i0	38.9	0.993865030674847	54	29	92	1	4	153	157	210	QJI53850.1 MAG: capsid protein [Parvo-like hybrid virus UC4]	diamond	162	42.4	1	Viruses		Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Nicoomyvirus moldensis
31760372	31760372	PRJNA784979_S_NODE_8237_length_180_cov_1.633588_g8195_i0	PRJNA784979	8237	180	1.633588	2.9404584	Cressdnaviricota sp.	2748378	Viruses	Viruses	47.8	2.7e-4	NR	AXH74985.1	2748378	g8195	i0	33.9	0.933333333333333	56	36	93.3	1	174	7	100	154	AXH74985.1 MAG: Rep [Cressdnaviricota sp.]	diamond	168	47.8	1	Viruses		Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
31896163	31896163	PRJNA784979_S_NODE_1137_length_487_cov_1.835616_g1095_i0	PRJNA784979	1137	487	1.835616	8.93944992	Viruses	10239	Viruses	Viruses	107	9.36e-25	NR	QGH73619.1	2656678	g1095	i0	37.2	2.87679671457906	164	92	94.9	3	18	479	4	166	QGH73619.1 MAG: Rep protein [CRESS virus sp. ctWOo3]	diamond	1401	107	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota					CRESS virus sp. ctWOo3
32298640	32298640	PRJNA784979_S_NODE_8339_length_179_cov_1.815385_g8297_i0	PRJNA784979	8339	179	1.815385	3.24953915	Cynopterus sphinx circular DNA virus 1	3064082	Viruses	Viruses	74.3	4.07e-14	NR	WOE49740.1	3064083	g8297	i0	82.9	0.687150837988827	41	7	68.7	0	178	56	223	263	WOE49740.1 MAG: putative replicase protein [Cynopterus sphinx circular DNA virus 10]	diamond	123	74.3	1	Viruses		Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10
32520017	32520017	PRJNA784979_S_NODE_7039_length_190_cov_2.503546_g6997_i0	PRJNA784979	7039	190	2.503546	4.7567374	Cynopterus sphinx circular DNA virus 1	3064082	Viruses	Viruses	80.9	5.69e-16	NR	WOE49739.1	3064083	g6997	i0	64.4	0.931578947368421	59	21	93.2	0	183	7	248	306	WOE49739.1 MAG: putative capsid protein, partial [Cynopterus sphinx circular DNA virus 10]	diamond	177	80.9	1	Viruses		Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10

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