metadata: contig_metadata: 11 rows where bioproject = "PRJNA207719" and tax

11 rows where bioproject = "PRJNA207719" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
367052	367052	PRJNA207719_P_NODE_921_length_200_cov_1.286550_g901_i0	PRJNA207719	921	200	1.28655	2.5731	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	298	2.02e-76	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g901	i0	93.5	1	200	13	100	0	1	200	6653	6454	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	200	298	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
8020477	8020477	PRJNA207719_P_NODE_967_length_193_cov_2.469512_g947_i0	PRJNA207719	967	193	2.469512	4.76615816	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.001	NTclustered	gi\|2914915832\|gb\|OR221277.1\|	2832643	g947	i0	100	0.44559585492228	30	0	16	0	164	193	40827	40856	MAG: Caudoviricetes sp. isolate MSP1839 genomic sequence	blastn	86	56.5	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26711626	26711626	PRJNA207719_P_NODE_21_length_1234_cov_7.056432_g19_i0	PRJNA207719	21	1234	7.056432	87.07637088	Viruses	10239	Viruses	Viruses	91.3	8.65e-16	NR	DAC81149.1	2609873	g19	i0	25.5	2.12722852512156	286	197	65.9	7	42	854	236	520	DAC81149.1 TPA_asm: LO7 [Bueycito anole adomavirus]	diamond	2625	91.3	1	Viruses	Adomaviruses							Bueycito anole adomavirus
27168577	27168577	PRJNA207719_P_NODE_902_length_201_cov_6.889535_g882_i0	PRJNA207719	902	201	6.889535	13.84796535	Catfish adomavirus	2609875	Viruses	Viruses	65.9	5.18e-11	NR	DAC81156.1	2609875	g882	i0	49.2	1.82089552238806	63	32	94	0	4	192	101	163	DAC81156.1 TPA_asm: LO8, partial [Catfish adomavirus]	diamond	366	65.9	1	Viruses	Adomaviruses							Catfish adomavirus
27800664	27800664	PRJNA207719_P_NODE_384_length_342_cov_4.265176_g364_i0	PRJNA207719	384	342	4.265176	14.58690192	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	84.7	2.32e-16	NR	UNY41988.1	3003959	g364	i0	48	0.859649122807018	98	49	85.1	2	340	50	2842	2938	UNY41988.1 MAG: polyprotein [Picornavirales sp.]	diamond	294	84.7	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28021684	28021684	PRJNA207719_P_NODE_1165_length_170_cov_2.652482_g1145_i0	PRJNA207719	1165	170	2.652482	4.5092194	Locarnavirus sp.	2809529	Viruses	Viruses	67.4	2.78e-11	NR	ULG00057.1	2809529	g1145	i0	66.1	1.97647058823529	56	19	98.8	0	1	168	266	321	ULG00057.1 MAG: hypothetical protein 2 [Locarnavirus sp.]	diamond	336	67.4	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus sp.
28905348	28905348	PRJNA207719_P_NODE_588_length_264_cov_3.293617_g568_i0	PRJNA207719	588	264	3.293617	8.69514888	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	108	2.54e-25	NR	UNY41988.1	3003959	g568	i0	59.3	1.03409090909091	91	33	98.9	1	263	3	2292	2382	UNY41988.1 MAG: polyprotein [Picornavirales sp.]	diamond	273	108	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30674185	30674185	PRJNA207719_P_NODE_1033_length_185_cov_2.051282_g1013_i0	PRJNA207719	1033	185	2.051282	3.7948717	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	86.3	7.98e-18	NR	UNY41988.1	3003959	g1013	i0	67.3	0.843243243243243	52	17	84.3	0	29	184	2601	2652	UNY41988.1 MAG: polyprotein [Picornavirales sp.]	diamond	156	86.3	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31496279	31496279	PRJNA207719_P_NODE_136_length_615_cov_4.003413_g119_i0	PRJNA207719	136	615	4.003413	24.62098995	Zebrafish adomavirus	RQ02	Viruses	Viruses	93.6	6.42e-19	NR	YP_009553058.1	RQ02	g119	i0	44.2	0.717073170731707	147	61	65.9	5	546	142	85	222	YP_009553058.1 LO6 [Symphysodon discus adomavirus 1]	diamond	441	93.6	1	Viruses	Adomaviruses							Zebrafish adomavirus
31496280	31496280	PRJNA207719_P_NODE_596_length_261_cov_3.689655_g576_i0	PRJNA207719	596	261	3.689655	9.62999955	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	78.6	1.22e-14	NR	UNY41988.1	3003959	g576	i0	40.9	1.01149425287356	88	51	100	1	1	261	2689	2776	UNY41988.1 MAG: polyprotein [Picornavirales sp.]	diamond	264	78.6	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31780596	31780596	PRJNA207719_P_NODE_217_length_466_cov_4.526316_g197_i0	PRJNA207719	217	466	4.526316	21.09263256	Adomavirus sceloporus8187	3115978	Viruses	Viruses	65.1	6.08e-9	NR	DBA49608.1	3115978	g197	i0	28.6	4.10085836909871	161	105	97.9	3	10	465	60	219	DBA49608.1 MAG TPA_asm: Hexon [Adomavirus sceloporus8187]	diamond	1911	65.1	1	Viruses	Adomaviruses							Adomavirus sceloporus8187

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