metadata: contig_metadata: 13 rows where bioproject = "PRJEB64798" and tax

13 rows where bioproject = "PRJEB64798" and tax_clade = "Cruciviruses"

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_clade	tax_species
14156875	14156875	PRJEB64798_P_NODE_244412_length_153_cov_13.798077_g242646_i0	PRJEB64798	244412	153	13.798077	21.11105781	Cruciviridae sp.	1955495	Viruses	Viruses	241	2.49e-59	NTclustered	gi\|1150480486\|gb\|KX388499.1\|	1955495	g242646	i0	95.946	1.71895424836601	148	6	97	0	1	148	3368	3221	Cruciviridae sp. isolate CRUV-20-B genomic sequence	blastn	263	241	1	Viruses	Cruciviruses	Cruciviridae sp.
27128180	27128180	PRJEB64798_P_NODE_218842_length_162_cov_5.778761_g217076_i0	PRJEB64798	218842	162	5.778761	9.36159282	Crucivirus sp.	2569971	Viruses	Viruses	68.9	7.27e-12	NR	QKV51154.1	2569971	g217076	i0	63	1	54	18	96.3	1	159	4	141	194	QKV51154.1 putative capsid protein [Crucivirus sp.]	diamond	162	68.9	1	Viruses	Cruciviruses	Crucivirus sp.
27128218	27128218	PRJEB64798_P_NODE_27822_length_373_cov_5.879630_g26067_i0	PRJEB64798	27822	373	5.87963	21.9310199	Army ant associated crucivirus 1	3014124	Viruses	Viruses	49.3	7.55e-4	NR	WAX26095.1	3014124	g26067	i0	47.5	0.973190348525469	59	27	47.5	2	181	5	36	90	WAX26095.1 MAG: capsid protein [Army ant associated crucivirus 1]	diamond	363	49.3	1	Viruses	Cruciviruses	Army ant associated crucivirus 1
27785228	27785228	PRJEB64798_P_NODE_20144_length_444_cov_4.035443_g18414_i0	PRJEB64798	20144	444	4.035443	17.91736692	Viruses	10239	Viruses	Viruses	55.5	1.05e-5	NR	QMW68814.1	2761280	g18414	i0	30.1	2.24324324324324	123	75	80.4	4	4	360	95	210	QMW68814.1 capsid protein [Crucivirus-349]	diamond	996	55.5	1	Viruses	Cruciviruses	Crucivirus-349
28076018	28076018	PRJEB64798_P_NODE_252845_length_150_cov_9.524752_g251079_i0	PRJEB64798	252845	150	9.524752	14.287128	Crucivirus-389	2761292	Viruses	Viruses	43.5	0.00575	NR	QMW68852.1	2761292	g251079	i0	42.9	0.98	49	22	88	2	141	10	287	334	QMW68852.1 capsid protein [Crucivirus-389]	diamond	147	43.5	1	Viruses	Cruciviruses	Crucivirus-389
28676239	28676239	PRJEB64798_P_NODE_83667_length_213_cov_6.085366_g81901_i0	PRJEB64798	83667	213	6.085366	12.96182958	Cruciviridae sp.	1955495	Viruses	Viruses	52	1.33e-5	NR	AQU11706.1	1955495	g81901	i0	63.6	1.38028169014085	33	12	46.5	0	114	212	115	147	AQU11706.1 capsid protein [Cruciviridae sp.]	diamond	294	52	1	Viruses	Cruciviruses	Cruciviridae sp.
28896911	28896911	PRJEB64798_P_NODE_226708_length_160_cov_3.009009_g224942_i0	PRJEB64798	226708	160	3.009009	4.8144144	Crucivirus sp.	2569971	Viruses	Viruses	44.3	0.0035	NR	QKV51308.1	2569971	g224942	i0	44.9	3.675	49	27	91.9	0	7	153	223	271	QKV51308.1 putative capsid protein [Crucivirus sp.]	diamond	588	44.3	1	Viruses	Cruciviruses	Crucivirus sp.
29244441	29244441	PRJEB64798_P_NODE_4229_length_928_cov_8.824801_g3313_i0	PRJEB64798	4229	928	8.824801	81.89415328	Crucivirus-468	2761311	Viruses	Viruses	49.7	0.0118	NR	QMW68924.1	2761311	g3313	i0	29.3	0.452586206896552	140	82	44.6	5	451	864	65	189	QMW68924.1 capsid protein [Crucivirus-468]	diamond	420	49.7	1	Viruses	Cruciviruses	Crucivirus-468
29244464	29244464	PRJEB64798_P_NODE_6629_length_763_cov_9.581232_g5385_i0	PRJEB64798	6629	763	9.581232	73.10480016	Crucivirus-389	2761292	Viruses	Viruses	48.9	0.0123	NR	QMW68852.1	2761292	g5385	i0	30.5	0.644823066841415	164	106	62.1	5	646	173	287	448	QMW68852.1 capsid protein [Crucivirus-389]	diamond	492	48.9	1	Viruses	Cruciviruses	Crucivirus-389
29907503	29907503	PRJEB64798_P_NODE_175071_length_176_cov_7.874016_g173305_i0	PRJEB64798	175071	176	7.874016	13.85826816	Crucivirus sp.	2569971	Viruses	Viruses	43.1	0.0111	NR	QKV51284.1	2569971	g173305	i0	42.6	0.801136363636364	47	27	80.1	0	31	171	156	202	QKV51284.1 putative capsid protein [Crucivirus sp.]	diamond	141	43.1	1	Viruses	Cruciviruses	Crucivirus sp.
30159820	30159820	PRJEB64798_P_NODE_1212_length_1584_cov_47.549837_g892_i0	PRJEB64798	1212	1584	47.549837	753.18941808	Cruciviridae sp.	1955495	Viruses	Viruses	50.1	0.0224	NR	AQU11708.1	1955495	g892	i0	56.8	0.0833333333333333	44	17	8.3	1	1274	1143	114	155	AQU11708.1 capsid protein [Cruciviridae sp.]	diamond	132	50.1	1	Viruses	Cruciviruses	Cruciviridae sp.
31163985	31163985	PRJEB64798_P_NODE_207835_length_165_cov_3.896552_g206069_i0	PRJEB64798	207835	165	3.896552	6.4293108	Viruses	10239	Viruses	Viruses	58.5	3.36e-8	NR	QMW69072.1	2761502	g206069	i0	54.9	3.78181818181818	51	23	92.7	0	11	163	189	239	QMW69072.1 capsid protein [Crucivirus-like circular genetic element-471]	diamond	624	58.5	1	Viruses	Cruciviruses	Crucivirus-like circular genetic element-471
31512395	31512395	PRJEB64798_P_NODE_228976_length_159_cov_3.554545_g227210_i0	PRJEB64798	228976	159	3.554545	5.65172655	Viruses	10239	Viruses	Viruses	47.8	1.99e-4	NR	QKV51102.1	2569971	g227210	i0	51	1.94339622641509	49	23	90.6	1	155	12	236	284	QKV51102.1 putative capsid protein [Crucivirus sp.]	diamond	309	47.8	1	Viruses	Cruciviruses	Crucivirus 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);;