metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax_kingdom = "Orthornavirae"

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
1605106	1605106	PRJNA1214993_P_NODE_3062_length_603_cov_3.081132_g2883_i0	PRJNA1214993	3062	603	3.081132	18.57922596	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	409	3.08e-109	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2883	i0	89.937	0.782752902155887	318	31	78	1	1	318	1087	771	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	472	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
2881216	2881216	PRJNA1214993_P_NODE_18323_length_261_cov_6.281915_g18137_i0	PRJNA1214993	18323	261	6.281915	16.39579815	Mitovirus sp.	2587224	Viruses	Viruses	156	1.76e-33	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g18137	i0	91.228	1.1264367816092	114	10	44	0	148	261	116	3	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	294	156	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
2881347	2881347	PRJNA1214993_P_NODE_9543_length_354_cov_0.971530_g9357_i0	PRJNA1214993	9543	354	0.97153	3.4392162	Zebrafish picornavirus 1	2304617	Viruses	Viruses	588	2.0599999999999994e-163	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9357	i0	96.884	2.99717514124294	353	8	99	3	5	354	3032	3384	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1061	588	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6708215	6708215	PRJNA1214993_P_NODE_7746_length_388_cov_2.495238_g7560_i0	PRJNA1214993	7746	388	2.495238	9.68152344	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	634	2.8899999999999995e-177	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g7560	i0	96.134	1	388	15	100	0	1	388	90	477	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	388	634	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
7983720	7983720	PRJNA1214993_P_NODE_1827_length_772_cov_1.961373_g1662_i0	PRJNA1214993	1827	772	1.961373	15.14179956	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1299	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g1662	i0	97.021	3	772	23	100	0	1	772	3824	4595	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2316	1299	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13083995	13083995	PRJNA1214993_P_NODE_19571_length_253_cov_1.344444_g19385_i0	PRJNA1214993	19571	253	1.344444	3.40144332	Zebrafish picornavirus 1	2304617	Viruses	Viruses	388	1.5399999999999998e-103	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g19385	i0	94.444	2.98814229249012	252	14	99	0	1	252	1909	2160	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	756	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13084049	13084049	PRJNA1214993_P_NODE_26771_length_225_cov_5.592105_g26585_i0	PRJNA1214993	26771	225	5.592105	12.58223625	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	178	3.16e-40	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g26585	i0	97.143	0.466666666666667	105	3	47	0	121	225	1	105	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	105	178	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14359265	14359265	PRJNA1214993_P_NODE_12_length_4932_cov_16.048570_g6_i0	PRJNA1214993	12	4932	16.04857	791.5154724	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2342	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g6	i0	91.529	0.684712084347121	1700	140	68	4	3235	4932	5329	7026	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3377	2342	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15633274	15633274	PRJNA1214993_P_NODE_5593_length_453_cov_1.589474_g5408_i0	PRJNA1214993	5593	453	1.589474	7.20031722	Zebrafish picornavirus 1	2304617	Viruses	Viruses	793	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g5408	i0	98.234	3	453	8	100	0	1	453	3866	3414	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1359	793	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23282440	23282440	PRJNA1214993_P_NODE_15259_length_284_cov_24.654028_g15073_i0	PRJNA1214993	15259	284	24.654028	70.01743952	Mitovirus sp.	2587224	Viruses	Viruses	134	9.1e-27	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g15073	i0	88.393	0.394366197183099	112	12	39	1	5	116	1	111	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	112	134	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
23282455	23282455	PRJNA1214993_P_NODE_1819_length_774_cov_2.400856_g1654_i0	PRJNA1214993	1819	774	2.400856	18.58262544	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1236	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g1654	i0	95.478	3	774	35	100	0	1	774	4853	5626	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2322	1236	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23282594	23282594	PRJNA1214993_P_NODE_99_length_2294_cov_3.776677_g66_i0	PRJNA1214993	99	2294	3.776677	86.63697038	Zebrafish picornavirus 1	2304617	Viruses	Viruses	3904	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g66	i0	97.384	3	2294	60	100	0	1	2294	5568	7861	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	6882	3904	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24556400	24556400	PRJNA1214993_P_NODE_1420_length_863_cov_5.131646_g1268_i0	PRJNA1214993	1420	863	5.131646	44.28610498	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	388	5.84e-103	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1268	i0	92.884	0.309385863267671	267	19	31	0	336	602	1708	1442	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	267	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
24556545	24556545	PRJNA1214993_P_NODE_7320_length_399_cov_1.343558_g7134_i0	PRJNA1214993	7320	399	1.343558	5.36079642	Zebrafish picornavirus 1	2304617	Viruses	Viruses	616	1.0799999999999999e-171	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7134	i0	94.486	3	399	22	100	0	1	399	1249	1647	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1197	616	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);;