metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
26727458	26727458	PRJNA450343_P_NODE_1661_length_428_cov_2.482850_g1593_i0	PRJNA450343	1661	428	2.48285	10.626598	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	133	2.24e-33	NR	YP_009361865.1	RQ15	g1593	i0	49.3	1.02336448598131	146	68	99.5	3	2	427	288	431	YP_009361865.1 protease [Salmovirus WFRC1]	diamond	438	133	1	Viruses							Zebrafish rhabdo-like virus
27265822	27265822	PRJNA450343_P_NODE_9943_length_172_cov_2.073171_g9875_i0	PRJNA450343	9943	172	2.073171	3.56585412	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	79.7	1.33e-15	NR	YP_009361866.1	RQ15	g9875	i0	57.9	0.994186046511628	57	24	99.4	0	172	2	144	200	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	171	79.7	1	Viruses							Zebrafish rhabdo-like virus
28434160	28434160	PRJNA450343_P_NODE_2346_length_355_cov_2.660131_g2278_i0	PRJNA450343	2346	355	2.660131	9.44346505	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	118	4.86e-28	NR	YP_009361866.1	RQ15	g2278	i0	50	0.997183098591549	118	59	99.7	0	354	1	288	405	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	354	118	1	Viruses							Zebrafish rhabdo-like virus
29128944	29128944	PRJNA450343_P_NODE_529_length_787_cov_1.876694_g482_i0	PRJNA450343	529	787	1.876694	14.76958178	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	234	1.12e-67	NR	YP_009361866.1	RQ15	g482	i0	50.6	0.972045743329098	255	117	94.2	3	15	755	432	685	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	765	234	1	Viruses							Zebrafish rhabdo-like virus
29665097	29665097	PRJNA450343_P_NODE_12970_length_163_cov_0.894737_g12902_i0	PRJNA450343	12970	163	0.894737	1.45842131	Caudoviricetes sp.	2832643	Viruses	Viruses	39.3	0.0294	NR	DAX83020.1	2832643	g12902	i0	40	0.736196319018405	40	24	73.6	0	135	16	5	44	DAX83020.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	120	39.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29855021	29855021	PRJNA450343_P_NODE_9151_length_180_cov_1.938931_g9083_i0	PRJNA450343	9151	180	1.938931	3.4900758	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	46.6	6.88e-4	NR	YP_009361865.1	RQ15	g9083	i0	50	0.733333333333333	44	22	73.3	0	39	170	13	56	YP_009361865.1 protease [Salmovirus WFRC1]	diamond	132	46.6	1	Viruses							Zebrafish rhabdo-like virus
30234053	30234053	PRJNA450343_P_NODE_6412_length_211_cov_1.432099_g6344_i0	PRJNA450343	6412	211	1.432099	3.02172889	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	49.3	1.22e-4	NR	YP_009361866.1	RQ15	g6344	i0	40.6	0.981042654028436	69	39	98.1	1	210	4	7	73	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	207	49.3	1	Viruses							Zebrafish rhabdo-like virus
32415777	32415777	PRJNA450343_P_NODE_9019_length_182_cov_0.954887_g8951_i0	PRJNA450343	9019	182	0.954887	1.73789434	Tupanvirus deep ocean	2126984	Viruses	Viruses	59.7	1.71e-8	NR	YP_010781167.1	2126984	g8951	i0	62.2	1.18681318681319	37	14	61	0	69	179	55	91	YP_010781167.1 threonyl-tRNA synthetase [Tupanvirus deep ocean]	diamond	216	59.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
32888505	32888505	PRJNA450343_P_NODE_3220_length_298_cov_3.421687_g3152_i0	PRJNA450343	3220	298	3.421687	10.19662726	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	58.9	1.45e-7	NR	YP_009361865.1	RQ15	g3152	i0	39.5	0.76510067114094	76	46	76.5	0	2	229	53	128	YP_009361865.1 protease [Salmovirus WFRC1]	diamond	228	58.9	1	Viruses							Zebrafish rhabdo-like virus

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