metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_kingdom = "Loebvirae"

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_species
27608734	27608734	PRJNA1148190_P_NODE_630924_length_249_cov_0.875000_g619751_i0	PRJNA1148190	630924	249	0.875	2.17875	Limnohabitans phage DC33	3390365	Viruses	Viruses	55.5	8.61e-8	NR	XLZ15508.1	3390365	g619751	i0	65.7	0.819277108433735	35	12	42.2	0	242	138	56	90	XLZ15508.1 hypothetical protein LBILNBIM_00030 [Limnohabitans phage DC33]	diamond	204	55.5	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Limnohabitans phage DC33
27671189	27671189	PRJNA1148190_P_NODE_187504_length_387_cov_1.366242_g176335_i0	PRJNA1148190	187504	387	1.366242	5.28735654	Limnohabitans phage DC33	3390365	Viruses	Viruses	47	6.83e-4	NR	XLZ15508.1	3390365	g176335	i0	52.5	0.589147286821705	40	19	31	0	344	225	1	40	XLZ15508.1 hypothetical protein LBILNBIM_00030 [Limnohabitans phage DC33]	diamond	228	47	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Limnohabitans phage DC33
28302741	28302741	PRJNA1148190_P_NODE_328366_length_308_cov_2.297872_g317193_i0	PRJNA1148190	328366	308	2.297872	7.07744576	Inoviridae sp.	2219103	Viruses	Viruses	78.6	2.17e-16	NR	XOF04273.1	2219103	g317193	i0	56.7	0.652597402597403	67	29	65.3	0	3	203	40	106	XOF04273.1 MAG: hypothetical protein [Inoviridae sp.]	diamond	201	78.6	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Inoviridae sp.
30039277	30039277	PRJNA1148190_P_NODE_259871_length_338_cov_1.649057_g248701_i0	PRJNA1148190	259871	338	1.649057	5.57381266	Inoviridae sp.	2219103	Viruses	Viruses	63.9	4.04e-9	NR	XOF02218.1	2219103	g248701	i0	30.6	1.07396449704142	121	57	96.7	2	334	8	481	586	XOF02218.1 MAG: hypothetical protein [Inoviridae sp.]	diamond	363	63.9	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Inoviridae sp.
30861322	30861322	PRJNA1148190_P_NODE_563094_length_254_cov_1.917127_g551921_i0	PRJNA1148190	563094	254	1.917127	4.86950258	Tubulavirales sp.	2833306	Viruses	Viruses	57.8	1.51e-7	NR	XOE93753.1	2833306	g551921	i0	84.8	0.779527559055118	33	5	39	0	100	2	1	33	XOE93753.1 MAG: morphogenesis I-M13, partial [Tubulavirales sp.]	diamond	198	57.8	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales		Tubulavirales sp.
30892279	30892279	PRJNA1148190_P_NODE_118934_length_484_cov_2.248175_g107772_i0	PRJNA1148190	118934	484	2.248175	10.881167	Limnohabitans phage DC33	3390365	Viruses	Viruses	93.2	1.42e-18	NR	XLZ15523.1	3390365	g107772	i0	41.7	0.861570247933884	139	81	86.2	0	480	64	2188	2326	XLZ15523.1 hypothetical protein LBILNBIM_00045 [Limnohabitans phage DC33]	diamond	417	93.2	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Limnohabitans phage DC33
30955813	30955813	PRJNA1148190_P_NODE_281554_length_328_cov_1.207843_g270383_i0	PRJNA1148190	281554	328	1.207843	3.96172504	Limnohabitans phage DC33	3390365	Viruses	Viruses	132	5.34e-37	NR	XLZ15485.1	3390365	g270383	i0	60.4	0.969512195121951	106	42	97	0	9	326	10	115	XLZ15485.1 hypothetical protein LBILNBIM_00007 [Limnohabitans phage DC33]	diamond	318	132	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Limnohabitans phage DC33
31145296	31145296	PRJNA1148190_P_NODE_623235_length_249_cov_0.875000_g612062_i0	PRJNA1148190	623235	249	0.875	2.17875	Inoviridae sp.	2219103	Viruses	Viruses	155	1.0600000000000001e-44	NR	XOF04062.1	2219103	g612062	i0	79.3	0.987951807228916	82	17	98.8	0	2	247	167	248	XOF04062.1 MAG: morphogenesis I-M13 [Inoviridae sp.]	diamond	246	155	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Inoviridae 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);;