metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA951388" 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
27468126	27468126	PRJNA951388_S_NODE_383_length_894_cov_3.880633_g292_i0	PRJNA951388	383	894	3.880633	34.69285902	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	75.5	5.22e-11	NR	XEQ84337.1	RQ13	g292	i0	30.4	1.69127516778523	168	104	52	3	92	556	288	455	XEQ84337.1 polyprotein, partial [Mink kobuvirus]	diamond	1512	75.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
27632479	27632479	PRJNA951388_S_NODE_684_length_743_cov_4.432836_g574_i0	PRJNA951388	684	743	4.432836	32.93597148	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	271	4.46e-86	NR	ADI48258.1	RQ13	g574	i0	55.2	2.95154777927322	239	101	96.5	4	719	3	1	233	ADI48258.1 3D, partial [Bat kobuvirus TM003k]	diamond	2193	272	0.996323529411765	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
28446993	28446993	PRJNA951388_S_NODE_426_length_863_cov_12.545570_g330_i0	PRJNA951388	426	863	12.54557	108.2682691	Gammaretrovirus murleu	3428959	Viruses	Viruses	582	2.9499999999999996e-206	NR	8WUS_E	11801	g330	i0	99	8.97914252607184	287	3	99.8	0	3	863	31	317	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	7749	582	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28958732	28958732	PRJNA951388_S_NODE_808_length_705_cov_4.901899_g695_i0	PRJNA951388	808	705	4.901899	34.55838795	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	59.3	4.47e-6	NR	XOL43542.1	RQ13	g695	i0	29	3.05957446808511	183	98	65.1	7	574	116	950	1130	XOL43542.1 polyprotein [Kobuvirus dekago]	diamond	2157	59.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
29772734	29772734	PRJNA951388_S_NODE_931_length_668_cov_134.105882_g816_i0	PRJNA951388	931	668	134.105882	895.82729176	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	77	3.34e-12	NR	QJX58422.1	RQ13	g816	i0	43.8	3.01796407185629	96	52	42.2	2	4	285	2264	2359	QJX58422.1 polyprotein [Salivirus A]	diamond	2016	77	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Salivirus	Zebrafish jaw picornavirus
30562441	30562441	PRJNA951388_S_NODE_6753_length_327_cov_1.862205_g6626_i0	PRJNA951388	6753	327	1.862205	6.08941035	Human immunodeficiency virus 1	11676	Viruses	Viruses	48.9	6.4e-4	NR	WAJ62392.1	11676	g6626	i0	35.4	3.00917431192661	82	43	75.2	1	44	289	330	401	WAJ62392.1 gag protein, partial [Human immunodeficiency virus 1]	diamond	984	48.9	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
30568974	30568974	PRJNA951388_S_NODE_5393_length_363_cov_1.593103_g5266_i0	PRJNA951388	5393	363	1.593103	5.78296389	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	114	9.06e-27	NR	YP_010796386.1	RQ13	g5266	i0	51.9	4.43801652892562	108	52	89.3	0	326	3	1354	1461	YP_010796386.1 polyprotein [tropivirus A1]	diamond	1611	115	0.991304347826087	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Tropivirus	Zebrafish jaw picornavirus
31257850	31257850	PRJNA951388_S_NODE_615_length_774_cov_11.880171_g507_i0	PRJNA951388	615	774	11.880171	91.95252354	Moloney murine leukemia virus	11801	Viruses	Viruses	493	4.71e-159	NR	NP_057933.2	11801	g507	i0	97.3	1	258	7	100	0	1	774	1076	1333	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	774	493	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31637328	31637328	PRJNA951388_S_NODE_7096_length_319_cov_3.621951_g6969_i0	PRJNA951388	7096	319	3.621951	11.55402369	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	137	7.48e-35	NR	QUS52515.1	RQ13	g6969	i0	61.2	1.93730407523511	103	40	96.9	0	6	314	2223	2325	QUS52515.1 polyprotein [ludopivirus A1]	diamond	618	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Ludopivirus	Zebrafish jaw picornavirus
32750464	32750464	PRJNA951388_S_NODE_10140_length_259_cov_5.161290_g10013_i0	PRJNA951388	10140	259	5.16129	13.3677411	Mitoviridae	2732892	Viruses	Viruses	93.6	5.99e-20	NR	YP_010799405.1	2497445	g10013	i0	50	4.06563706563707	92	40	99.6	1	259	2	125	216	YP_010799405.1 RNA-dependent RNA polymerase [Nigrospora oryzae mitovirus 2]	diamond	1053	94.4	0.991525423728813	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Unuamitovirus	Unuamitovirus nior2

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