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

10 rows where bioproject = "PRJNA785164" and tax_kingdom = "Sangervirae"

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
17344512	17344512	PRJNA785164_P_NODE_43194_length_274_cov_1.542289_g42729_i0	PRJNA785164	43194	274	1.542289	4.22587186	Microviridae sp.	2202644	Viruses	Viruses	435	2.14e-117	NTclustered	gi\|2906153649\|gb\|PQ646741.1\|	2202644	g42729	i0	95.255	4.63868613138686	274	13	100	0	1	274	3434	3707	MAG: Microviridae sp. isolate k127_959686 genomic sequence	blastn	1271	435	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
26800426	26800426	PRJNA785164_P_NODE_29361_length_338_cov_1.320755_g28896_i0	PRJNA785164	29361	338	1.320755	4.4641519	Microviridae sp.	2202644	Viruses	Viruses	73.6	5.21e-13	NR	AXH77432.1	2202644	g28896	i0	51	0.869822485207101	98	41	87	1	43	336	125	215	AXH77432.1 MAG: DNA pilot protein [Microviridae sp.]	diamond	294	73.6	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
27062896	27062896	PRJNA785164_P_NODE_44102_length_271_cov_1.651515_g43637_i0	PRJNA785164	44102	271	1.651515	4.47560565	Viruses	10239	Viruses	Viruses	142	4.359999999999999e-41	NR	QJB19466.1	2202559	g43637	i0	76.7	2.87822878228782	90	19	99.6	1	1	270	31	118	QJB19466.1 MAG: internal scaffolding protein [Microvirus sp.]	diamond	780	142	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27306658	27306658	PRJNA785164_P_NODE_54663_length_248_cov_0.880000_g54198_i0	PRJNA785164	54663	248	0.88	2.1824	Arizlama microvirus	2859450	Viruses	Viruses	63.9	1.33e-9	NR	QXP08159.1	2859450	g54198	i0	77.8	1.39112903225806	36	8	43.5	0	109	2	1	36	QXP08159.1 MAG: major capsid protein [Arizlama microvirus]	diamond	345	63.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Arizlama microvirus
27748897	27748897	PRJNA785164_P_NODE_25704_length_365_cov_4.414384_g25239_i0	PRJNA785164	25704	365	4.414384	16.1125016	Microvirus sp.	2202559	Viruses	Viruses	77	2.77e-15	NR	QJB19246.1	2202559	g25239	i0	51.2	0.673972602739726	82	36	67.4	1	345	100	48	125	QJB19246.1 MAG: hypothetical protein [Microvirus sp.]	diamond	246	77	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
28348531	28348531	PRJNA785164_P_NODE_61786_length_241_cov_0.916667_g61321_i0	PRJNA785164	61786	241	0.916667	2.20916747	Apis mellifera associated microvirus 28	2494756	Viruses	Viruses	92	2.5300000000000003e-22	NR	AZL82887.1	2494756	g61321	i0	54.2	1.79253112033195	72	33	89.6	0	21	236	15	86	AZL82887.1 nonstructural protein [Apis mellifera associated microvirus 28]	diamond	432	92	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Apis mellifera associated microvirus 28
30085140	30085140	PRJNA785164_P_NODE_21892_length_404_cov_1.069486_g21427_i0	PRJNA785164	21892	404	1.069486	4.32072344	Ariapismic virus 121	3376350	Viruses	Viruses	96.7	8.809999999999999e-23	NR	XJW04943.1	3376350	g21427	i0	58.2	0.586633663366337	79	32	57.9	1	383	150	25	103	XJW04943.1 MAG: internal scaffolding protein [Ariapismic virus 121]	diamond	237	96.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Ariapismic virus 121
30843652	30843652	PRJNA785164_P_NODE_54154_length_248_cov_0.902857_g53689_i0	PRJNA785164	54154	248	0.902857	2.23908536	Microviridae sp.	2202644	Viruses	Viruses	159	5.93e-44	NR	AXH76520.1	2202644	g53689	i0	89	0.991935483870968	82	9	99.2	0	247	2	463	544	AXH76520.1 MAG: major capsid protein [Microviridae sp.]	diamond	246	159	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
31064974	31064974	PRJNA785164_P_NODE_49615_length_255_cov_1.197802_g49150_i0	PRJNA785164	49615	255	1.197802	3.0543951	Microvirus sp.	2202559	Viruses	Viruses	74.7	2.31e-13	NR	WNK14788.1	2202559	g49150	i0	69.4	1.61176470588235	49	15	57.6	0	247	101	22	70	WNK14788.1 MAG: major capsid protein [Microvirus sp.]	diamond	411	74.7	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
31358613	31358613	PRJNA785164_P_NODE_43236_length_274_cov_1.532338_g42771_i0	PRJNA785164	43236	274	1.532338	4.19860612	Viruses	10239	Viruses	Viruses	77.4	1.13e-15	NR	XJW05182.1	3376395	g42771	i0	47.4	6.81021897810219	78	41	85.4	0	242	9	65	142	XJW05182.1 MAG: internal scaffolding protein [Ariapismic virus 162]	diamond	1866	77.8	0.994858611825193	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Ariapismic virus 162

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