metadata: contig_metadata: 12 rows where bioproject = "PRJEB12982" and tax

12 rows where bioproject = "PRJEB12982" 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_genus	tax_species
1295220	1295220	PRJEB12982_P_NODE_3582_length_405_cov_1.522472_g3419_i0	PRJEB12982	3582	405	1.522472	6.1660116	Zebrafish picornavirus 1	2304617	Viruses	Viruses	625	1.8299999999999995e-174	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g3419	i0	94.554	2.99259259259259	404	22	99	0	1	404	5149	5552	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1212	625	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5123264	5123264	PRJEB12982_P_NODE_13185_length_193_cov_1.055556_g13022_i0	PRJEB12982	13185	193	1.055556	2.03722308	Zebrafish picornavirus 1	2304617	Viruses	Viruses	318	1.4899999999999995e-82	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g13022	i0	96.373	3	193	7	100	0	1	193	2662	2470	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	579	318	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6399221	6399221	PRJEB12982_P_NODE_9266_length_233_cov_1.951087_g9103_i0	PRJEB12982	9266	233	1.951087	4.54603271	Zebrafish picornavirus 1	2304617	Viruses	Viruses	381	2.3399999999999995e-101	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9103	i0	96.137	3	233	9	100	0	1	233	6005	6237	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	699	381	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8948046	8948046	PRJEB12982_P_NODE_7088_length_273_cov_1.227679_g6925_i0	PRJEB12982	7088	273	1.227679	3.35156367	Dicistroviridae sp.	1955144	Viruses	Viruses	115	7.160000000000001e-29	NR	XCO49366.1	1955144	g6925	i0	57.3	2.93406593406593	89	38	97.8	0	5	271	184	272	XCO49366.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	801	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
16597802	16597802	PRJEB12982_P_NODE_19914_length_163_cov_0.894737_g19751_i0	PRJEB12982	19914	163	0.894737	1.45842131	Sopidub virus	3131684	Viruses	Viruses	134	4.72e-27	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g19751	i0	84.783	5.17177914110429	138	16	82	4	5	138	2212	2076	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	843	134	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Sopidub virus
16597846	16597846	PRJEB12982_P_NODE_4594_length_352_cov_1.178218_g4431_i0	PRJEB12982	4594	352	1.178218	4.14732736	Zebrafish picornavirus 1	2304617	Viruses	Viruses	595	1.2299999999999994e-165	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g4431	i0	97.159	3	352	10	100	0	1	352	6636	6987	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1056	595	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17872647	17872647	PRJEB12982_P_NODE_4315_length_364_cov_1.298413_g4152_i0	PRJEB12982	4315	364	1.298413	4.72622332	Zebrafish picornavirus 1	2304617	Viruses	Viruses	645	1.2499999999999996e-180	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g4152	i0	98.626	3.00824175824176	364	5	100	0	1	364	6060	5697	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1095	645	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
20421609	20421609	PRJEB12982_P_NODE_17_length_3322_cov_6.748854_g15_i0	PRJEB12982	17	3322	6.748854	224.19692988	Picornavirales	464095	Viruses	Viruses	504	1.7699999999999995e-158	NR	NP_044946.1	64279	g15	i0	35.6	7.03943407585792	978	493	84.8	25	258	3074	16	895	NP_044946.1 capsid polyprotein, partial [Drosophila C virus]	diamond	23385	506	0.99604743083004	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
22973051	22973051	PRJEB12982_P_NODE_9059_length_237_cov_1.047872_g8896_i0	PRJEB12982	9059	237	1.047872	2.48345664	Zebrafish picornavirus 1	2304617	Viruses	Viruses	372	1.44e-98	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g8896	i0	95.299	2.9789029535865	234	11	99	0	3	236	1890	2123	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	706	372	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
26652896	26652896	PRJEB12982_P_NODE_381_length_1267_cov_2.582102_g311_i0	PRJEB12982	381	1267	2.582102	32.71523234	Dicistroviridae sp.	1955144	Viruses	Viruses	292	5.65e-84	NR	ULF99809.1	1955144	g311	i0	39.1	1.02999210734017	435	245	99.4	9	7	1266	1033	1462	ULF99809.1 MAG: replicase polyprotein [Dicistroviridae sp.]	diamond	1305	292	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
28416471	28416471	PRJEB12982_P_NODE_2406_length_499_cov_2.093333_g2245_i0	PRJEB12982	2406	499	2.093333	10.44573167	Viruses	10239	Viruses	Viruses	79.3	1.1e-13	NR	WPV63180.1	3083669	g2245	i0	28.7	1.64128256513026	164	110	96.8	2	17	499	614	773	WPV63180.1 MAG: RNA-dependent RNA polymerase [Wenzhou bat dicistrovirus 3]	diamond	819	79.7	0.994981179422836	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Wenzhou bat dicistrovirus 3
28669055	28669055	PRJEB12982_P_NODE_2047_length_544_cov_2.109091_g1888_i0	PRJEB12982	2047	544	2.109091	11.47345504	Picornavirales	464095	Viruses	Viruses	213	2.41e-60	NR	ULF99869.1	1955141	g1888	i0	55.3	11.8455882352941	179	80	98.7	0	540	4	1519	1697	ULF99869.1 MAG: hypothetical protein 1 [Cripavirus sp.]	diamond	6444	215	0.990697674418605	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus sp.

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