metadata: contig_metadata: 10 rows where bioproject = "PRJNA846486", tax_kingdom = "Shotokuvirae" and tax

10 rows where bioproject = "PRJNA846486", tax_kingdom = "Shotokuvirae" 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
3783283	3783283	PRJNA846486_P_NODE_22683_length_271_cov_1.770270_g22587_i0	PRJNA846486	22683	271	1.77027	4.7974317	Viruses	10239	Viruses	Viruses	285	2.25e-72	NTclustered	gi\|2496529063\|gb\|OP577481.1\|	3042448	g22587	i0	98.16	3.16605166051661	163	3	100	0	109	271	1045	1207	Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome	blastn	858	285	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform parvoviridae sp.
7211342	7211342	PRJNA846486_P_NODE_20666_length_282_cov_1.472103_g20570_i0	PRJNA846486	20666	282	1.472103	4.15133046	Psittaciform aveparvovirus	3042447	Viruses	Viruses	483	7.78e-132	NTclustered	gi\|2496529059\|gb\|OP577479.1\|	3042447	g20570	i0	99.621	1.87234042553191	264	1	94	0	19	282	333	70	Psittaciform aveparvovirus strain OBP1/FE1/29/2021, partial genome	blastn	528	483	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus
12312543	12312543	PRJNA846486_P_NODE_88790_length_164_cov_0.904348_g88694_i0	PRJNA846486	88790	164	0.904348	1.48313072	Parvoviridae sp.	1940570	Viruses	Viruses	254	3.5e-63	NTclustered	gi\|2814138553\|gb\|PQ313134.1\|	1940570	g88694	i0	97.931	2.24390243902439	145	3	88	0	20	164	702	558	Parvoviridae sp. isolate SpinColumn19, partial genome	blastn	368	254	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
12711034	12711034	PRJNA846486_P_NODE_27390_length_251_cov_0.821782_g27294_i0	PRJNA846486	27390	251	0.821782	2.06267282	Viruses	10239	Viruses	Viruses	241	4.52e-59	NTclustered	gi\|2496529063\|gb\|OP577481.1\|	3042448	g27294	i0	96.552	3	145	5	100	0	107	251	619	763	Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome	blastn	753	241	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform parvoviridae sp.
12711047	12711047	PRJNA846486_P_NODE_4950_length_537_cov_3.145492_g4861_i0	PRJNA846486	4950	537	3.145492	16.89129204	Viruses	10239	Viruses	Viruses	893	0	NTclustered	gi\|2496529063\|gb\|OP577481.1\|	3042448	g4861	i0	99.39	2.71694599627561	492	3	92	0	1	492	2234	2725	Psittaciform parvoviridae sp. strain OBP1/FE1/44/2021, partial genome	blastn	1459	896	0.996651785714286	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform parvoviridae sp.
17808935	17808935	PRJNA846486_P_NODE_14014_length_334_cov_2.056140_g13918_i0	PRJNA846486	14014	334	2.05614	6.8675076	Psittaciform aveparvovirus	3042447	Viruses	Viruses	612	1.15e-170	NTclustered	gi\|2814138549\|gb\|PQ313132.1\|	3042447	g13918	i0	99.701	2	334	1	100	0	1	334	22	355	Parvoviridae sp. isolate SpinColumn17, partial genome	blastn	668	612	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform aveparvovirus
17808954	17808954	PRJNA846486_P_NODE_53214_length_193_cov_2.125000_g53118_i0	PRJNA846486	53214	193	2.125	4.10125	Psittaciform aveparvovirus	3042447	Viruses	Viruses	342	8.819999999999999e-90	NTclustered	gi\|2814138549\|gb\|PQ313132.1\|	3042447	g53118	i0	100	1.91709844559585	185	0	96	0	1	185	425	609	Parvoviridae sp. isolate SpinColumn17, partial genome	blastn	370	342	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform aveparvovirus
26683208	26683208	PRJNA846486_P_NODE_85941_length_165_cov_0.896552_g85845_i0	PRJNA846486	85941	165	0.896552	1.4793108	Viruses	10239	Viruses	Viruses	45.8	0.00104	NR	QKK82944.1	2739858	g85845	i0	54.5	1.21818181818182	33	13	56.4	1	72	164	173	205	QKK82944.1 hypothetical protein 3 [Forsythia suspensa parvo-like virus]	diamond	201	45.8	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Forsythia suspensa parvo-like virus
29422957	29422957	PRJNA846486_P_NODE_67609_length_177_cov_0.984375_g67513_i0	PRJNA846486	67609	177	0.984375	1.74234375	Parvoviridae sp.	1940570	Viruses	Viruses	42	0.0286	NR	XNT20757.1	1940570	g67513	i0	50	0.610169491525424	36	18	61	0	109	2	366	401	XNT20757.1 MAG: replication protein [Parvoviridae sp.]	diamond	108	42	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
29801974	29801974	PRJNA846486_P_NODE_11651_length_364_cov_2.895238_g11556_i0	PRJNA846486	11651	364	2.895238	10.53866632	Phylloscopus proregulus parvoviridae sp.	2794532	Viruses	Viruses	83.6	7.41e-16	NR	QTE04069.1	2794532	g11556	i0	53.1	0.667582417582418	81	37	65.9	1	364	125	559	639	QTE04069.1 MAG: VP [Phylloscopus proregulus parvoviridae sp.]	diamond	243	83.6	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Phylloscopus proregulus parvoviridae 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);;