metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA533623" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA533623" 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
26951023	26951023	PRJNA533623_P_NODE_19322_length_532_cov_47.133758_g17581_i0	PRJNA533623	19322	532	47.133758	250.75159256	Totiviridae sp.	1955172	Viruses	Viruses	264	1.31e-82	NR	WAK77570.1	1955172	g17581	i0	75.3	1.86654135338346	162	40	91.4	0	25	510	347	508	WAK77570.1 MAG: polyprotein, partial [Totiviridae sp.]	diamond	993	264	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
31500064	31500064	PRJNA533623_P_NODE_76496_length_204_cov_0.713287_g74715_i0	PRJNA533623	76496	204	0.713287	1.45510548	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	50.1	5.85e-5	NR	WLN26256.1	2951531	g74715	i0	40.6	1.01470588235294	69	38	97.1	2	200	3	45	113	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	207	50.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
31594987	31594987	PRJNA533623_P_NODE_20756_length_511_cov_50.020000_g19009_i0	PRJNA533623	20756	511	50.02	255.6022	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	129	3.1999999999999993e-31	NR	QJI53565.1	3003959	g19009	i0	75.7	0.434442270058708	74	18	43.4	0	105	326	2119	2192	QJI53565.1 MAG: hypothetical protein 1, partial [Picornavirales sp.]	diamond	222	129	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31847737	31847737	PRJNA533623_P_NODE_79817_length_187_cov_15.420635_g78036_i0	PRJNA533623	79817	187	15.420635	28.83658745	Psammomys obesus associated mitovirus 1	2993411	Viruses	Viruses	77.8	7.84e-15	NR	DBA06310.1	2993411	g78036	i0	75	0.834224598930481	52	13	83.4	0	162	7	400	451	DBA06310.1 TPA_asm: RdRp, partial [Psammomys obesus associated mitovirus 1]	diamond	156	77.8	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Psammomys obesus associated mitovirus 1
32606955	32606955	PRJNA533623_P_NODE_35500_length_372_cov_11.389068_g33728_i0	PRJNA533623	35500	372	11.389068	42.36733296	Malassezia restricta associated totivirus 1	3048757	Viruses	Viruses	224	7.15e-67	NR	CAI9858976.1	3048757	g33728	i0	90.5	0.935483870967742	116	11	93.5	0	350	3	354	469	CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1]	diamond	348	224	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 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);;