metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB14175" and tax_kingdom = "Bamfordvirae"

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
25911641	25911641	PRJEB14175_P_NODE_15180_length_923_cov_10.520882_g13547_i0	PRJEB14175	15180	923	10.520882	97.10774086	Mimiviridae	549779	Viruses	Viruses	182	4.66e-52	NR	ARF09867.1	1977633	g13547	i0	63.9	1.19284940411701	122	44	39.7	0	409	44	11	132	ARF09867.1 hypothetical protein Indivirus_4_39 [Indivirus ILV1]	diamond	1101	182	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
32908864	32908864	PRJEB14175_P_NODE_179113_length_245_cov_44.239130_g176846_i0	PRJEB14175	179113	245	44.23913	108.3858685	Iridovirus Liz-CrIV	2594309	Viruses	Viruses	68.2	4.03e-11	NR	QEA08244.1	2594309	g176846	i0	77.5	0.489795918367347	40	9	49	0	23	142	401	440	QEA08244.1 putative helicase [Iridovirus Liz-CrIV]	diamond	120	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Iridovirus Liz-CrIV
32908943	32908943	PRJEB14175_P_NODE_188969_length_237_cov_1.931818_g186702_i0	PRJEB14175	188969	237	1.931818	4.57840866	Barrevirus sp.	2487763	Viruses	Viruses	53.9	3.84e-6	NR	AYV76846.1	2487763	g186702	i0	43.4	0.670886075949367	53	28	67.1	1	215	57	183	233	AYV76846.1 MAG: HNH endonuclease [Barrevirus sp.]	diamond	159	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
32909284	32909284	PRJEB14175_P_NODE_226985_length_209_cov_1.432432_g224717_i0	PRJEB14175	226985	209	1.432432	2.99378288	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	42.4	0.0336	NR	DBA47698.1	2609857	g224717	i0	85	0.287081339712919	20	3	28.7	0	3	62	1199	1218	DBA47698.1 MAG TPA_asm: PolBb [Adintovirus homo13306]	diamond	60	42.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Larimichthys croaker adintovirus
32991156	32991156	PRJEB14175_P_NODE_241147_length_205_cov_14.791667_g238879_i0	PRJEB14175	241147	205	14.791667	30.32291735	Tupanvirus	2094720	Viruses	Viruses	96.3	3.14e-21	NR	YP_010780259.1	2126984	g238879	i0	71	1.81463414634146	62	18	90.7	0	187	2	147	208	YP_010780259.1 glycosyl hydrolase family 18 [Tupanvirus deep ocean]	diamond	372	96.7	0.995863495346432	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
33010898	33010898	PRJEB14175_P_NODE_120300_length_319_cov_3.089147_g118034_i0	PRJEB14175	120300	319	3.089147	9.85437893	European chub iridovirus	2578140	Viruses	Viruses	99	1.05e-24	NR	QCQ67839.1	2578140	g118034	i0	53.9	10.1755485893417	76	35	71.5	0	23	250	2	77	QCQ67839.1 ubiquitin family protein [European chub iridovirus]	diamond	3246	99	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		European chub iridovirus
33029691	33029691	PRJEB14175_P_NODE_62396_length_469_cov_4.276961_g60140_i0	PRJEB14175	62396	469	4.276961	20.05894709	Thermus phage phiKo	2301535	Viruses	Viruses	111	2.85e-27	NR	AYJ74689.1	2301535	g60140	i0	62.8	0.550106609808102	86	29	55	2	88	345	19	101	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	258	111	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
33029862	33029862	PRJEB14175_P_NODE_81788_length_403_cov_3.801170_g79526_i0	PRJEB14175	81788	403	3.80117	15.3187151	Thermus phage phiKo	2301535	Viruses	Viruses	85.9	9.18e-18	NR	AYJ74689.1	2301535	g79526	i0	56.6	0.56575682382134	76	28	52.9	2	335	123	127	202	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	228	85.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
33130545	33130545	PRJEB14175_P_NODE_14183_length_952_cov_4.991021_g12589_i0	PRJEB14175	14183	952	4.991021	47.51451992	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	132	1.1499999999999999e-32	NR	DBA47688.1	2609857	g12589	i0	50.4	0.406512605042017	129	64	40.7	0	394	780	152	280	DBA47688.1 MAG TPA_asm: Adintoc5 [Adintovirus homo13306]	diamond	387	132	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Larimichthys croaker adintovirus
33164441	33164441	PRJEB14175_P_NODE_131928_length_301_cov_2.312500_g129661_i0	PRJEB14175	131928	301	2.3125	6.960625	Thermus phage phiKo	2301535	Viruses	Viruses	74.7	2.4e-13	NR	AYJ74696.1	2301535	g129661	i0	50.6	0.767441860465116	77	37	76.7	1	231	1	156	231	AYJ74696.1 hypothetical protein phiKo_21 [Thermus phage phiKo]	diamond	231	74.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
33165336	33165336	PRJEB14175_P_NODE_225528_length_210_cov_1.288591_g223260_i0	PRJEB14175	225528	210	1.288591	2.7060411	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	101	1.9099999999999994e-24	NR	DBA47691.1	2609857	g223260	i0	75	0.914285714285714	64	16	91.4	0	17	208	53	116	DBA47691.1 MAG TPA_asm: Penton [Adintovirus homo13306]	diamond	192	101	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Larimichthys croaker adintovirus

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