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

5 rows where bioproject = "PRJEB17675" 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
7673907	7673907	PRJEB17675_P_NODE_1827_length_725_cov_3.392754_g1608_i0	PRJEB17675	1827	725	3.392754	24.5974665	root	1	Root_unresolved	Root_unresolved	179	2.91e-51	NR	QFG73901.1	1737588	g1608	i0	44.6	3.66620689655172	222	113	91	5	711	52	114	327	QFG73901.1 MAG: papain family cysteine protease [Megaviridae environmental sample]	diamond	2658	180	0.994444444444444	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
9914009	9914009	PRJEB17675_P_NODE_1368_length_834_cov_1.804756_g1184_i0	PRJEB17675	1368	834	1.804756	15.05166504	Mimivirus	315393	Viruses	Viruses	58.4	0.002	NTclustered	gi\|55416625\|gb\|AY653733.1\|	212035	g1184	i0	100	0.557553956834532	31	0	4	0	346	376	88918	88948	Acanthamoeba polyphaga mimivirus, complete genome	blastn	465	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
26969759	26969759	PRJEB17675_P_NODE_3022_length_567_cov_2.392857_g2753_i0	PRJEB17675	3022	567	2.392857	13.56749919	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	208	3.46e-62	NR	YP_010803269.1	3060017	g2753	i0	60.1	0.862433862433862	163	65	86.2	0	566	78	252	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	489	208	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27917482	27917482	PRJEB17675_P_NODE_22085_length_163_cov_1.562500_g21781_i0	PRJEB17675	22085	163	1.5625	2.546875	Bodo saltans virus	2024608	Viruses	Viruses	43.9	0.00498	NR	YP_010778165.1	2024608	g21781	i0	37.5	1.03067484662577	56	33	99.4	1	163	2	54	109	YP_010778165.1 serine/threonine-protein phosphatase [Bodo saltans virus]	diamond	168	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
29938488	29938488	PRJEB17675_P_NODE_14871_length_211_cov_1.335227_g14567_i0	PRJEB17675	14871	211	1.335227	2.81732897	Homavirus sp.	2487769	Viruses	Viruses	75.1	6.04e-14	NR	AYV82419.1	2487769	g14567	i0	46.4	0.981042654028436	69	37	98.1	0	210	4	254	322	AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.]	diamond	207	75.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus 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);;