metadata: contig_metadata: 9 rows where bioproject = "PRJNA773247", tax_phylum = "Phixviricota" and tax

9 rows where bioproject = "PRJNA773247", tax_phylum = "Phixviricota" 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_species
5852377	5852377	PRJNA773247_P_NODE_21645_length_305_cov_5.357759_g21561_i0	PRJNA773247	21645	305	5.357759	16.34116495	Microviridae sp.	2202644	Viruses	Viruses	152	2.73e-32	NTclustered	gi\|2302011453\|gb\|MT202805.1\|	2202644	g21561	i0	91.228	1.1344262295082	114	7	37	3	1	112	3172	3060	MAG: Microviridae sp. isolate CN7_L15_1128, complete genome	blastn	346	152	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
8401939	8401939	PRJNA773247_P_NODE_16147_length_366_cov_5.187713_g16063_i0	PRJNA773247	16147	366	5.187713	18.98702958	Microvirus sp.	2202559	Viruses	Viruses	240	3.7e-74	NR	QJB19270.1	2202559	g16063	i0	94.2	0.991803278688525	121	7	99.2	0	1	363	335	455	QJB19270.1 MAG: major capsid protein [Microvirus sp.]	diamond	363	240	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27811678	27811678	PRJNA773247_P_NODE_36844_length_219_cov_4.527397_g36760_i0	PRJNA773247	36844	219	4.527397	9.91499943	Microviridae sp.	2202644	Viruses	Viruses	56.6	2.43e-7	NR	AXH74992.1	2202644	g36760	i0	72.7	1.04109589041096	33	9	45.2	0	38	136	161	193	AXH74992.1 MAG: replication initiator protein [Microviridae sp.]	diamond	228	56.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
28506103	28506103	PRJNA773247_P_NODE_35707_length_234_cov_3.770186_g35623_i0	PRJNA773247	35707	234	3.770186	8.82223524	Arizlama microvirus	2859450	Viruses	Viruses	103	1.5799999999999998e-23	NR	QXP08680.1	2859450	g35623	i0	68	0.961538461538462	75	24	96.2	0	234	10	319	393	QXP08680.1 MAG: major capsid protein [Arizlama microvirus]	diamond	225	103	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Arizlama microvirus
28537838	28537838	PRJNA773247_P_NODE_12007_length_442_cov_10.924119_g11924_i0	PRJNA773247	12007	442	10.924119	48.28460598	Microvirus sp.	2202559	Viruses	Viruses	101	5.369999999999999e-23	NR	WNK13917.1	2202559	g11924	i0	62.3	0.52262443438914	77	27	52.3	1	2	232	64	138	WNK13917.1 MAG: replication initiator protein [Microvirus sp.]	diamond	231	101	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
29106113	29106113	PRJNA773247_P_NODE_21968_length_303_cov_2.030435_g21884_i0	PRJNA773247	21968	303	2.030435	6.15221805	Wigfec virus K19_17	2985981	Viruses	Viruses	53.9	5.87e-6	NR	UYD39236.1	2985981	g21884	i0	66.7	0.356435643564356	36	12	35.6	0	298	191	176	211	UYD39236.1 MAG: DNA pilot protein [Wigfec virus K19_170]	diamond	108	53.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Wigfec virus K19_170
29832153	29832153	PRJNA773247_P_NODE_13931_length_402_cov_3.963526_g13847_i0	PRJNA773247	13931	402	3.963526	15.93337452	Microvirus sp.	2202559	Viruses	Viruses	239	7.38e-77	NR	QJB19436.1	2202559	g13847	i0	80.5	1.98507462686567	133	26	99.3	0	401	3	47	179	QJB19436.1 MAG: replication initiator protein [Microvirus sp.]	diamond	798	239	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
30558654	30558654	PRJNA773247_P_NODE_34713_length_241_cov_1.833333_g34629_i0	PRJNA773247	34713	241	1.833333	4.41833253	Apis mellifera associated microvirus 14	2494741	Viruses	Viruses	62.4	3.27e-9	NR	AZL82832.1	2494741	g34629	i0	44.9	0.970954356846473	78	43	97.1	0	235	2	3	80	AZL82832.1 DNA pilot protein [Apis mellifera associated microvirus 14]	diamond	234	62.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Apis mellifera associated microvirus 14
30969758	30969758	PRJNA773247_P_NODE_18134_length_341_cov_1.541045_g18050_i0	PRJNA773247	18134	341	1.541045	5.25496345	Microvirus sp.	2202559	Viruses	Viruses	127	4.68e-32	NR	QJB20656.1	2202559	g18050	i0	59	0.879765395894428	100	39	88	2	38	337	22	119	QJB20656.1 MAG: major capsid protein [Microvirus sp.]	diamond	300	127	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus 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);;