metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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_family	tax_genus	tax_species
26850607	26850607	PRJNA1151638_P_NODE_1361_length_392_cov_1.467085_g1294_i0	PRJNA1151638	1361	392	1.467085	5.7509732	Geobacillus phage vB_GthS_PK3.6	2985565	Viruses	Viruses	172	4.95e-51	NR	UYL94016.1	2985565	g1294	i0	67.2	3.65051020408163	119	39	91.1	0	374	18	84	202	UYL94016.1 hypothetical protein PK36_gp44 [Geobacillus phage vB_GthS_PK3.6]	diamond	1431	172	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Geobacillus phage vB_GthS_PK3.6
27640735	27640735	PRJNA1151638_P_NODE_444_length_650_cov_2.006932_g378_i0	PRJNA1151638	444	650	2.006932	13.045058	Caudoviricetes sp.	2832643	Viruses	Viruses	61.6	8.21e-9	NR	DAN20154.1	2832643	g378	i0	61.9	0.387692307692308	42	16	19.4	0	525	650	1	42	DAN20154.1 MAG TPA: glutaredoxin-like protein [Caudoviricetes sp.]	diamond	252	61.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28430037	28430037	PRJNA1151638_P_NODE_4106_length_265_cov_2.390625_g4039_i0	PRJNA1151638	4106	265	2.390625	6.33515625	Rhodococcus phage NiceHouse	2743998	Viruses	Viruses	102	5.6999999999999995e-25	NR	QLF83277.1	2743998	g4039	i0	51.7	0.984905660377358	87	40	96.2	1	262	8	12	98	QLF83277.1 tRNA-methyltransferase [Rhodococcus phage NiceHouse]	diamond	261	102	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Trinavirus	Rhodococcus phage NiceHouse
28871869	28871869	PRJNA1151638_P_NODE_3428_length_281_cov_2.802885_g3361_i0	PRJNA1151638	3428	281	2.802885	7.87610685	Staphylococcus phage PMBT8	2590894	Viruses	Viruses	43.9	0.0213	NR	QDF14352.1	2590894	g3361	i0	36.4	0.822064056939502	77	44	82.2	2	6	236	191	262	QDF14352.1 hypothetical protein [Staphylococcus phage PMBT8]	diamond	231	43.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Sextaecvirus	Staphylococcus phage PMBT8
29250659	29250659	PRJNA1151638_P_NODE_3969_length_268_cov_2.246154_g3902_i0	PRJNA1151638	3969	268	2.246154	6.01969272	Pseudomonas phage RVTF4	3236931	Viruses	Viruses	111	2.33e-26	NR	XDJ14705.1	3236931	g3902	i0	60	2.02611940298507	90	35	99.6	1	1	267	74	163	XDJ14705.1 hypothetical protein [Pseudomonas phage RVTF4]	diamond	543	111	1	Viruses						Pseudomonas phage RVTF4
29345613	29345613	PRJNA1151638_P_NODE_4849_length_252_cov_2.508380_g4782_i0	PRJNA1151638	4849	252	2.50838	6.3211176	Acinetobacter phage AB1I1M-1	3035939	Viruses	Viruses	71.6	1.65e-12	NR	WJJ54857.1	3035939	g4782	i0	52.8	1.72619047619048	72	27	85.7	2	14	229	245	309	WJJ54857.1 hypothetical protein [Acinetobacter phage AB1I1M-1]	diamond	435	71.6	1	Viruses						Acinetobacter phage AB1I1M-1
29629351	29629351	PRJNA1151638_P_NODE_2910_length_296_cov_2.358744_g2843_i0	PRJNA1151638	2910	296	2.358744	6.98188224	Caudoviricetes sp.	2832643	Viruses	Viruses	56.6	8.43e-7	NR	DAG71531.1	2832643	g2843	i0	42.4	0.597972972972973	59	31	59.8	1	220	44	4	59	DAG71531.1 MAG TPA: type-1 restriction enzyme [Caudoviricetes sp.]	diamond	177	56.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30261709	30261709	PRJNA1151638_P_NODE_4372_length_260_cov_1.251337_g4305_i0	PRJNA1151638	4372	260	1.251337	3.2534762	Burkholderia phage BCSR5	2805747	Viruses	Viruses	66.6	1.73e-10	NR	QRE00205.1	2805747	g4305	i0	41.7	0.830769230769231	72	42	83.1	0	31	246	4	75	QRE00205.1 hypothetical protein [Burkholderia phage BCSR5]	diamond	216	66.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Burkholderia phage BCSR5
30482687	30482687	PRJNA1151638_P_NODE_2153_length_330_cov_2.112840_g2086_i0	PRJNA1151638	2153	330	2.11284	6.972372	Herelleviridae sp.	2831613	Viruses	Viruses	79.7	8.73e-16	NR	DAN11154.1	2831613	g2086	i0	43.3	1.62727272727273	90	45	80	2	48	311	1	86	DAN11154.1 MAG TPA: hypothetical protein [Herelleviridae sp.]	diamond	537	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Herelleviridae		Herelleviridae sp.
31841745	31841745	PRJNA1151638_P_NODE_6037_length_245_cov_1.767442_g5970_i0	PRJNA1151638	6037	245	1.767442	4.3302329	Rhodococcus phage Grayson	2182359	Viruses	Viruses	49.7	1.07e-4	NR	AWN04495.1	2182359	g5970	i0	33.9	0.759183673469388	62	38	75.9	1	207	22	180	238	AWN04495.1 hypothetical protein PBI_GRAYSON_166 [Rhodococcus phage Grayson]	diamond	186	49.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Weaselvirus	Rhodococcus phage Grayson
32474925	32474925	PRJNA1151638_P_NODE_1519_length_375_cov_2.923841_g1452_i0	PRJNA1151638	1519	375	2.923841	10.96440375	Rhodococcus phage NiceHouse	2743998	Viruses	Viruses	98.6	7.31e-23	NR	QLF83277.1	2743998	g1452	i0	52.2	0.736	92	42	72	2	13	282	106	197	QLF83277.1 tRNA-methyltransferase [Rhodococcus phage NiceHouse]	diamond	276	98.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Trinavirus	Rhodococcus phage NiceHouse
32695477	32695477	PRJNA1151638_P_NODE_5320_length_249_cov_1.795455_g5253_i0	PRJNA1151638	5320	249	1.795455	4.47068295	Caudoviricetes sp.	2832643	Viruses	Viruses	43.1	0.00619	NR	DAV51079.1	2832643	g5253	i0	60	0.36144578313253	30	12	36.1	0	122	33	23	52	DAV51079.1 MAG TPA: AcrIIC3 protein [Caudoviricetes sp.]	diamond	90	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes 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);;