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

10 rows where analysis = "diamond", bioproject = "PRJNA482207" 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
27107688	27107688	PRJNA482207_P_NODE_22382_length_248_cov_1.760000_g22272_i0	PRJNA482207	22382	248	1.76	4.3648	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	60.8	1.69e-8	NR	AVM87439.1	3063761	g22272	i0	55.1	0.592741935483871	49	22	59.3	0	147	1	928	976	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	147	60.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
28118431	28118431	PRJNA482207_P_NODE_25865_length_245_cov_0.895349_g25755_i0	PRJNA482207	25865	245	0.895349	2.19360505	Lindangsbacken virus	2651947	Viruses	Viruses	46.2	0.00231	NR	QGA70947.1	2651947	g25755	i0	41.1	1.99591836734694	56	32	67.3	1	45	209	311	366	QGA70947.1 RNA-dependent RNA polymerase [Lindangsbacken virus]	diamond	489	46.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Lindangsbacken virus
28150282	28150282	PRJNA482207_P_NODE_19145_length_251_cov_1.443820_g19035_i0	PRJNA482207	19145	251	1.44382	3.6239882	Escherichia phage D2	2915331	Viruses	Viruses	88.2	8.4e-21	NR	ULG00791.1	2915331	g19035	i0	63.2	0.812749003984064	68	25	81.3	0	244	41	13	80	ULG00791.1 hypothetical protein, partial [Escherichia phage D2]	diamond	204	88.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Bievrevirus	Escherichia phage D2
30329557	30329557	PRJNA482207_P_NODE_27692_length_243_cov_1.376471_g27582_i0	PRJNA482207	27692	243	1.376471	3.34482453	Caudoviricetes sp.	2832643	Viruses	Viruses	49.3	3.27e-5	NR	DAH93386.1	2832643	g27582	i0	56.4	0.481481481481481	39	17	48.1	0	241	125	34	72	DAH93386.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.]	diamond	117	49.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30487111	30487111	PRJNA482207_P_NODE_29573_length_242_cov_0.911243_g29463_i0	PRJNA482207	29573	242	0.911243	2.20520806	Moumouvirus Monve	1128131	Viruses	Viruses	44.7	0.00755	NR	AEX62409.1	1128131	g29463	i0	31.2	1.90909090909091	77	49	95.5	3	232	2	401	473	AEX62409.1 cysteinyl-tRNA synthetase [Moumouvirus Monve]	diamond	462	44.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
30992618	30992618	PRJNA482207_P_NODE_24694_length_246_cov_0.890173_g24584_i0	PRJNA482207	24694	246	0.890173	2.18982558	Cellulophaga phage Nekkels_1	2745692	Viruses	Viruses	68.9	2.32e-11	NR	YP_010357532.1	2745692	g24584	i0	76.3	0.463414634146341	38	9	46.3	0	133	246	1	38	YP_010357532.1 DNA primase/helicase [Cellulophaga phage Nekkels_1]	diamond	114	68.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Assiduviridae	Nekkelsvirus	Nekkelsvirus Nekkels
31181792	31181792	PRJNA482207_P_NODE_21755_length_249_cov_0.875000_g21645_i0	PRJNA482207	21755	249	0.875	2.17875	Vibrio phage 1.242.O._1	1881235	Viruses	Viruses	70.5	6.09e-13	NR	AUR97566.1	1881235	g21645	i0	69	0.506024096385542	42	13	50.6	0	248	123	124	165	AUR97566.1 AP2/ERF domain protein [Vibrio phage 1.242.O._10N.261.54.B2]	diamond	126	70.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage 1.242.O._10N.261.54.B2
31181798	31181798	PRJNA482207_P_NODE_29095_length_242_cov_0.911243_g28985_i0	PRJNA482207	29095	242	0.911243	2.20520806	Vibrio phage vB_ValP_IME271	2024229	Viruses	Viruses	85.9	1.19e-18	NR	ASR73830.1	2024229	g28985	i0	48.1	0.979338842975207	79	41	97.9	0	241	5	5	83	ASR73830.1 hypothetical protein [Vibrio phage vB_ValP_IME271]	diamond	237	85.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage vB_ValP_IME271
31814674	31814674	PRJNA482207_P_NODE_10617_length_323_cov_1.232000_g10507_i0	PRJNA482207	10617	323	1.232	3.97936	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	85.9	7.23e-17	NR	UVF58820.1	3063761	g10507	i0	69.4	0.575851393188854	62	17	55.7	1	128	307	829	890	UVF58820.1 MAG: polyprotein [Asterropteryx spinosa picornavirus]	diamond	186	85.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
32668393	32668393	PRJNA482207_P_NODE_8240_length_352_cov_2.182796_g8130_i0	PRJNA482207	8240	352	2.182796	7.68344192	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	130	3.2399999999999996e-32	NR	AVM87439.1	3063761	g8130	i0	50.8	1.05681818181818	124	54	99.7	1	2	352	1019	1142	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	372	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2

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