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

7 rows where analysis = "blastn", bioproject = "PRJNA685607" and tax_phylum = "Pisuviricota"

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_species
2451758	2451758	PRJNA685607_P_NODE_77002_length_247_cov_0.885057_g76643_i0	PRJNA685607	77002	247	0.885057	2.18609079	Picornavirales	464095	Viruses	Viruses	444	3.15e-120	NTclustered	gi\|2245485642\|gb\|ON161938.1\|	1530251	g76643	i0	99.187	4.93117408906883	246	2	99	0	2	247	4088	3843	MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds	blastn	1218	444	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
7044896	7044896	PRJNA685607_P_NODE_1186_length_1501_cov_2.228291_g1042_i0	PRJNA685607	1186	1501	2.228291	33.44664791	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	760	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1042	i0	93.529	0.62491672218521	510	33	62	0	219	728	4195	4704	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	938	760	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
10870496	10870496	PRJNA685607_P_NODE_87789_length_244_cov_0.900585_g87430_i0	PRJNA685607	87789	244	0.900585	2.1974274	Zebrafish picornavirus 1	2304617	Viruses	Viruses	392	1.14e-104	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g87430	i0	96.234	2.93852459016393	239	9	98	0	1	239	1860	2098	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	717	392	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
12145579	12145579	PRJNA685607_P_NODE_18730_length_385_cov_1.307692_g18372_i0	PRJNA685607	18730	385	1.307692	5.0346142	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	512	1.4000000000000001e-140	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g18372	i0	93.586	0.890909090909091	343	22	89	0	43	385	2543	2201	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	343	512	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
15969014	15969014	PRJNA685607_P_NODE_43633_length_291_cov_1.412844_g43274_i0	PRJNA685607	43633	291	1.412844	4.11137604	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	115	3.39e-21	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g43274	i0	91.566	0.285223367697594	83	7	29	0	209	291	1708	1626	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	83	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
18518333	18518333	PRJNA685607_P_NODE_1875_length_1190_cov_3.471799_g1663_i0	PRJNA685607	1875	1190	3.471799	41.3144081	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	1661	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1663	i0	91.919	0.998319327731092	1188	94	99	2	4	1190	6782	5596	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	1188	1661	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
21068654	21068654	PRJNA685607_P_NODE_12117_length_456_cov_1.530026_g11760_i0	PRJNA685607	12117	456	1.530026	6.97691856	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	370	1.07e-97	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g11760	i0	94.915	0.517543859649123	236	12	52	0	213	448	3703	3938	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	236	370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	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);;