metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA738523" 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
1995542	1995542	PRJNA738523_P_NODE_10182_length_253_cov_1.711111_g10111_i0	PRJNA738523	10182	253	1.711111	4.32911083	Caudoviricetes sp.	2832643	Viruses	Viruses	412	9.14e-111	NTclustered	gi\|2914880774\|gb\|OR222049.1\|	2832643	g10111	i0	96.047	1	253	10	100	0	1	253	30250	30502	MAG: Caudoviricetes sp. isolate MSP0066 genomic sequence	blastn	253	412	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
1995628	1995628	PRJNA738523_P_NODE_6902_length_285_cov_1.405660_g6831_i0	PRJNA738523	6902	285	1.40566	4.006131	Zebrafish picornavirus 1	2304617	Viruses	Viruses	481	2.83e-131	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6831	i0	98.529	2.86315789473684	272	4	95	0	14	285	3644	3373	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	816	481	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
3270874	3270874	PRJNA738523_P_NODE_16603_length_226_cov_2.738562_g16532_i0	PRJNA738523	16603	226	2.738562	6.18915012	Escherichia phage TR2	2978981	Viruses	Viruses	418	1.7199999999999998e-112	NTclustered	gi\|2312628476\|gb\|OP251154.1\|	2978981	g16532	i0	100	1	226	0	100	0	1	226	19976	19751	Escherichia phage TR2, complete genome	blastn	226	418	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Drexlerviridae	Christensenvirus	Escherichia phage TR2
8372849	8372849	PRJNA738523_P_NODE_5867_length_300_cov_0.903084_g5796_i0	PRJNA738523	5867	300	0.903084	2.709252	Zebrafish picornavirus 1	2304617	Viruses	Viruses	516	8.23e-142	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g5796	i0	97.667	3	300	7	100	0	1	300	7364	7663	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	900	516	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9647978	9647978	PRJNA738523_P_NODE_368_length_965_cov_2.612108_g322_i0	PRJNA738523	368	965	2.612108	25.2068422	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	569	2.1799999999999998e-157	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g322	i0	97.321	0.637305699481865	336	8	64	1	411	746	771	1105	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	615	569	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
10923503	10923503	PRJNA738523_P_NODE_6569_length_288_cov_1.641860_g6498_i0	PRJNA738523	6569	288	1.64186	4.7285568	Zebrafish picornavirus 1	2304617	Viruses	Viruses	499	7.92e-137	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6498	i0	97.917	3	288	6	100	0	1	288	4290	4003	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	864	499	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14748448	14748448	PRJNA738523_P_NODE_12352_length_248_cov_0.880000_g12281_i0	PRJNA738523	12352	248	0.88	2.1824	Zebrafish picornavirus 1	2304617	Viruses	Viruses	425	1.15e-114	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12281	i0	97.581	3	248	6	100	0	1	248	2755	3002	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	744	425	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
15226268	15226268	PRJNA738523_P_NODE_11872_length_249_cov_0.875000_g11801_i0	PRJNA738523	11872	249	0.875	2.17875	Dismasvirus	2560122	Viruses	Viruses	52.8	0.023	NTclustered	gi\|2486599177\|ref\|NC_073433.1\|	2829393	g11801	i0	100	0.337349397590361	28	0	11	0	125	152	9087	9060	Microbacterium phage Stoor, complete genome	blastn	84	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Dismasvirus	Microbacterium phage Stoor
16022163	16022163	PRJNA738523_P_NODE_4733_length_325_cov_2.166667_g4662_i0	PRJNA738523	4733	325	2.166667	7.04166775	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	399	9.469999999999998e-107	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4662	i0	99.099	0.683076923076923	222	2	68	0	104	325	2	223	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	222	399	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
21122112	21122112	PRJNA738523_P_NODE_17_length_2890_cov_5.047568_g13_i0	PRJNA738523	17	2890	5.047568	145.8747152	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2795	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g13	i0	95.833	0.871280276816609	1728	70	87	2	1155	2881	5329	7055	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	2518	2795	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
23672552	23672552	PRJNA738523_P_NODE_1999_length_457_cov_1.799479_g1928_i0	PRJNA738523	1999	457	1.799479	8.22361903	Zebrafish picornavirus 1	2304617	Viruses	Viruses	693	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g1928	i0	94.273	2.92778993435449	454	24	99	2	5	457	5215	5667	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1338	693	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24945987	24945987	PRJNA738523_P_NODE_15880_length_241_cov_1.440476_g15809_i0	PRJNA738523	15880	241	1.440476	3.47154716	Zebrafish picornavirus 1	2304617	Viruses	Viruses	396	8.7e-106	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g15809	i0	96.639	2.97510373443983	238	8	99	0	4	241	2268	2031	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	717	396	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24946006	24946006	PRJNA738523_P_NODE_3860_length_349_cov_1.344203_g3789_i0	PRJNA738523	3860	349	1.344203	4.69126847	Zebrafish picornavirus 1	2304617	Viruses	Viruses	590	5.649999999999998e-164	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g3789	i0	97.135	2.98280802292264	349	10	100	0	1	349	6689	6341	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1041	590	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1

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