metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
1730322	1730322	PRJNA493244_P_NODE_1387882_length_271_cov_11.952381_g1364757_i0	PRJNA493244	1387882	271	11.952381	32.39095251	Orthopoxvirus monkeypox	3431483	Viruses	Viruses	69.4	2.47e-7	NTclustered	gi\|2797671158\|gb\|PQ281491.1\|	10244	g1364757	i0	100	137.549815498155	37	0	14	0	1	37	197075	197039	Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome	blastn	37276	69.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
1730788	1730788	PRJNA493244_P_NODE_1590102_length_222_cov_6.850932_g1566977_i0	PRJNA493244	1590102	222	6.850932	15.20906904	Mimivirus U306	1932880	Viruses	Viruses	135	1.9e-27	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g1566977	i0	79.104	25.481981981982	201	38	90	4	24	222	877908	877710	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	5657	135	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
15127747	15127747	PRJNA493244_P_NODE_1299272_length_297_cov_1.627119_g1276148_i0	PRJNA493244	1299272	297	1.627119	4.83254343	Megavirus	3044761	Viruses	Viruses	56.5	0.002	NTclustered	gi\|371943237\|gb\|JN885990.1\|	1128135	g1276148	i0	100	0.303030303030303	30	0	10	0	116	145	239975	239946	Megavirus courdo7 isolate Mv13-c7, partial genome	blastn	90	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus courdo7
18308549	18308549	PRJNA493244_P_NODE_386715_length_854_cov_2.800757_g368836_i0	PRJNA493244	386715	854	2.800757	23.91846478	Homavirus sp.	2487769	Viruses	Viruses	58.4	0.002	NTclustered	gi\|1512477916\|gb\|MK072362.1\|	2487769	g368836	i0	97.059	0.0398126463700234	34	1	4	0	180	213	197	164	MAG: Homavirus sp. clone Homavirus_31 genomic sequence	blastn	34	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.
20858183	20858183	PRJNA493244_P_NODE_1750557_length_177_cov_7.155172_g1727432_i0	PRJNA493244	1750557	177	7.155172	12.66465444	Mimivirus U306	1932880	Viruses	Viruses	97.1	6.81e-16	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g1727432	i0	78.065	10.0621468926554	155	32	87	2	24	177	877908	877755	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	1781	97.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306

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