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

10 rows where bioproject = "PRJNA1215813" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
15634630	15634630	PRJNA1215813_P_NODE_11173_length_247_cov_0.896552_g11093_i0	PRJNA1215813	11173	247	0.896552	2.21448344	Caudoviricetes sp.	2832643	Viruses	Viruses	67.6	7.97e-7	NTclustered	gi\|2059648567\|tpg\|BK028738.1\|	2832643	g11093	i0	95.238	0.866396761133603	42	2	17	0	173	214	12537	12578	MAG TPA_asm: Caudoviricetes sp. isolate ctAhW3, partial genome	blastn	214	67.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15634640	15634640	PRJNA1215813_P_NODE_11873_length_244_cov_0.912281_g11793_i0	PRJNA1215813	11873	244	0.912281	2.22596564	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	285	1.99e-72	NTclustered	gi\|2754691800\|gb\|PP872668.1\|	3003959	g11793	i0	87.705	1	244	30	100	0	1	244	6519	6762	MAG: Picornavirales sp. isolate TC-PLV-112 MR233-17E/429 genomic sequence	blastn	244	285	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
26597562	26597562	PRJNA1215813_P_NODE_3641_length_399_cov_0.953988_g3561_i0	PRJNA1215813	3641	399	0.953988	3.80641212	uncultured virus	340016	Viruses	Viruses	52	1.22e-4	NR	CAH6419199.1	340016	g3561	i0	28.4	2.66917293233083	109	69	81.2	3	5	328	714	814	CAH6419199.1 2-5 RNA ligase superfamily [uncultured virus]	diamond	1065	52	1	Viruses							uncultured virus
29112647	29112647	PRJNA1215813_P_NODE_4388_length_366_cov_1.064846_g4308_i0	PRJNA1215813	4388	366	1.064846	3.89733636	Avipoxvirus	10260	Viruses	Viruses	58.5	4.26e-7	NR	WWM22175.1	1928336	g4308	i0	40	1.9672131147541	60	36	49.2	0	348	169	4	63	WWM22175.1 MAG: ankyrin repeat family protein [Avipoxvirus sp.]	diamond	720	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Avipoxvirus	Avipoxvirus sp.
29472363	29472363	PRJNA1215813_P_NODE_6770_length_301_cov_1.368421_g6690_i0	PRJNA1215813	6770	301	1.368421	4.11894721	Tupanvirus deep ocean	2126984	Viruses	Viruses	53.9	3.42e-6	NR	YP_010781270.1	2126984	g6690	i0	41.7	0.478405315614618	48	28	47.8	0	48	191	10	57	YP_010781270.1 putative ORFan [Tupanvirus deep ocean]	diamond	144	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
30072608	30072608	PRJNA1215813_P_NODE_9632_length_252_cov_0.871508_g9552_i0	PRJNA1215813	9632	252	0.871508	2.19620016	Harvfovirus sp.	2487768	Viruses	Viruses	64.7	6.31e-10	NR	AYV81699.1	2487768	g9552	i0	52.1	1.80952380952381	48	23	57.1	0	89	232	286	333	AYV81699.1 MAG: hypothetical protein Harvfovirus53_9 [Harvfovirus sp.]	diamond	456	64.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
30326004	30326004	PRJNA1215813_P_NODE_12092_length_243_cov_1.011765_g12012_i0	PRJNA1215813	12092	243	1.011765	2.45858895	Barrevirus sp.	2487763	Viruses	Viruses	48.5	2.48e-4	NR	AYV77273.1	2487763	g12012	i0	33.3	0.925925925925926	75	48	92.6	1	232	8	37	109	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	225	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
32222446	32222446	PRJNA1215813_P_NODE_2918_length_443_cov_1.054054_g2838_i0	PRJNA1215813	2918	443	1.054054	4.66945922	uncultured Caudovirales phage	2100421	Viruses	Viruses	46.2	0.0191	NR	CAB4159088.1	2100421	g2838	i0	60	0.237020316027088	35	14	23.7	0	443	339	1791	1825	CAB4159088.1 Intramolecular chaperone auto-processing domain containing protein [uncultured Caudovirales phage]	diamond	105	46.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32633168	32633168	PRJNA1215813_P_NODE_920_length_744_cov_3.295082_g850_i0	PRJNA1215813	920	744	3.295082	24.51541008	Barrevirus sp.	2487763	Viruses	Viruses	99	3.76e-21	NR	AYV77273.1	2487763	g850	i0	28.2	0.870967741935484	216	148	86.3	5	703	62	10	220	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	648	99	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
32696285	32696285	PRJNA1215813_P_NODE_980_length_724_cov_3.218126_g907_i0	PRJNA1215813	980	724	3.218126	23.29923224	Barrevirus sp.	2487763	Viruses	Viruses	111	6.48e-26	NR	AYV77273.1	2487763	g907	i0	28	0.874309392265193	211	148	86.2	2	709	86	11	220	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	633	111	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus 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);;