metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax_kingdom = "Shotokuvirae"

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
27917500	27917500	PRJEB25583_P_NODE_3685_length_211_cov_1.333333_g3508_i0	PRJEB25583	3685	211	1.333333	2.81333263	Phylloscopus inornatus ambidensovirus	2794452	Viruses	Viruses	86.7	1.72e-18	NR	QVW56792.1	2794452	g3508	i0	65.1	0.895734597156398	63	22	89.6	0	23	211	171	233	QVW56792.1 MAG: structural protein VP1 [Phylloscopus inornatus ambidensovirus]	diamond	189	86.7	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Ambidensovirus	Phylloscopus inornatus ambidensovirus
28327945	28327945	PRJEB25583_P_NODE_3126_length_229_cov_1.958333_g2949_i0	PRJEB25583	3126	229	1.958333	4.48458257	Cressdnaviricota sp.	2748378	Viruses	Viruses	45.4	0.00284	NR	WAE42899.1	2748378	g2949	i0	39.3	1.45414847161572	56	33	72.1	1	209	45	176	231	WAE42899.1 MAG: capsid protein [Cressdnaviricota sp.]	diamond	333	45.4	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
28327946	28327946	PRJEB25583_P_NODE_5646_length_174_cov_1.547445_g5469_i0	PRJEB25583	5646	174	1.547445	2.6925543	Circoviridae sp.	1954248	Viruses	Viruses	49.3	6.2e-5	NR	UOF78644.1	1954248	g5469	i0	68.8	0.551724137931034	32	10	55.2	0	77	172	1	32	UOF78644.1 rep protein [Circoviridae sp.]	diamond	96	49.3	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
29496304	29496304	PRJEB25583_P_NODE_2730_length_245_cov_2.701923_g2553_i0	PRJEB25583	2730	245	2.701923	6.61971135	Parvoviridae sp.	1940570	Viruses	Viruses	56.2	6.43e-7	NR	WAQ80602.1	1940570	g2553	i0	43.7	5.11836734693878	71	34	86.9	2	223	11	43	107	WAQ80602.1 MAG: replication protein [Parvoviridae sp.]	diamond	1254	56.2	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
29653814	29653814	PRJEB25583_P_NODE_870_length_510_cov_4.534884_g698_i0	PRJEB25583	870	510	4.534884	23.1279084	Accipiter gentilis parvo-like hybrid virus	2794564	Viruses	Viruses	155	8.19e-42	NR	QTE04017.1	2794564	g698	i0	58	0.841176470588235	143	58	82.9	2	490	68	310	452	QTE04017.1 MAG: putative capsid protein [Accipiter gentilis parvo-like hybrid virus]	diamond	429	155	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Accipiter gentilis parvo-like hybrid virus
29685446	29685446	PRJEB25583_P_NODE_1770_length_318_cov_7.274021_g1593_i0	PRJEB25583	1770	318	7.274021	23.13138678	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	184	2.0599999999999998e-54	NR	AGV22413.1	3003968	g1593	i0	83.3	0.962264150943396	102	17	96.2	0	316	11	7	108	AGV22413.1 replication protein [Parvo-like hybrid virus UC9]	diamond	306	184	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
30444065	30444065	PRJEB25583_P_NODE_2733_length_245_cov_2.514423_g2556_i0	PRJEB25583	2733	245	2.514423	6.16033635	Cressdnaviricota sp.	2748378	Viruses	Viruses	142	1.78e-39	NR	UOF80454.1	2748378	g2556	i0	73.8	0.979591836734694	80	21	98	0	2	241	168	247	UOF80454.1 rep protein [Cressdnaviricota sp.]	diamond	240	142	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
30570047	30570047	PRJEB25583_P_NODE_1493_length_355_cov_9.078616_g1316_i0	PRJEB25583	1493	355	9.078616	32.2290868	Cressdnaviricota sp.	2748378	Viruses	Viruses	105	1.22e-24	NR	XNT21031.1	2748378	g1316	i0	75.8	0.523943661971831	62	15	52.4	0	332	147	212	273	XNT21031.1 MAG: Rep protein, partial [Cressdnaviricota sp.]	diamond	186	105	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
30696576	30696576	PRJEB25583_P_NODE_8134_length_152_cov_1.243478_g7957_i0	PRJEB25583	8134	152	1.243478	1.89008656	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	102	3.51e-24	NR	AGV22413.1	3003968	g7957	i0	90	1.97368421052632	50	5	98.7	0	151	2	231	280	AGV22413.1 replication protein [Parvo-like hybrid virus UC9]	diamond	300	102	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
31581919	31581919	PRJEB25583_P_NODE_836_length_525_cov_3.547131_g665_i0	PRJEB25583	836	525	3.547131	18.62243775	Ciconia boyciana CRESS-DNA-virus sp.	2815024	Viruses	Viruses	103	2.98e-23	NR	QTE03459.1	2815024	g665	i0	45.8	1.49714285714286	142	67	81.1	3	435	10	8	139	QTE03459.1 MAG: putative capsid protein [Ciconia boyciana CRESS-DNA-virus sp.]	diamond	786	103	1	Viruses	Shotokuvirae	Cressdnaviricota					Ciconia boyciana CRESS-DNA-virus 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);;