metadata: contig_metadata: 8 rows where bioproject = "PRJNA379145" and tax

8 rows where bioproject = "PRJNA379145" 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
1675308	1675308	PRJNA379145_P_NODE_18942_length_622_cov_2.073005_g17116_i0	PRJNA379145	18942	622	2.073005	12.8940911	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	363	2.51e-95	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g17116	i0	92.49	0.406752411575563	253	19	41	0	1	253	1694	1442	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	253	363	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
1675885	1675885	PRJNA379145_P_NODE_73622_length_151_cov_1.813559_g71467_i0	PRJNA379145	73622	151	1.813559	2.73847409	Zebrafish picornavirus 1	2304617	Viruses	Viruses	268	1.12e-67	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g71467	i0	98.675	3	151	2	100	0	1	151	1242	1392	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	453	268	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
2951642	2951642	PRJNA379145_P_NODE_543_length_2859_cov_5.615711_g450_i0	PRJNA379145	543	2859	5.615711	160.55317749	Zebrafish picornavirus 1	2304617	Viruses	Viruses	4732	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g450	i0	96.537	3.0912906610703	2859	99	100	0	1	2859	5284	8142	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	8838	4732	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
13154297	13154297	PRJNA379145_P_NODE_14831_length_741_cov_2.179379_g13238_i0	PRJNA379145	14831	741	2.179379	16.14919839	Zebrafish picornavirus 1	2304617	Viruses	Viruses	710	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g13238	i0	94.248	2.95816464237517	452	26	99	0	290	741	4803	5254	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	2192	710	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
18252485	18252485	PRJNA379145_P_NODE_35_length_5346_cov_14.880858_g28_i0	PRJNA379145	35	5346	14.880858	795.53066868	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2516	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g28	i0	92.144	0.667040778151889	1782	136	67	4	3566	5345	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3566	2516	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
20801986	20801986	PRJNA379145_P_NODE_12197_length_845_cov_2.288177_g10822_i0	PRJNA379145	12197	845	2.288177	19.33509565	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	1053	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g10822	i0	96.546	0.753846153846154	637	21	75	1	37	673	4	639	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	637	1053	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
30833247	30833247	PRJNA379145_P_NODE_49294_length_237_cov_2.323529_g47140_i0	PRJNA379145	49294	237	2.323529	5.50676373	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	163	1.69e-44	NR	WKU61618.1	3063761	g47140	i0	98.7	1	79	1	100	0	1	237	156	234	WKU61618.1 polyprotein [Zebrafish picornavirus 2]	diamond	237	163	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
30928178	30928178	PRJNA379145_P_NODE_56254_length_203_cov_2.152941_g54100_i0	PRJNA379145	56254	203	2.152941	4.37047023	Panax cryptic virus 4	2809267	Viruses	Viruses	115	2.5599999999999998e-28	NR	QRG29207.1	2809267	g54100	i0	77.6	0.990147783251232	67	15	99	0	202	2	193	259	QRG29207.1 putative CP [Panax cryptic virus 4]	diamond	201	115	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Panax cryptic virus 4

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