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

5 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_phylum = "Duplornaviricota"

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
28103076	28103076	PRJNA498309_S_NODE_18125_length_500_cov_51.705376_g16062_i0	PRJNA498309	18125	500	51.705376	258.52688	Ghabrivirales	2732540	Viruses	Viruses	121	1.59e-28	NR	WAK77569.1	1955172	g16062	i0	44.4	1.584	135	75	81	0	56	460	54	188	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	792	121	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
28877036	28877036	PRJNA498309_P_NODE_6548_length_1243_cov_12.398839_g5346_i0	PRJNA498309	6548	1243	12.398839	154.11756877	Nanning Totiv tick virus 3	2972354	Viruses	Viruses	186	1.3099999999999998e-47	NR	UYL95666.1	2972354	g5346	i0	35.1	0.818181818181818	339	214	81.1	5	1009	2	65	400	UYL95666.1 MAG: RNA-dependent RNA polymerase [Nanning Totiv tick virus 3]	diamond	1017	186	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Nanning Totiv tick virus 3
30898685	30898685	PRJNA498309_S_NODE_5474_length_1238_cov_23.297589_g4077_i0	PRJNA498309	5474	1238	23.297589	288.42415182	Nanning Totiv tick virus 3	2972354	Viruses	Viruses	184	3.1399999999999997e-47	NR	UYL95666.1	2972354	g4077	i0	35.1	0.81421647819063	336	212	80.7	5	236	1234	65	397	UYL95666.1 MAG: RNA-dependent RNA polymerase [Nanning Totiv tick virus 3]	diamond	1008	184	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Nanning Totiv tick virus 3
31293179	31293179	PRJNA498309_P_NODE_56675_length_343_cov_1.885621_g54527_i0	PRJNA498309	56675	343	1.885621	6.46768003	Ghabrivirales	2732540	Viruses	Viruses	112	6.210000000000001e-26	NR	QJA42332.1	2727863	g54527	i0	56.7	2.78134110787172	104	45	91	0	319	8	879	982	QJA42332.1 polyprotein [Malassezia restricta virus MrV40L]	diamond	954	112	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
32826708	32826708	PRJNA498309_P_NODE_56820_length_342_cov_2.918033_g54672_i0	PRJNA498309	56820	342	2.918033	9.97967286	Erysiphe necator associated totivirus 7	2737097	Viruses	Viruses	68.9	7.54e-11	NR	QJW70337.1	2737097	g54672	i0	41.4	0.868421052631579	99	56	85.1	1	293	3	2	100	QJW70337.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 7]	diamond	297	68.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Erysiphe necator associated totivirus 7

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