metadata: contig_metadata: 5 rows where bioproject = "PRJNA675331" and tax

5 rows where bioproject = "PRJNA675331" 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
3198708	3198708	PRJNA675331_P_NODE_5403_length_412_cov_1.123894_g5231_i0	PRJNA675331	5403	412	1.123894	4.63044328	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	139	2.95e-28	NTclustered	gi\|2500384359\|ref\|NC_077067.1\|	3060017	g5231	i0	91.919	0.466019417475728	99	8	25	0	306	404	471804	471706	Fadolivirus 1 strain FV1/VV64, partial genome	blastn	192	139	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
15197018	15197018	PRJNA675331_P_NODE_10992_length_303_cov_1.482609_g10820_i0	PRJNA675331	10992	303	1.482609	4.49230527	Terrestrivirus sp.	2487775	Viruses	Viruses	94	6.18e-20	NR	AYV75677.1	2487775	g10820	i0	52.6	1.57425742574257	78	37	77.2	0	2	235	263	340	AYV75677.1 MAG: putative AAA+ family ATPase [Terrestrivirus sp.]	diamond	477	94	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
28661033	28661033	PRJNA675331_P_NODE_22047_length_244_cov_0.900585_g21875_i0	PRJNA675331	22047	244	0.900585	2.1974274	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	114	2.2300000000000003e-27	NR	YP_010804150.1	3060017	g21875	i0	65	0.983606557377049	80	28	98.4	0	241	2	311	390	YP_010804150.1 ubiquitin-conjugating enzyme E2 [Fadolivirus algeromassiliense]	diamond	240	114	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31725348	31725348	PRJNA675331_P_NODE_19437_length_249_cov_0.875000_g19265_i0	PRJNA675331	19437	249	0.875	2.17875	Powai lake megavirus	1842663	Viruses	Viruses	88.6	1.75e-18	NR	YP_010776183.1	1842663	g19265	i0	59.3	1.93975903614458	81	27	90.4	2	244	20	267	347	YP_010776183.1 hypothetical protein QJ849_gp270 [Powai lake megavirus]	diamond	483	88.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus powaiense
31990255	31990255	PRJNA675331_P_NODE_11638_length_296_cov_1.035874_g11466_i0	PRJNA675331	11638	296	1.035874	3.06618704	Mimiviridae	549779	Viruses	Viruses	174	5.75e-48	NR	YP_004894608.1	1094892	g11466	i0	79.6	2.97972972972973	98	20	99.3	0	3	296	652	749	YP_004894608.1 putative regulator of chromosome condensation [Megavirus chiliensis]	diamond	882	175	0.994285714285714	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense

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