metadata: contig_metadata: 9 rows where bioproject = "PRJEB76780" and tax

9 rows where bioproject = "PRJEB76780" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1413455	1413455	PRJEB76780_P_NODE_8942_length_271_cov_6.459596_g8842_i0	PRJEB76780	8942	271	6.459596	17.50550516	Mitovirus sp.	2587224	Viruses	Viruses	124	5.1899999999999996e-24	NTclustered	gi\|1698234317\|gb\|MN033515.1\|	2587224	g8842	i0	92.045	0.324723247232472	88	7	32	0	19	106	24	111	MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence	blastn	88	124	1	Viruses		Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
7790997	7790997	PRJEB76780_P_NODE_11687_length_248_cov_0.891429_g11587_i0	PRJEB76780	11687	248	0.891429	2.21074392	Raphidovirus japonicum	3432138	Viruses	Viruses	73.1	1.72e-8	NTclustered	gi\|1464309061\|ref\|NC_038553.1\|	97195	g11587	i0	97.619	6.83467741935484	42	1	19	0	1	42	94818	94777	Heterosigma akashiwo virus 01 isolate HaV53, complete genome	blastn	1695	73.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Raphidovirus	Raphidovirus japonicum
9066009	9066009	PRJEB76780_P_NODE_12288_length_246_cov_0.901734_g12188_i0	PRJEB76780	12288	246	0.901734	2.21826564	Caudoviricetes sp.	2832643	Viruses	Viruses	313	9.23e-81	NTclustered	gi\|2914781736\|gb\|OR222343.1\|	2832643	g12188	i0	90.948	5.78048780487805	232	21	94	0	3	234	6860	7091	MAG: Caudoviricetes sp. isolate MSP1055 genomic sequence	blastn	1422	313	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19264295	19264295	PRJEB76780_P_NODE_2956_length_477_cov_3.242574_g2856_i0	PRJEB76780	2956	477	3.242574	15.46707798	Harvfovirus sp.	2487768	Viruses	Viruses	120	2.2799999999999997e-31	NR	AYV81692.1	2487768	g2856	i0	42.6	1.67295597484277	141	80	88.7	1	36	458	13	152	AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.]	diamond	798	120	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
26590751	26590751	PRJEB76780_P_NODE_10161_length_254_cov_1.386740_g10061_i0	PRJEB76780	10161	254	1.38674	3.5223196	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	84.3	1.67e-18	NR	QDP66566.1	2591644	g10061	i0	51.2	0.992125984251969	84	38	95.7	1	245	3	16	99	QDP66566.1 MAG: hypothetical protein Tp1111DCM1126091_72 [Prokaryotic dsDNA virus sp.]	diamond	252	84.3	1	Viruses								Prokaryotic dsDNA virus sp.
26685923	26685923	PRJEB76780_P_NODE_12301_length_246_cov_0.901734_g12201_i0	PRJEB76780	12301	246	0.901734	2.21826564	uncultured Caudovirales phage	2100421	Viruses	Viruses	91.3	9e-20	NR	CAB4159274.1	2100421	g12201	i0	56.1	1	82	35	100	1	1	246	202	282	CAB4159274.1 LGT_TIGR03299, phage/plasmid-like protein TIGR03299 [uncultured Caudovirales phage]	diamond	246	91.3	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
27918600	27918600	PRJEB76780_P_NODE_8365_length_280_cov_1.468599_g8265_i0	PRJEB76780	8365	280	1.468599	4.1120772	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	164	5.21e-47	NR	QDP66582.1	2591644	g8265	i0	77.4	0.996428571428571	93	21	99.6	0	280	2	97	189	QDP66582.1 MAG: putative terminase large subunit [Prokaryotic dsDNA virus sp.]	diamond	279	164	1	Viruses								Prokaryotic dsDNA virus sp.
28676584	28676584	PRJEB76780_P_NODE_1327_length_718_cov_2.486822_g1234_i0	PRJEB76780	1327	718	2.486822	17.85538196	Solumvirus sp.	2487773	Viruses	Viruses	206	3.6100000000000003e-63	NR	AYV86227.1	2487773	g1234	i0	68.4	0.647632311977716	155	49	64.8	0	671	207	28	182	AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.]	diamond	465	206	1	Viruses	Pithoviruses							Solumvirus sp.
30792484	30792484	PRJEB76780_P_NODE_12594_length_245_cov_0.906977_g12494_i0	PRJEB76780	12594	245	0.906977	2.22209365	Harvfovirus sp.	2487768	Viruses	Viruses	57.8	1.89e-7	NR	AYV81013.1	2487768	g12494	i0	60	0.489795918367347	40	16	49	0	6	125	362	401	AYV81013.1 MAG: SPFH domain / Band 7 domain containing protein [Harvfovirus sp.]	diamond	120	57.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus 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);;