metadata: contig_metadata: 10 rows where bioproject = "PRJNA770826" and tax

10 rows where bioproject = "PRJNA770826" 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
27116280	27116280	PRJNA770826_P_NODE_41802_length_162_cov_0.920354_g41631_i0	PRJNA770826	41802	162	0.920354	1.49097348	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	67	2e-11	NR	VBB17800.1	2420051	g41631	i0	58.5	0.981481481481482	53	22	98.1	0	3	161	138	190	VBB17800.1 RING zinc finger-containing protein [Yasminevirus sp. GU-2018]	diamond	159	67	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
28663971	28663971	PRJNA770826_P_NODE_17967_length_191_cov_1.154930_g17796_i0	PRJNA770826	17967	191	1.15493	2.2059163	Terrestrivirus sp.	2487775	Viruses	Viruses	60.1	1.42e-8	NR	AYV76622.1	2487775	g17796	i0	44.4	0.989528795811518	63	33	99	1	2	190	642	702	AYV76622.1 MAG: putative von willebrand factor type A domain protein [Terrestrivirus sp.]	diamond	189	60.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
29074560	29074560	PRJNA770826_P_NODE_43028_length_162_cov_0.920354_g42857_i0	PRJNA770826	43028	162	0.920354	1.49097348	Megaviridae environmental sample	1737588	Viruses	Viruses	46.6	5.29e-4	NR	QFG74153.1	1737588	g42857	i0	51	0.944444444444444	51	22	90.7	2	149	3	7	56	QFG74153.1 MAG: aminotransferase class I and II [Megaviridae environmental sample]	diamond	153	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
29673926	29673926	PRJNA770826_P_NODE_10690_length_247_cov_0.939394_g10519_i0	PRJNA770826	10690	247	0.939394	2.32030318	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	52.4	1.55e-5	NR	YP_009448666.1	2023057	g10519	i0	37.7	0.935222672064777	77	37	93.5	1	232	2	352	417	YP_009448666.1 Flotillin domain-containing protein [Orpheovirus IHUMI-LCC2]	diamond	231	52.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
30021856	30021856	PRJNA770826_P_NODE_41851_length_162_cov_0.920354_g41680_i0	PRJNA770826	41851	162	0.920354	1.49097348	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	69.7	3.71e-12	NR	YP_010803071.1	3060017	g41680	i0	62.2	0.833333333333333	45	17	83.3	0	137	3	241	285	YP_010803071.1 DHH phosphoesterase [Fadolivirus algeromassiliense]	diamond	135	69.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
30621856	30621856	PRJNA770826_P_NODE_16913_length_197_cov_1.054054_g16742_i0	PRJNA770826	16913	197	1.054054	2.07648638	Indivirus ILV1	1977633	Viruses	Viruses	53.9	2.31e-6	NR	ARF09660.1	1977633	g16742	i0	46.4	0.852791878172589	56	30	85.3	0	194	27	686	741	ARF09660.1 glycosyltransferase [Indivirus ILV1]	diamond	168	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
31696748	31696748	PRJNA770826_P_NODE_14817_length_210_cov_0.962733_g14646_i0	PRJNA770826	14817	210	0.962733	2.0217393	Chlorovirus sp.	2809302	Viruses	Viruses	70.5	3.95e-12	NR	XOK35624.1	2809302	g14646	i0	63.8	0.671428571428571	47	17	67.1	0	3	143	287	333	XOK35624.1 Oxidoreductase [Chlorovirus sp.]	diamond	141	70.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
31981338	31981338	PRJNA770826_P_NODE_22038_length_172_cov_1.268293_g21867_i0	PRJNA770826	22038	172	1.268293	2.18146396	Marseillevirus LCMAC2	2506606	Viruses	Viruses	90.1	2.82e-19	NR	QBK87824.1	2506606	g21867	i0	71.4	0.976744186046512	56	16	97.7	0	3	170	280	335	QBK87824.1 MAG: peptidase family M49 [Marseillevirus LCMAC202]	diamond	168	90.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC202
32139742	32139742	PRJNA770826_P_NODE_10198_length_253_cov_0.833333_g10027_i0	PRJNA770826	10198	253	0.833333	2.10833249	Terrestrivirus sp.	2487775	Viruses	Viruses	158	9.85e-45	NR	AYV76711.1	2487775	g10027	i0	89.3	0.99604743083004	84	9	99.6	0	252	1	144	227	AYV76711.1 MAG: hypothetical protein Terrestrivirus12_14 [Terrestrivirus sp.]	diamond	252	158	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
32645245	32645245	PRJNA770826_P_NODE_6300_length_332_cov_7.349823_g6129_i0	PRJNA770826	6300	332	7.349823	24.40141236	Terrestrivirus sp.	2487775	Viruses	Viruses	46.6	9.46e-4	NR	AYV76392.1	2487775	g6129	i0	52	0.451807228915663	50	22	43.4	1	238	95	1	50	AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.]	diamond	150	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus 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);;