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

10 rows where bioproject = "PRJNA352610" and tax_kingdom = "Bamfordvirae"

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
16971262	16971262	PRJNA352610_P_NODE_26174_length_249_cov_2.198864_g26113_i0	PRJNA352610	26174	249	2.198864	5.47517136	Chloriridovirus simulium1	3427924	Viruses	Viruses	285	2.0399999999999997e-72	NTclustered	gi\|589057497\|emb\|HF920634.1\|	345198	g26113	i0	87.449	3.92771084337349	247	31	99	0	3	249	165278	165032	Invertebrate iridescent virus 22 isolate IIV22Aberystwyth complete genome	blastn	978	285	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae	Chloriridovirus	Chloriridovirus simulium1
26694827	26694827	PRJNA352610_P_NODE_32221_length_231_cov_3.367089_g32160_i0	PRJNA352610	32221	231	3.367089	7.77797559	Barrevirus sp.	2487763	Viruses	Viruses	42	0.0307	NR	AYV77266.1	2487763	g32160	i0	42.2	0.584415584415584	45	26	58.4	0	68	202	88	132	AYV77266.1 MAG: hypothetical protein Barrevirus25_9 [Barrevirus sp.]	diamond	135	42	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
26726199	26726199	PRJNA352610_P_NODE_19061_length_287_cov_0.855140_g19000_i0	PRJNA352610	19061	287	0.85514	2.4542518	Ostreococcus tauri virus	70448	Viruses	Viruses	45.4	0.0057	NR	XKM46844.1	3378358	g19000	i0	37	0.564459930313589	54	34	56.4	0	99	260	155	208	XKM46844.1 hypothetical protein OtV06-1_00160 [Ostreococcus tauri virus 06-1]	diamond	162	45.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus tauri virus 06-1
29190710	29190710	PRJNA352610_P_NODE_5529_length_461_cov_1.322165_g5468_i0	PRJNA352610	5529	461	1.322165	6.09518065	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	101	7.09e-23	NR	VBB18130.1	2420051	g5468	i0	51.1	0.598698481561822	92	44	59.9	1	1	276	183	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	276	101	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
30548682	30548682	PRJNA352610_P_NODE_4633_length_494_cov_3.717340_g4572_i0	PRJNA352610	4633	494	3.71734	18.3636596	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	169	4.09e-49	NR	VBB18130.1	2420051	g4572	i0	49.1	1.06275303643725	175	77	99.6	3	492	1	36	209	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	525	169	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
30643349	30643349	PRJNA352610_P_NODE_3793_length_534_cov_1.149675_g3732_i0	PRJNA352610	3793	534	1.149675	6.1392645	Megaviridae environmental sample	1737588	Viruses	Viruses	103	1.13e-23	NR	QFG74608.1	1737588	g3732	i0	31.7	1.04494382022472	186	109	95.5	4	1	510	43	226	QFG74608.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	558	103	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
30706623	30706623	PRJNA352610_P_NODE_7494_length_412_cov_1.109145_g7433_i0	PRJNA352610	7494	412	1.109145	4.5696774	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	98.6	5.93e-22	NR	VBB18130.1	2420051	g7433	i0	53.8	0.58252427184466	80	37	58.3	0	389	150	194	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	240	98.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32224613	32224613	PRJNA352610_P_NODE_24958_length_251_cov_1.235955_g24897_i0	PRJNA352610	24958	251	1.235955	3.10224705	Marseillevirus LCMAC1	2506602	Viruses	Viruses	60.8	1.71e-8	NR	QBK86047.1	2506602	g24897	i0	43.8	0.872509960159363	73	38	87.3	2	15	233	604	673	QBK86047.1 MAG: von willebrand factor type A domain protein [Marseillevirus LCMAC101]	diamond	219	60.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
32572778	32572778	PRJNA352610_P_NODE_4279_length_510_cov_1.297483_g4218_i0	PRJNA352610	4279	510	1.297483	6.6171633	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	184	1.3e-54	NR	VBB18130.1	2420051	g4218	i0	52.5	1.05294117647059	179	73	98.8	3	6	509	82	259	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	537	184	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32730016	32730016	PRJNA352610_P_NODE_13800_length_326_cov_1.221344_g13739_i0	PRJNA352610	13800	326	1.221344	3.98158144	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	119	1.52e-30	NR	VBB18130.1	2420051	g13739	i0	50	1.04907975460123	114	47	95.7	1	318	7	30	143	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	342	119	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense

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