metadata: contig_metadata: 15 rows where bioproject = "PRJNA683669", tax_phylum = "Pisuviricota" and tax

15 rows where bioproject = "PRJNA683669", 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_genus	tax_species
6278878	6278878	PRJNA683669_P_NODE_20365_length_286_cov_1.248826_g20133_i0	PRJNA683669	20365	286	1.248826	3.57164236	Cripavirus	144051	Viruses	Viruses	424	4.86e-114	NTclustered	gi\|2196304203\|gb\|MZ679075.1\|	1955141	g20133	i0	93.357	7.24825174825175	286	19	100	0	1	286	697	982	MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds	blastn	2073	424	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus sp.
7043565	7043565	PRJNA683669_P_NODE_14306_length_342_cov_1.784387_g14075_i0	PRJNA683669	14306	342	1.784387	6.10260354	Hangzhou hydrellia griseola dicistrovirus 1	2905414	Viruses	Viruses	424	5.95e-114	NTclustered	gi\|2170811221\|gb\|MZ209736.1\|	2905414	g14075	i0	93.357	3.34502923976608	286	19	84	0	57	342	7749	8034	MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate YSP1FY336, complete genome	blastn	1144	424	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Hangzhou hydrellia griseola dicistrovirus 1
8318260	8318260	PRJNA683669_P_NODE_9187_length_422_cov_1.191977_g8956_i0	PRJNA683669	9187	422	1.191977	5.03014294	Dicistroviridae sp.	1955144	Viruses	Viruses	680	0	NTclustered	gi\|1836405876\|gb\|MN905999.1\|	1955144	g8956	i0	95.735	5.39810426540284	422	18	100	0	1	422	8143	8564	MAG: Dicistroviridae sp. isolate wag171dic3 genomic sequence, sequence	blastn	2278	680	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
12654250	12654250	PRJNA683669_P_NODE_15930_length_325_cov_1.099206_g15699_i0	PRJNA683669	15930	325	1.099206	3.5724195	Cripavirus	144051	Viruses	Viruses	440	5.579999999999999e-119	NTclustered	gi\|2196304203\|gb\|MZ679075.1\|	1955141	g15699	i0	91.077	9.98769230769231	325	29	100	0	1	325	1548	1872	MAG: Cripavirus sp. isolate 165b-k141_225497 nonstructural polyprotein gene, complete cds; and capsid polyprotein gene, partial cds	blastn	3246	440	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus sp.
13418996	13418996	PRJNA683669_P_NODE_32171_length_243_cov_1.129412_g31939_i0	PRJNA683669	32171	243	1.129412	2.74447116	Dicistroviridae sp.	1955144	Viruses	Viruses	364	2.479999999999999e-96	NTclustered	gi\|2756423324\|gb\|PP745452.1\|	1955144	g31939	i0	93.802	7.96296296296296	242	15	99	0	2	243	2953	3194	MAG: Dicistroviridae sp. isolate 129_15506 genomic sequence	blastn	1935	364	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
15203559	15203559	PRJNA683669_P_NODE_25472_length_254_cov_1.276243_g25240_i0	PRJNA683669	25472	254	1.276243	3.24165722	Viruses	10239	Viruses	Viruses	357	4.36e-94	NTclustered	gi\|2756423469\|gb\|PP745525.1\|	1955144	g25240	i0	92.095	9.91732283464567	253	20	99	0	2	254	373	625	MAG: Dicistroviridae sp. isolate 196_164348 genomic sequence	blastn	2519	359	0.994428969359331	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
22852255	22852255	PRJNA683669_P_NODE_14638_length_339_cov_0.868421_g14407_i0	PRJNA683669	14638	339	0.868421	2.94394719	Viruses	10239	Viruses	Viruses	516	9.44e-142	NTclustered	gi\|2170811218\|gb\|MZ209732.1\|	2905414	g14407	i0	94.1	10.7109144542773	339	20	100	0	1	339	4882	4544	MAG: Hangzhou hydrellia griseola dicistrovirus 1 isolate XHQTFY46, complete genome	blastn	3631	521	0.990403071017274	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Hangzhou hydrellia griseola dicistrovirus 1
28345410	28345410	PRJNA683669_P_NODE_18966_length_296_cov_2.331839_g18734_i0	PRJNA683669	18966	296	2.331839	6.90224344	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	168	6.65e-46	NR	XCM67837.1	3003959	g18734	i0	73.5	0.993243243243243	98	26	99.3	0	3	296	1423	1520	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	294	168	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28345417	28345417	PRJNA683669_P_NODE_23586_length_266_cov_1.637306_g23354_i0	PRJNA683669	23586	266	1.637306	4.35523396	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	95.9	1.03e-20	NR	XCM67837.1	3003959	g23354	i0	49.4	0.981203007518797	87	44	98.1	0	261	1	1305	1391	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	261	95.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28408642	28408642	PRJNA683669_P_NODE_26026_length_251_cov_0.865169_g25794_i0	PRJNA683669	26026	251	0.865169	2.17157419	Atrato Picorna-like virus	2689353	Viruses	Viruses	82.8	3.36e-16	NR	QHA33691.1	2689353	g25794	i0	48.1	2.92828685258964	79	41	94.4	0	13	249	2468	2546	QHA33691.1 polyprotein, partial [Atrato Picorna-like virus]	diamond	735	82.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Atrato Picorna-like virus
30366946	30366946	PRJNA683669_P_NODE_52_length_3275_cov_5.090256_g43_i0	PRJNA683669	52	3275	5.090256	166.705884	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	607	9.069999999999999e-197	NR	XCM67838.1	3003959	g43	i0	34.9	0.924274809160305	1009	567	87.2	18	297	3152	46	1021	XCM67838.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	3027	607	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30808896	30808896	PRJNA683669_P_NODE_4974_length_579_cov_2.784585_g4747_i0	PRJNA683669	4974	579	2.784585	16.12274715	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	275	1.1199999999999999e-81	NR	XCM67837.1	3003959	g4747	i0	65.6	0.994818652849741	192	66	99.5	0	2	577	1521	1712	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	576	275	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31187691	31187691	PRJNA683669_P_NODE_335_length_1885_cov_2.080022_g281_i0	PRJNA683669	335	1885	2.080022	39.2084147	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	628	9.83e-204	NR	XCM67837.1	3003959	g281	i0	55.7	0.905570291777188	569	244	90.1	4	1758	61	310	873	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	1707	628	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31219277	31219277	PRJNA683669_P_NODE_7175_length_477_cov_1.898515_g6944_i0	PRJNA683669	7175	477	1.898515	9.05591655	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	142	1.09e-35	NR	XCM67837.1	3003959	g6944	i0	42.2	1.0125786163522	161	90	100	2	477	1	1035	1194	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	483	142	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31504456	31504456	PRJNA683669_P_NODE_2996_length_758_cov_1.572263_g2791_i0	PRJNA683669	2996	758	1.572263	11.91775354	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	137	1.0699999999999999e-32	NR	XCM67837.1	3003959	g2791	i0	54.5	0.530343007915567	134	57	52.2	3	756	361	129	260	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	402	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3

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