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

10 rows where bioproject = "PRJNA432257" and tax_kingdom = "Shotokuvirae"

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
13182797	13182797	PRJNA432257_S_NODE_112451_length_164_cov_1.212598_g112070_i0	PRJNA432257	112451	164	1.212598	1.98866072	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	292	7.41e-75	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g112070	i0	98.78	5	164	2	100	0	1	164	3843	3680	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	820	292	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
23381306	23381306	PRJNA432257_S_NODE_119179_length_157_cov_3.216667_g118798_i0	PRJNA432257	119179	157	3.216667	5.05016719	Parvoviridae sp.	1940570	Viruses	Viruses	60.2	7.74e-5	NTclustered	gi\|2896100628\|gb\|PQ792202.1\|	1940570	g118798	i0	91.111	0.573248407643312	45	2	28	2	80	123	3179	3136	MAG: Parvoviridae sp. isolate Sarthropod017_parvo2 genomic sequence	blastn	90	60.2	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
26791091	26791091	PRJNA432257_S_NODE_9021_length_424_cov_7.720930_g8677_i0	PRJNA432257	9021	424	7.72093	32.7367432	Betapolyomavirus macacae	1891767	Viruses	Viruses	53.9	3.03e-5	NR	AAK29054.1	1891767	g8677	i0	68.4	0.268867924528302	38	12	26.9	0	404	291	500	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	114	53.9	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
27881909	27881909	PRJNA432257_S_NODE_114405_length_162_cov_1.248000_g114024_i0	PRJNA432257	114405	162	1.248	2.02176	Viruses	10239	Viruses	Viruses	57.4	6.3e-8	NR	WDW25903.1	2748378	g114024	i0	50	3.7037037037037	50	19	92.6	1	151	2	97	140	WDW25903.1 MAG: putative capsid protein [Cressdnaviricota sp.]	diamond	600	57.8	0.993079584775087	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
29791290	29791290	PRJNA432257_S_NODE_14591_length_358_cov_38.398754_g14210_i0	PRJNA432257	14591	358	38.398754	137.46753932	Betapolyomavirus macacae	1891767	Viruses	Viruses	62	2.39e-8	NR	AAK29054.1	1891767	g14210	i0	70.5	0.368715083798883	44	13	36.9	0	160	291	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	132	62	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
30581070	30581070	PRJNA432257_S_NODE_21753_length_313_cov_3.018116_g21372_i0	PRJNA432257	21753	313	3.018116	9.44670308	Circoviridae sp.	1954248	Viruses	Viruses	47	0.00224	NR	AXQ66120.1	1954248	g21372	i0	47.5	0.383386581469649	40	21	38.3	0	150	31	178	217	AXQ66120.1 MAG: putative capsid protein [Circoviridae sp.]	diamond	120	47	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
31609307	31609307	PRJNA432257_S_NODE_14776_length_356_cov_779.115987_g14395_i0	PRJNA432257	14776	356	779.115987	2773.65291372	root	1	Root_unresolved	Root_unresolved	100	8.93e-24	NR	CAA10165.1	1891767	g14395	i0	71.6	2.20786516853933	67	15	53.1	1	189	1	77	143	CAA10165.1 large tumor antigen [Betapolyomavirus macacae]	diamond	786	100	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31640809	31640809	PRJNA432257_S_NODE_17136_length_339_cov_10.364238_g16755_i0	PRJNA432257	17136	339	10.364238	35.13476682	root	1	Root_unresolved	Root_unresolved	99	2.1e-23	NR	CAA10165.1	1891767	g16755	i0	70.1	2.31858407079646	67	16	55.8	1	151	339	77	143	CAA10165.1 large tumor antigen [Betapolyomavirus macacae]	diamond	786	99	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
31782396	31782396	PRJNA432257_S_NODE_2277_length_710_cov_41.083210_g2128_i0	PRJNA432257	2277	710	41.08321	291.690791	Cressdnaviricota sp.	2748378	Viruses	Viruses	56.6	2.11e-5	NR	AXH77804.1	2748378	g2128	i0	34.5	0.874647887323944	113	71	46.9	3	327	659	57	168	AXH77804.1 MAG: capsid protein [Cressdnaviricota sp.]	diamond	621	56.6	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
32447240	32447240	PRJNA432257_S_NODE_64059_length_210_cov_201.641618_g63678_i0	PRJNA432257	64059	210	201.641618	423.4473978	Betapolyomavirus macacae	1891767	Viruses	Viruses	71.2	2.1e-12	NR	AAK29054.1	1891767	g63678	i0	85.7	0.6	42	6	60	0	3	128	496	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	126	71.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);;