metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1101946" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1101946" and tax_phylum = "Cossaviricota"

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
27320609	27320609	PRJNA1101946_S_NODE_13643_length_217_cov_15.482143_g13544_i0	PRJNA1101946	13643	217	15.482143	33.59625031	Betapolyomavirus macacae	1891767	Viruses	Viruses	73.2	4.78e-13	NR	AAK29054.1	1891767	g13544	i0	77.3	0.608294930875576	44	10	60.8	0	69	200	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	132	73.2	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
27352372	27352372	PRJNA1101946_S_NODE_3223_length_349_cov_11.043333_g3124_i0	PRJNA1101946	3223	349	11.043333	38.54123217	Betapolyomavirus macacae	1891767	Viruses	Viruses	51.6	9.49e-5	NR	AAK29054.1	1891767	g3124	i0	80.6	0.26647564469914	31	6	26.6	0	348	256	507	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	93	51.6	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
28994296	28994296	PRJNA1101946_S_NODE_17588_length_192_cov_3.209790_g17489_i0	PRJNA1101946	17588	192	3.20979	6.1627968	Betapolyomavirus macacae	1891767	Viruses	Viruses	53.1	4.11e-6	NR	AAK29054.1	1891767	g17489	i0	61.4	2.4375	44	17	68.8	0	22	153	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	468	53.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
29688331	29688331	PRJNA1101946_S_NODE_24110_length_164_cov_2.800000_g24011_i0	PRJNA1101946	24110	164	2.8	4.592	Betapolyomavirus macacae	1891767	Viruses	Viruses	43.1	0.0094	NR	AAK29054.1	1891767	g24011	i0	70	3.03658536585366	30	9	54.9	0	90	1	498	527	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	498	43.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31015507	31015507	PRJNA1101946_S_NODE_8015_length_268_cov_14.981735_g7916_i0	PRJNA1101946	8015	268	14.981735	40.1510498	Betapolyomavirus macacae	1891767	Viruses	Viruses	65.1	6.83e-10	NR	AAK29054.1	1891767	g7916	i0	75	0.492537313432836	44	11	49.3	0	174	43	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	132	65.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31386328	31386328	PRJNA1101946_S_NODE_25656_length_159_cov_5.854545_g25557_i0	PRJNA1101946	25656	159	5.854545	9.30872655	root	1	Root_unresolved	Root_unresolved	44.3	0.00112	NR	AAS20328.1	1891767	g25557	i0	52.6	2.18867924528302	38	17	71.7	1	45	158	76	112	AAS20328.1 large tumor antigen, partial [Betapolyomavirus macacae]	diamond	348	44.3	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31426466	31426466	PRJNA1101946_S_NODE_15936_length_201_cov_14.881579_g15837_i0	PRJNA1101946	15936	201	14.881579	29.91197379	Betapolyomavirus macacae	1891767	Viruses	Viruses	50.4	1.88e-6	NR	AAF28272.1	1891767	g15837	i0	55.1	3.14925373134328	49	21	73.1	1	161	15	7	54	AAF28272.1 large t antigen, partial [Betapolyomavirus macacae]	diamond	633	50.4	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31553259	31553259	PRJNA1101946_S_NODE_18256_length_188_cov_17.870504_g18157_i0	PRJNA1101946	18256	188	17.870504	33.59654752	Betapolyomavirus macacae	1891767	Viruses	Viruses	64.3	4.34e-10	NR	AAK29054.1	1891767	g18157	i0	80	0.638297872340426	40	8	63.8	0	120	1	494	533	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	120	64.3	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
32628213	32628213	PRJNA1101946_S_NODE_8020_length_268_cov_11.401826_g7921_i0	PRJNA1101946	8020	268	11.401826	30.55689368	Betapolyomavirus macacae	1891767	Viruses	Viruses	65.1	6.57e-10	NR	AAK29054.1	1891767	g7921	i0	70.5	0.92910447761194	44	13	49.3	0	200	69	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	249	65.1	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
32691237	32691237	PRJNA1101946_S_NODE_8140_length_267_cov_4.224771_g8041_i0	PRJNA1101946	8140	267	4.224771	11.28013857	Betapolyomavirus macacae	1891767	Viruses	Viruses	51.2	5.18e-5	NR	AAK29054.1	1891767	g8041	i0	73	0.415730337078652	37	10	41.6	0	267	157	501	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	111	51.2	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae

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