metadata: contig_metadata: 11 rows where bioproject = "PRJNA168635", tax_phylum = "Phixviricota" and tax

11 rows where bioproject = "PRJNA168635", 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
13118095	13118095	PRJNA168635_P_NODE_13391_length_221_cov_13.558140_g12975_i0	PRJNA168635	13391	221	13.55814	29.9634894	Microviridae sp.	2202644	Viruses	Viruses	113	8.860000000000001e-21	NTclustered	gi\|2384853730\|gb\|OM154885.1\|	2202644	g12975	i0	84.348	1.289592760181	115	18	52	0	97	211	2241	2127	MAG: Microviridae sp. isolate Miresoil microvirus 66, complete genome	blastn	285	113	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
16941963	16941963	PRJNA168635_P_NODE_5594_length_357_cov_4.847403_g5189_i0	PRJNA168635	5594	357	4.847403	17.30522871	Microviridae sp.	2202644	Viruses	Viruses	355	2.3e-93	NTclustered	gi\|1509245247\|gb\|MG883728.1\|	2202644	g5189	i0	84.831	3.07282913165266	356	51	99	2	4	356	3834	3479	Microviridae sp. isolate Flamingo05, partial genome	blastn	1097	355	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
19490532	19490532	PRJNA168635_P_NODE_29736_length_164_cov_1.234783_g29320_i0	PRJNA168635	29736	164	1.234783	2.02504412	Microviridae sp.	2202644	Viruses	Viruses	148	1.6999999999999996e-31	NTclustered	gi\|2216796470\|gb\|MW202471.1\|	2202644	g29320	i0	82.927	2.86585365853659	164	28	100	0	1	164	28	191	Microviridae sp. isolate ctUFZ915, complete genome	blastn	470	148	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
20765828	20765828	PRJNA168635_P_NODE_11717_length_239_cov_2.468421_g11301_i0	PRJNA168635	11717	239	2.468421	5.89952619	Microviridae sp.	2202644	Viruses	Viruses	131	6.22e-35	NR	AYQ58224.1	2202644	g11301	i0	74.4	0.97907949790795	78	20	97.9	0	236	3	226	303	AYQ58224.1 putative VP4 [Microviridae sp.]	diamond	234	131	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
27042321	27042321	PRJNA168635_P_NODE_30842_length_163_cov_0.912281_g30426_i0	PRJNA168635	30842	163	0.912281	1.48701803	Microvirus sp.	2202559	Viruses	Viruses	72	5.98e-13	NR	QJB19640.1	2202559	g30426	i0	66	2.96319018404908	53	18	97.5	0	162	4	123	175	QJB19640.1 MAG: major capsid protein [Microvirus sp.]	diamond	483	72	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27831964	27831964	PRJNA168635_P_NODE_10064_length_261_cov_4.801887_g9649_i0	PRJNA168635	10064	261	4.801887	12.53292507	Microviridae sp.	2202644	Viruses	Viruses	57.4	2.13e-8	NR	AYQ58225.1	2202644	g9649	i0	45.2	0.71264367816092	62	34	71.3	0	228	43	1	62	AYQ58225.1 putative VP3 [Microviridae sp.]	diamond	186	57.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
29284232	29284232	PRJNA168635_P_NODE_26989_length_167_cov_1.415254_g26573_i0	PRJNA168635	26989	167	1.415254	2.36347418	Microvirus sp.	2202559	Viruses	Viruses	80.9	1.62e-16	NR	WNK12612.1	2202559	g26573	i0	69.1	0.988023952095808	55	17	98.8	0	166	2	232	286	WNK12612.1 MAG: replication initiator protein [Microvirus sp.]	diamond	165	80.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
30231881	30231881	PRJNA168635_P_NODE_25872_length_168_cov_2.235294_g25456_i0	PRJNA168635	25872	168	2.235294	3.75529392	Microviridae sp.	2202644	Viruses	Viruses	102	1.04e-24	NR	XOF03717.1	2202644	g25456	i0	83.6	0.982142857142857	55	9	98.2	0	167	3	128	182	XOF03717.1 MAG: replication initiation protein [Microviridae sp.]	diamond	165	102	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
30547805	30547805	PRJNA168635_P_NODE_22453_length_175_cov_1.642857_g22037_i0	PRJNA168635	22453	175	1.642857	2.87499975	Microviridae sp.	2202644	Viruses	Viruses	53.9	1.63e-6	NR	AXL15382.1	2202644	g22037	i0	54	5.16	50	21	84	2	170	24	165	213	AXL15382.1 major capsid protein [Microviridae sp.]	diamond	903	53.9	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
30660432	30660432	PRJNA168635_P_NODE_29253_length_165_cov_0.896552_g28837_i0	PRJNA168635	29253	165	0.896552	1.4793108	Microvirus	10842	Viruses	Viruses	58.5	3.37e-8	NR	WQF93003.1	2202644	g28837	i0	48.9	6.32727272727273	45	23	81.8	0	140	6	429	473	WQF93003.1 MAG: major capsid protein, partial [Microviridae sp.]	diamond	1044	58.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
32634359	32634359	PRJNA168635_P_NODE_6780_length_325_cov_7.344203_g6369_i0	PRJNA168635	6780	325	7.344203	23.86865975	Microviridae sp.	2202644	Viruses	Viruses	162	4.02e-44	NR	AXH76381.1	2202644	g6369	i0	87.2	0.793846153846154	86	11	79.4	0	263	6	1	86	AXH76381.1 MAG: major capsid protein [Microviridae sp.]	diamond	258	162	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae 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);;