metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1074407" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1074407" 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
28141494	28141494	PRJNA1074407_P_NODE_103045_length_338_cov_0.943396_g99207_i0	PRJNA1074407	103045	338	0.943396	3.18867848	Picornaviridae sp.	1530251	Viruses	Viruses	207	2.93e-59	NR	XDJ26655.1	1530251	g99207	i0	86.6	0.994082840236686	112	15	99.4	0	2	337	1544	1655	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	336	207	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28457160	28457160	PRJNA1074407_P_NODE_77866_length_444_cov_1.843666_g74031_i0	PRJNA1074407	77866	444	1.843666	8.18587704	Picornaviridae sp.	1530251	Viruses	Viruses	258	1.54e-76	NR	XDJ26655.1	1530251	g74031	i0	85.7	0.993243243243243	147	21	99.3	0	442	2	1327	1473	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	441	258	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28457162	28457162	PRJNA1074407_P_NODE_78966_length_438_cov_1.504110_g75130_i0	PRJNA1074407	78966	438	1.50411	6.5880018	Picornaviridae sp.	1530251	Viruses	Viruses	111	2.88e-25	NR	XDJ26655.1	1530251	g75130	i0	100	0.376712328767123	55	0	37.7	0	165	1	1	55	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	165	111	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
28741166	28741166	PRJNA1074407_P_NODE_45007_length_751_cov_1.513274_g41354_i0	PRJNA1074407	45007	751	1.513274	11.36468774	Picornaviridae sp.	1530251	Viruses	Viruses	493	2.0299999999999996e-158	NR	XDJ26655.1	1530251	g41354	i0	96.8	0.994673768308921	249	8	99.5	0	3	749	639	887	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	747	493	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29774490	29774490	PRJNA1074407_P_NODE_123031_length_279_cov_2.165049_g119193_i0	PRJNA1074407	123031	279	2.165049	6.04048671	Iflavirus	232799	Viruses	Viruses	96.7	6.03e-21	NR	WWU04882.1	1916690	g119193	i0	46.2	2.87096774193548	91	49	97.8	0	5	277	309	399	WWU04882.1 MAG: RNA-dependent RNA polymerase, partial [Iflavirus sp.]	diamond	801	96.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflavirus	Iflavirus sp.
31172929	31172929	PRJNA1074407_P_NODE_40155_length_830_cov_1.589168_g36654_i0	PRJNA1074407	40155	830	1.589168	13.1900944	Picornaviridae sp.	1530251	Viruses	Viruses	483	3.9999999999999986e-154	NR	XDJ26655.1	1530251	g36654	i0	86.1	0.986746987951807	273	36	98	1	828	16	1652	1924	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	819	483	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
31236364	31236364	PRJNA1074407_P_NODE_38075_length_868_cov_1.430189_g34642_i0	PRJNA1074407	38075	868	1.430189	12.41404052	Hepatica betacytorhabdovirus 1	3078343	Viruses	Viruses	98.6	1.76e-19	NR	DBA36665.1	3078343	g34642	i0	33.5	0.597926267281106	173	106	58.8	3	511	2	155	321	DBA36665.1 TPA_asm: P [Hepatica betacytorhabdovirus 1]	diamond	519	98.6	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Betacytorhabdovirus	Betacytorhabdovirus hepaticae
31394799	31394799	PRJNA1074407_P_NODE_90056_length_387_cov_0.952229_g86219_i0	PRJNA1074407	90056	387	0.952229	3.68512623	Phytophthora cinnamomi ormycovirus 7-5	3239326	Viruses	Viruses	69.7	6.94e-11	NR	XDO01625.1	3239326	g86219	i0	33.1	1.0077519379845	130	81	97.7	2	5	382	464	591	XDO01625.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 7-5]	diamond	390	69.7	1	Viruses	Orthornavirae		Orpoviricetes	Bormycovirales	Alphaormycoviridae	Phormycovirus	Phormycovirus phytophthorae
31742458	31742458	PRJNA1074407_P_NODE_95997_length_362_cov_2.276817_g92160_i0	PRJNA1074407	95997	362	2.276817	8.24207754	Macrobrachium rosenbergii hepe-like virus 3	3132532	Viruses	Viruses	234	1.5299999999999999e-68	NR	WWZ85572.1	3132532	g92160	i0	98.3	0.994475138121547	120	2	99.4	0	360	1	1325	1444	WWZ85572.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii hepe-like virus 3]	diamond	360	234	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Hepeviridae		Macrobrachium rosenbergii hepe-like virus 3
32312358	32312358	PRJNA1074407_P_NODE_124259_length_276_cov_1.344828_g120421_i0	PRJNA1074407	124259	276	1.344828	3.71172528	Guangdong ant virus 1	3134398	Viruses	Viruses	81.6	1.18e-15	NR	WXH83726.1	3134398	g120421	i0	41.9	1.01086956521739	93	52	98.9	1	2	274	1949	2041	WXH83726.1 MAG: putative polyprotein [Guangdong ant virus 1]	diamond	279	81.6	1	Viruses							Guangdong ant virus 1
32565494	32565494	PRJNA1074407_P_NODE_82859_length_419_cov_1.537572_g79023_i0	PRJNA1074407	82859	419	1.537572	6.44242668	Picornaviridae sp.	1530251	Viruses	Viruses	290	7.48e-88	NR	XDJ26655.1	1530251	g79023	i0	97.8	0.995226730310263	139	3	99.5	0	1	417	1171	1309	XDJ26655.1 polyprotein [Picornaviridae sp.]	diamond	417	290	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae 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);;