metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA672101" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA672101" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26796934	26796934	PRJNA672101_S_NODE_13381_length_322_cov_5.361446_g13350_i0	PRJNA672101	13381	322	5.361446	17.26385612	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	52	5.46e-5	NR	QDH87818.1	3003959	g13350	i0	39.2	1.35093167701863	74	43	67.1	2	89	304	562	635	QDH87818.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.]	diamond	435	52	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27251693	27251693	PRJNA672101_S_NODE_13683_length_320_cov_6.619433_g13652_i0	PRJNA672101	13683	320	6.619433	21.1821856	Iflavirus	232799	Viruses	Viruses	47	0.00312	NR	DBA62680.1	1916690	g13652	i0	27.5	3.515625	109	60	84.4	2	1	270	651	759	DBA62680.1 TPA_asm: polyprotein [Iflavirus sp.]	diamond	1125	47	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sp.
27334763	27334763	PRJNA672101_S_NODE_11623_length_335_cov_2.286260_g11592_i0	PRJNA672101	11623	335	2.28626	7.658971	Marseillevirus LCMAC2	2506606	Viruses	Viruses	40.8	0.0368	NR	QBK88125.1	2506606	g11592	i0	59.4	0.286567164179104	32	13	28.7	0	334	239	4	35	QBK88125.1 MAG: hypothetical protein LCMAC202_04870 [Marseillevirus LCMAC202]	diamond	96	40.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC202
28029407	28029407	PRJNA672101_S_NODE_20405_length_283_cov_4.538095_g20374_i0	PRJNA672101	20405	283	4.538095	12.84280885	Betapolyomavirus macacae	1891767	Viruses	Viruses	72.8	1.62e-12	NR	AAK29054.1	1891767	g20374	i0	79.5	0.46643109540636	44	9	46.6	0	142	273	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	132	72.8	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
28092416	28092416	PRJNA672101_S_NODE_2525_length_476_cov_2.109181_g2494_i0	PRJNA672101	2525	476	2.109181	10.03970156	Coleopteran tombus-related virus	2822551	Viruses	Viruses	258	1.08e-81	NR	QTJ63697.1	2822551	g2494	i0	76.6	0.995798319327731	158	37	99.6	0	476	3	207	364	QTJ63697.1 RNA-dependent RNA polymerase [Coleopteran tombus-related virus]	diamond	474	258	1	Viruses		Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Coleopteran tombus-related virus
28186938	28186938	PRJNA672101_S_NODE_5966_length_392_cov_1.805643_g5935_i0	PRJNA672101	5966	392	1.805643	7.07812056	Crocidura lasiura aparavirus	3139585	Viruses	Viruses	134	2.449999999999999e-38	NR	WZI33169.1	3139585	g5935	i0	80.3	0.581632653061224	76	15	58.2	0	161	388	1	76	WZI33169.1 MAG: hypothetical protein, partial [Crocidura lasiura aparavirus]	diamond	228	134	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Aparavirus	Crocidura lasiura aparavirus
28629397	28629397	PRJNA672101_S_NODE_35007_length_218_cov_4.137931_g34976_i0	PRJNA672101	35007	218	4.137931	9.02068958	Hepacivirus hominis	3052230	Viruses	Viruses	70.5	4.59e-12	NR	AHK22794.1	3052230	g34976	i0	68.6	0.701834862385321	51	16	70.2	0	6	158	2559	2609	AHK22794.1 polyprotein [Hepacivirus hominis]	diamond	153	70.5	1	Viruses		Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Hepacivirus	Hepacivirus hominis
28945213	28945213	PRJNA672101_S_NODE_108_length_1075_cov_10.008982_g93_i0	PRJNA672101	108	1075	10.008982	107.5965565	Sclerotinia sclerotiorum mycoreovirus 4	1840528	Viruses	Viruses	54.3	2.93e-4	NR	YP_009252400.1	1840528	g93	i0	34.2	0.326511627906977	117	62	32.4	3	462	115	160	262	YP_009252400.1 P10 [Sclerotinia sclerotiorum mycoreovirus 4]	diamond	351	54.3	1	Viruses		Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Mycoreovirus	Sclerotinia sclerotiorum mycoreovirus 4
29071435	29071435	PRJNA672101_S_NODE_20128_length_285_cov_1.320755_g20097_i0	PRJNA672101	20128	285	1.320755	3.76415175	Moloney murine leukemia virus	11801	Viruses	Viruses	191	4.7999999999999997e-54	NR	NP_057933.2	11801	g20097	i0	98.9	2	95	1	100	0	285	1	1128	1222	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	570	191	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
29513107	29513107	PRJNA672101_S_NODE_10350_length_345_cov_2.974265_g10319_i0	PRJNA672101	10350	345	2.974265	10.26121425	Nete virus	2703871	Viruses	Viruses	171	2.31e-47	NR	QIQ61196.1	2703871	g10319	i0	71.1	0.991304347826087	114	33	99.1	0	344	3	157	270	QIQ61196.1 MAG: putative RNA dependent RNA polymerase [Nete virus]	diamond	342	171	1	Viruses	Quenyaviruses							Nete virus
29670788	29670788	PRJNA672101_S_NODE_9210_length_355_cov_3.393617_g9179_i0	PRJNA672101	9210	355	3.393617	12.04734035	Podoviridae sp. ctlpi2	2826574	Viruses	Viruses	44.7	0.0297	NR	DAD83088.1	2826574	g9179	i0	48.1	0.456338028169014	54	24	44.8	3	26	184	1	51	DAD83088.1 MAG TPA: crystallin beta/gamma motif-containing protein [Podoviridae sp. ctlpi2]	diamond	162	44.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Podoviridae sp. ctlpi2
29840979	29840979	PRJNA672101_S_NODE_6831_length_380_cov_6.019544_g6800_i0	PRJNA672101	6831	380	6.019544	22.8742672	Sadwavirus	215920	Viruses	Viruses	101	4.35e-22	NR	ASU55991.1	2170181	g6800	i0	46	3.56842105263158	113	59	89.2	1	349	11	1520	1630	ASU55991.1 polyprotein [Dioscorea mosaic associated virus]	diamond	1356	101	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Sadwavirus	Sadwavirus dioscoreae
30871577	30871577	PRJNA672101_S_NODE_21514_length_278_cov_8.321951_g21483_i0	PRJNA672101	21514	278	8.321951	23.13502378	Megavirus haemonchus182742	3116716	Viruses	Viruses	53.1	1.2e-5	NR	DBA46289.1	3116716	g21483	i0	34.5	0.62589928057554	58	38	62.6	0	3	176	407	464	DBA46289.1 MAG TPA_asm: Egfoid2 [Megavirus haemonchus182742]	diamond	174	53.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus haemonchus182742
30883535	30883535	PRJNA672101_S_NODE_14_length_2056_cov_10.640444_g11_i0	PRJNA672101	14	2056	10.640444	218.76752864	Picornavirales	464095	Viruses	Viruses	101	6.92e-18	NR	UBX89813.1	680112	g11	i0	28.4	2.28939688715953	296	190	41	7	131	973	1434	1722	UBX89813.1 polyprotein [Carrot necrotic dieback virus]	diamond	4707	101	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Sequivirus	Sequivirus carotae
31092804	31092804	PRJNA672101_S_NODE_17295_length_298_cov_6.213333_g17264_i0	PRJNA672101	17295	298	6.213333	18.51573234	PNG bee virus 4	2746881	Viruses	Viruses	51.6	5.51e-5	NR	QKW94206.1	2746881	g17264	i0	49	0.513422818791946	51	23	51.3	1	15	167	1292	1339	QKW94206.1 non-structural polyprotein [PNG bee virus 4]	diamond	153	51.6	1	Viruses								PNG bee 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);;