metadata: contig_metadata: 14 rows where bioproject = "PRJNA1000943" and tax

14 rows where bioproject = "PRJNA1000943" 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
10348184	10348184	PRJNA1000943_P_NODE_10449_length_259_cov_1.677419_g10311_i0	PRJNA1000943	10449	259	1.677419	4.34451521	Tupanvirus soda lake	2126985	Viruses	Viruses	139	3.219999999999999e-38	NR	YP_010782084.1	2126985	g10311	i0	75.3	0.984555984555985	85	21	98.5	0	257	3	124	208	YP_010782084.1 thioredoxin-disulfide reductase [Tupanvirus soda lake]	diamond	255	139	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
21822050	21822050	PRJNA1000943_P_NODE_958_length_759_cov_2.217201_g832_i0	PRJNA1000943	958	759	2.217201	16.82855559	Harvfovirus sp.	2487768	Viruses	Viruses	128	3.12e-33	NR	AYV81692.1	2487768	g832	i0	43	0.561264822134387	142	79	56.1	1	83	508	13	152	AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.]	diamond	426	128	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
27128741	27128741	PRJNA1000943_P_NODE_15782_length_235_cov_3.827160_g15644_i0	PRJNA1000943	15782	235	3.82716	8.993826	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	124	1.47e-32	NR	YP_010803631.1	3060017	g15644	i0	75.3	0.982978723404255	77	18	97	1	235	8	251	327	YP_010803631.1 thioredoxin-disulfide reductase [Fadolivirus algeromassiliense]	diamond	231	124	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27128742	27128742	PRJNA1000943_P_NODE_3562_length_413_cov_0.761765_g3425_i0	PRJNA1000943	3562	413	0.761765	3.14608945	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	167	1.16e-46	NR	YP_009448979.1	2023057	g3425	i0	61.5	0.886198547215496	122	47	88.6	0	411	46	379	500	YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2]	diamond	366	167	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
28108093	28108093	PRJNA1000943_P_NODE_12565_length_249_cov_0.886364_g12427_i0	PRJNA1000943	12565	249	0.886364	2.20704636	Faunusvirus sp.	2487766	Viruses	Viruses	62.4	4.75e-9	NR	AYV79487.1	2487766	g12427	i0	43.6	0.939759036144578	78	44	94	0	248	15	446	523	AYV79487.1 MAG: phosphatidylinositol kinase [Faunusvirus sp.]	diamond	234	62.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Faunusvirus sp.
28329196	28329196	PRJNA1000943_P_NODE_13726_length_246_cov_0.901734_g13588_i0	PRJNA1000943	13726	246	0.901734	2.21826564	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	78.6	1.96e-15	NR	YP_009449316.1	2023057	g13588	i0	67.3	0.597560975609756	49	16	59.8	0	2	148	199	247	YP_009449316.1 Fatty acid hydroxylase (C-5 sterol desaturase putative) [Orpheovirus IHUMI-LCC2]	diamond	147	78.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
28708304	28708304	PRJNA1000943_P_NODE_11887_length_251_cov_0.876404_g11749_i0	PRJNA1000943	11887	251	0.876404	2.19977404	Moumouvirus maliensis	2682469	Viruses	Viruses	56.2	7.09e-7	NR	QGR54231.1	2682469	g11749	i0	40.8	0.848605577689243	71	42	84.9	0	2	214	311	381	QGR54231.1 NAD(P)-binding domain-containing protein [Moumouvirus maliensis]	diamond	213	56.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'maliensis'
29276349	29276349	PRJNA1000943_P_NODE_5249_length_349_cov_1.068841_g5111_i0	PRJNA1000943	5249	349	1.068841	3.73025509	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	65.5	1.94e-10	NR	YP_010804235.1	3060017	g5111	i0	39.1	0.945558739255014	110	42	90.3	5	3	317	73	162	YP_010804235.1 hypothetical protein QKU48_gp1352 [Fadolivirus algeromassiliense]	diamond	330	65.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29307990	29307990	PRJNA1000943_P_NODE_12649_length_249_cov_0.886364_g12511_i0	PRJNA1000943	12649	249	0.886364	2.20704636	Terrestrivirus sp.	2487775	Viruses	Viruses	65.5	3.26e-10	NR	AYV76418.1	2487775	g12511	i0	39.2	1.85542168674699	79	47	94	1	239	6	90	168	AYV76418.1 MAG: chitinase-like protein cluster D [Terrestrivirus sp.]	diamond	462	65.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
30476865	30476865	PRJNA1000943_P_NODE_9193_length_274_cov_3.099502_g9055_i0	PRJNA1000943	9193	274	3.099502	8.49263548	Barrevirus sp.	2487763	Viruses	Viruses	56.6	3.86e-7	NR	AYV77273.1	2487763	g9055	i0	33.3	2.1021897810219	93	60	99.6	2	1	273	110	202	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	576	56.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
31329877	31329877	PRJNA1000943_P_NODE_9476_length_271_cov_0.949495_g9338_i0	PRJNA1000943	9476	271	0.949495	2.57313145	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	54.7	3.3e-6	NR	YP_009448336.1	2023057	g9338	i0	34.9	1.91512915129151	86	54	94.1	2	1	255	653	737	YP_009448336.1 Immunoglobulin-like fold protein [Orpheovirus IHUMI-LCC2]	diamond	519	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
31393337	31393337	PRJNA1000943_P_NODE_11816_length_251_cov_0.876404_g11678_i0	PRJNA1000943	11816	251	0.876404	2.19977404	Klosneuvirus KNV1	1977640	Viruses	Viruses	51.6	2.99e-5	NR	ARF12131.1	1977640	g11678	i0	36.8	0.812749003984064	68	43	81.3	0	236	33	317	384	ARF12131.1 hypothetical protein Klosneuvirus_3_266 [Klosneuvirus KNV1]	diamond	204	51.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32247660	32247660	PRJNA1000943_P_NODE_15238_length_242_cov_1.840237_g15100_i0	PRJNA1000943	15238	242	1.840237	4.45337354	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	133	4.75e-36	NR	YP_009449055.1	2023057	g15100	i0	76.3	0.991735537190083	80	19	99.2	0	2	241	130	209	YP_009449055.1 ribonucleotide reductase large subunit [Orpheovirus IHUMI-LCC2]	diamond	240	133	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
32469036	32469036	PRJNA1000943_P_NODE_4399_length_376_cov_1.917492_g4262_i0	PRJNA1000943	4399	376	1.917492	7.20976992	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	64.3	4.88e-9	NR	YP_009449258.1	2023057	g4262	i0	36.3	0.901595744680851	113	68	88.6	2	334	2	1077	1187	YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2]	diamond	339	64.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense

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