metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
2174453	2174453	PRJNA924320_S_NODE_25342_length_212_cov_1.245399_g25200_i0	PRJNA924320	25342	212	1.245399	2.64024588	Zebrafish picornavirus 1	2304617	Viruses	Viruses	348	2.12e-91	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g25200	i0	96.244	3.00943396226415	213	7	100	1	1	212	7470	7258	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	638	348	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6002188	6002188	PRJNA924320_S_NODE_11925_length_286_cov_3.308017_g11783_i0	PRJNA924320	11925	286	3.308017	9.46092862	Mitovirus sp.	2587224	Viruses	Viruses	169	2.52e-37	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g11783	i0	94.495	3.27272727272727	109	6	38	0	2	110	4	112	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	936	169	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
11455974	11455974	PRJNA924320_S_NODE_47869_length_166_cov_0.880342_g47727_i0	PRJNA924320	47869	166	0.880342	1.46136772	root	1	Root_unresolved	Root_unresolved	274	2.73e-69	NTclustered	gi\|332890\|gb\|M12197.1\|POL2LAN	12083	g47727	i0	96.386	99.0481927710843	166	6	100	0	1	166	455	290	Poliovirus type 2 (Lansing strain), complete genome	blastn	16442	274	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Enterovirus	Enterovirus coxsackiepol
19103629	19103629	PRJNA924320_S_NODE_34195_length_189_cov_1.357143_g34053_i0	PRJNA924320	34195	189	1.357143	2.56500027	root	1	Root_unresolved	Root_unresolved	329	6.69e-86	NTclustered	gi\|332890\|gb\|M12197.1\|POL2LAN	12083	g34053	i0	100	52.2751322751323	178	0	94	0	12	189	735	558	Poliovirus type 2 (Lansing strain), complete genome	blastn	9880	329	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Enterovirus	Enterovirus coxsackiepol
20025753	20025753	PRJNA924320_S_NODE_17176_length_246_cov_2.010152_g17034_i0	PRJNA924320	17176	246	2.010152	4.94497392	Zebrafish picornavirus 1	2304617	Viruses	Viruses	438	1.4599999999999996e-118	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g17034	i0	98.78	3	246	3	100	0	1	246	6250	6495	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	738	438	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20026042	20026042	PRJNA924320_S_NODE_54696_length_162_cov_1.353982_g54554_i0	PRJNA924320	54696	162	1.353982	2.19345084	Zebrafish picornavirus 1	2304617	Viruses	Viruses	289	9.44e-74	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g54554	i0	98.765	3	162	2	100	0	1	162	5972	6133	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	486	289	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
21301024	21301024	PRJNA924320_S_NODE_12277_length_283_cov_1.709402_g12135_i0	PRJNA924320	12277	283	1.709402	4.83760766	Zebrafish picornavirus 1	2304617	Viruses	Viruses	501	2.1599999999999998e-137	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g12135	i0	98.587	3	283	4	100	0	1	283	7112	6830	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	849	501	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);;