metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA781427" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA781427" and tax_kingdom = "Orthornavirae"

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
26958459	26958459	PRJNA781427_P_NODE_93282_length_242_cov_1.366864_g92398_i0	PRJNA781427	93282	242	1.366864	3.30781088	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	143	1.28e-37	NR	XCM68434.1	3003959	g92398	i0	80	0.991735537190083	80	16	99.2	0	2	241	606	685	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	240	143	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27369950	27369950	PRJNA781427_P_NODE_65983_length_272_cov_0.839196_g65099_i0	PRJNA781427	65983	272	0.839196	2.28261312	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	83.6	2.37e-16	NR	XCM67874.1	3003959	g65099	i0	45.6	2.00735294117647	90	43	94.9	3	258	1	129	216	XCM67874.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	546	83.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27527468	27527468	PRJNA781427_P_NODE_51003_length_315_cov_1.590909_g50120_i0	PRJNA781427	51003	315	1.590909	5.01136335	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	196	4.399999999999999e-56	NR	XCM67775.1	3003959	g50120	i0	90.3	0.980952380952381	103	10	98.1	0	311	3	412	514	XCM67775.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	309	196	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27590909	27590909	PRJNA781427_P_NODE_86864_length_245_cov_1.343023_g85980_i0	PRJNA781427	86864	245	1.343023	3.29040635	Picornaviridae sp.	1530251	Viruses	Viruses	93.6	4.93e-20	NR	URG14823.1	1530251	g85980	i0	53.6	1.02857142857143	84	36	99.2	1	243	1	572	655	URG14823.1 MAG: capsid protein [Picornaviridae sp.]	diamond	252	93.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
27811916	27811916	PRJNA781427_P_NODE_9344_length_877_cov_1.555970_g8654_i0	PRJNA781427	9344	877	1.55597	13.6458569	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	559	2.469999999999999e-183	NR	UNY42002.1	3003959	g8654	i0	90	0.995438996579247	291	29	99.5	0	875	3	1200	1490	UNY42002.1 MAG: polyprotein 1 [Picornavirales sp.]	diamond	873	559	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28159225	28159225	PRJNA781427_P_NODE_15765_length_633_cov_1.653571_g14929_i0	PRJNA781427	15765	633	1.653571	10.46710443	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	400	7.639999999999999e-126	NR	UNY42002.1	3003959	g14929	i0	90	1	211	21	100	0	1	633	977	1187	UNY42002.1 MAG: polyprotein 1 [Picornavirales sp.]	diamond	633	400	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28348442	28348442	PRJNA781427_P_NODE_70906_length_259_cov_1.172043_g70022_i0	PRJNA781427	70906	259	1.172043	3.03559137	Picornaviridae sp.	1530251	Viruses	Viruses	171	3.0699999999999997e-48	NR	URG14866.1	1530251	g70022	i0	91.8	0.984555984555985	85	7	98.5	0	3	257	37	121	URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	255	171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28380038	28380038	PRJNA781427_P_NODE_9366_length_876_cov_1.547945_g8674_i0	PRJNA781427	9366	876	1.547945	13.5599982	Wenzhou rodent rhabdovirus 1	3084690	Viruses	Viruses	55.1	9.28e-5	NR	WPV62747.1	3084690	g8674	i0	36.3	0.349315068493151	102	64	34.9	1	310	5	159	259	WPV62747.1 MAG: phosphoprotein [Wenzhou rodent rhabdovirus 1]	diamond	306	55.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Wenzhou rodent rhabdovirus 1
28569418	28569418	PRJNA781427_P_NODE_8487_length_931_cov_2.078089_g7836_i0	PRJNA781427	8487	931	2.078089	19.34700859	Picornaviridae sp.	1530251	Viruses	Viruses	270	7.88e-80	NR	URG14823.1	1530251	g7836	i0	57.6	0.766917293233083	238	99	76.4	2	216	926	8	244	URG14823.1 MAG: capsid protein [Picornaviridae sp.]	diamond	714	270	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29011824	29011824	PRJNA781427_P_NODE_15728_length_634_cov_1.686275_g14892_i0	PRJNA781427	15728	634	1.686275	10.6909835	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	378	1.6099999999999998e-125	NR	UNY42003.1	3003959	g14892	i0	84.3	1.98738170347003	210	33	99.4	0	1	630	368	577	UNY42003.1 MAG: polyprotein 2 [Picornavirales sp.]	diamond	1260	378	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29169531	29169531	PRJNA781427_P_NODE_52749_length_309_cov_1.631356_g51866_i0	PRJNA781427	52749	309	1.631356	5.04089004	Picornaviridae sp.	1530251	Viruses	Viruses	137	3.54e-35	NR	URG14823.1	1530251	g51866	i0	57	0.970873786407767	100	43	97.1	0	300	1	423	522	URG14823.1 MAG: capsid protein [Picornaviridae sp.]	diamond	300	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29295679	29295679	PRJNA781427_P_NODE_84709_length_246_cov_1.335260_g83825_i0	PRJNA781427	84709	246	1.33526	3.2847396	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	150	6.4e-40	NR	XCM68374.1	3003959	g83825	i0	81.7	1	82	15	100	0	246	1	384	465	XCM68374.1 MAG: helicase, partial [Picornavirales sp.]	diamond	246	150	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29484843	29484843	PRJNA781427_P_NODE_66550_length_270_cov_1.329949_g65666_i0	PRJNA781427	66550	270	1.329949	3.5908623	Picornaviridae sp.	1530251	Viruses	Viruses	188	1.59e-54	NR	URG14866.1	1530251	g65666	i0	98.9	0.988888888888889	89	1	98.9	0	3	269	142	230	URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	267	188	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29579607	29579607	PRJNA781427_P_NODE_87090_length_245_cov_0.895349_g86206_i0	PRJNA781427	87090	245	0.895349	2.19360505	Picornaviridae sp.	1530251	Viruses	Viruses	99.4	4.69e-22	NR	URG14822.1	1530251	g86206	i0	45.7	0.991836734693878	81	44	99.2	0	2	244	1139	1219	URG14822.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.]	diamond	243	99.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29588845	29588845	PRJNA781427_P_NODE_63450_length_278_cov_1.453659_g62566_i0	PRJNA781427	63450	278	1.453659	4.04117202	Cripavirus	144051	Viruses	Viruses	155	1.0699999999999998e-41	NR	ASH89118.1	2005444	g62566	i0	83.7	1.98561151079137	92	15	99.3	0	278	3	2254	2345	ASH89118.1 P1 [Aphis glycines virus 3]	diamond	552	155	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Aphis glycines virus 3
29642676	29642676	PRJNA781427_P_NODE_9910_length_848_cov_1.185806_g9201_i0	PRJNA781427	9910	848	1.185806	10.05563488	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	525	2.87e-170	NR	XCM67774.1	3003959	g9201	i0	91.8	0.997641509433962	282	23	99.8	0	847	2	1046	1327	XCM67774.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	846	525	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
29715139	29715139	PRJNA781427_P_NODE_63990_length_277_cov_1.132353_g63106_i0	PRJNA781427	63990	277	1.132353	3.13661781	Viruses	10239	Viruses	Viruses	113	9.74e-27	NR	XCM68226.1	1955153	g63106	i0	60.4	1.97111913357401	91	36	98.6	0	3	275	749	839	XCM68226.1 MAG: polyprotein, partial [Picornavirales sp.]	diamond	546	114	0.991228070175439	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
29927380	29927380	PRJNA781427_P_NODE_73731_length_251_cov_2.011236_g72847_i0	PRJNA781427	73731	251	2.011236	5.04820236	Flumine hepe-like virus 8	2941079	Viruses	Viruses	81.3	9.62e-16	NR	UQB76219.1	2941079	g72847	i0	100	0.466135458167331	39	0	46.6	0	1	117	393	431	UQB76219.1 non-structural polyprotein, partial [Flumine hepe-like virus 8]	diamond	117	81.3	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Hepeviridae		Flumine hepe-like virus 8
30275031	30275031	PRJNA781427_P_NODE_72972_length_253_cov_1.711111_g72088_i0	PRJNA781427	72972	253	1.711111	4.32911083	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	100	2.73e-22	NR	XCM68051.1	3003959	g72088	i0	56.5	1.96837944664032	85	35	98.4	1	251	3	522	606	XCM68051.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	498	100	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30558878	30558878	PRJNA781427_P_NODE_53_length_5919_cov_8.605029_g47_i0	PRJNA781427	53	5919	8.605029	509.33166651	Hepelivirales sp.	2809460	Viruses	Viruses	456	7.3e-128	NR	WAY16450.1	2809460	g47	i0	33.7	0.432843385707045	854	528	41.9	15	1659	4136	898	1741	WAY16450.1 nonstructural polyprotein [Hepelivirales sp.]	diamond	2562	456	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Hepelivirales sp.
30938396	30938396	PRJNA781427_P_NODE_43754_length_343_cov_1.996296_g42872_i0	PRJNA781427	43754	343	1.996296	6.84729528	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	107	3.4e-24	NR	XCM67872.1	3003959	g42872	i0	48.6	2.73760932944606	111	55	97.1	1	9	341	881	989	XCM67872.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	939	107	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31064856	31064856	PRJNA781427_P_NODE_20095_length_541_cov_2.004274_g19230_i0	PRJNA781427	20095	541	2.004274	10.84312234	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	314	9.879999999999999e-99	NR	XCM67775.1	3003959	g19230	i0	83.8	0.992606284658041	179	29	99.3	0	3	539	527	705	XCM67775.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	537	314	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31285746	31285746	PRJNA781427_P_NODE_35635_length_385_cov_1.942308_g34753_i0	PRJNA781427	35635	385	1.942308	7.4778858	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	241	6.65e-72	NR	XCM67775.1	3003959	g34753	i0	86.7	0.997402597402597	128	17	99.7	0	2	385	164	291	XCM67775.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	384	241	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31665348	31665348	PRJNA781427_P_NODE_77257_length_250_cov_0.870056_g76373_i0	PRJNA781427	77257	250	0.870056	2.17514	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	172	8.539999999999999e-48	NR	UNY42028.1	3003959	g76373	i0	92.8	1.992	83	6	99.6	0	1	249	2364	2446	UNY42028.1 MAG: polyprotein [Picornavirales sp.]	diamond	498	172	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31918503	31918503	PRJNA781427_P_NODE_24517_length_480_cov_1.690418_g23638_i0	PRJNA781427	24517	480	1.690418	8.1140064	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	298	3.4199999999999998e-90	NR	XCM67774.1	3003959	g23638	i0	86.2	0.99375	159	22	99.4	0	3	479	840	998	XCM67774.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	477	298	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32330155	32330155	PRJNA781427_P_NODE_51559_length_313_cov_1.604167_g50676_i0	PRJNA781427	51559	313	1.604167	5.02104271	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	138	2.8299999999999996e-35	NR	WEU70895.1	3029006	g50676	i0	69.2	0.996805111821086	104	32	99.7	0	312	1	2533	2636	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	312	138	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Hangzhou marna-like virus 1

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