metadata: contig_metadata: 9 rows where bioproject = "PRJDB4470", tax_phylum = "Pisuviricota" and tax

9 rows where bioproject = "PRJDB4470", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

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
6388034	6388034	PRJDB4470_P_NODE_7446_length_887_cov_49.661098_g6452_i1	PRJDB4470	7446	887	49.661098	440.49393926	Skokie dicistro-like virus	2789443	Viruses	Viruses	1480	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g6452	i1	99.03	1.90529875986471	825	8	93	0	42	866	5323	4499	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1690	1480	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Skokie dicistro-like virus
8936730	8936730	PRJDB4470_P_NODE_728_length_2103_cov_2.588608_g593_i0	PRJDB4470	728	2103	2.588608	54.43842624	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	693	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g593	i0	94.82	0.300047551117451	444	23	30	0	567	1010	2100	2543	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	631	693	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
11487898	11487898	PRJDB4470_P_NODE_90_length_3437_cov_37.488194_g73_i0	PRJDB4470	90	3437	37.488194	1288.46922778	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2527	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g73	i0	92.256	0.877218504509747	1782	134	88	4	1654	3433	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3015	2527	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
14037565	14037565	PRJDB4470_P_NODE_45172_length_314_cov_1.366038_g44019_i0	PRJDB4470	45172	314	1.366038	4.28935932	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	473	5.29e-129	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g44019	i0	96.82	0.901273885350318	283	9	90	0	32	314	4	286	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	283	473	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
15311931	15311931	PRJDB4470_P_NODE_7193_length_901_cov_28.205399_g6452_i0	PRJDB4470	7193	901	28.205399	254.13064499	Skokie dicistro-like virus	2789443	Viruses	Viruses	1365	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g6452	i0	96.062	1.90455049944506	838	33	93	0	42	879	5323	4486	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1716	1365	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Skokie dicistro-like virus
17861689	17861689	PRJDB4470_P_NODE_81875_length_195_cov_3.198630_g80720_i0	PRJDB4470	81875	195	3.19863	6.2373285	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	235	1.56e-57	NTclustered	gi\|1940198121\|gb\|MT757492.1\|	2789378	g80720	i0	87.907	2.2974358974359	215	6	100	7	1	195	9133	8919	Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds	blastn	448	235	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Shenzhen dicistro-like virus
24235326	24235326	PRJDB4470_P_NODE_40480_length_341_cov_1.729452_g39328_i0	PRJDB4470	40480	341	1.729452	5.89743132	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	182	3.94e-41	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g39328	i0	94.872	0.343108504398827	117	5	34	1	225	341	1105	990	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	117	182	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
27285350	27285350	PRJDB4470_P_NODE_98983_length_171_cov_1.073770_g97828_i0	PRJDB4470	98983	171	1.07377	1.8361467	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	71.2	1.23e-12	NR	AVM87439.1	3063761	g97828	i0	56.4	0.964912280701754	55	24	96.5	0	5	169	327	381	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	165	71.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Danio blood picornavirus/Zebrafish picornavirus 2
28864068	28864068	PRJDB4470_P_NODE_25988_length_460_cov_4.299270_g24852_i0	PRJDB4470	25988	460	4.29927	19.776642	Partitiviridae sp.	1955170	Viruses	Viruses	74.7	2.17e-12	NR	USE08357.1	1955170	g24852	i0	30.8	1.89130434782609	143	86	92.6	4	32	457	168	298	USE08357.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.]	diamond	870	74.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae	Partitiviridae 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);;