metadata: contig_metadata: 7 rows where bioproject = "PRJNA577580" and tax

7 rows where bioproject = "PRJNA577580" 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
4391537	4391537	PRJNA577580_P_NODE_6324_length_357_cov_2.003521_g6246_i0	PRJNA577580	6324	357	2.003521	7.15256997	Cotonvirus japonicum	3059904	Viruses	Viruses	67.6	1.21e-6	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g6246	i0	81.395	0.57703081232493	86	12	24	4	3	86	533397	533314	Cotonvirus japonicus DNA, complete genome	blastn	206	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
6241738	6241738	PRJNA577580_P_NODE_7845_length_322_cov_1.831325_g7767_i0	PRJNA577580	7845	322	1.831325	5.8968665	Megavirus	3044761	Viruses	Viruses	78.7	4.99e-10	NTclustered	gi\|363539767\|ref\|NC_016072.1\|	1094892	g7767	i0	84.146	1.7360248447205	82	11	25	2	58	138	1129728	1129808	Megavirus chiliensis, complete genome	blastn	559	78.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
13318047	13318047	PRJNA577580_P_NODE_5031_length_400_cov_1.431193_g4953_i0	PRJNA577580	5031	400	1.431193	5.724772	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	93.6	3.4e-19	NR	QIG59935.1	2704072	g4953	i0	41.1	0.93	124	55	87	4	389	42	254	367	QIG59935.1 thrombospondin type-1 domain-containing protein 7A isoform X8 [Dishui Lake phycodnavirus 4]	diamond	372	93.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
28595719	28595719	PRJNA577580_P_NODE_13147_length_256_cov_1.644809_g13069_i0	PRJNA577580	13147	256	1.644809	4.21071104	Barrevirus sp.	2487763	Viruses	Viruses	52	1.54e-5	NR	AYV77273.1	2487763	g13069	i0	32.5	0.97265625	83	54	97.3	1	254	6	94	174	AYV77273.1 MAG: START domain containing protein [Barrevirus sp.]	diamond	249	52	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29858449	29858449	PRJNA577580_P_NODE_3791_length_462_cov_3.437018_g3713_i0	PRJNA577580	3791	462	3.437018	15.87902316	Marseillevirus LCMAC1	2506602	Viruses	Viruses	49.7	2.23e-4	NR	QBK85646.1	2506602	g3713	i0	37.8	0.480519480519481	74	44	46.8	1	52	267	34	107	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	222	49.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
30837945	30837945	PRJNA577580_P_NODE_5634_length_377_cov_2.335526_g5556_i0	PRJNA577580	5634	377	2.335526	8.80493302	Marseillevirus LCMAC1	2506602	Viruses	Viruses	50.4	5.71e-5	NR	QBK85646.1	2506602	g5556	i0	32.4	0.541114058355438	68	46	54.1	0	359	156	33	100	QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101]	diamond	204	50.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
31817983	31817983	PRJNA577580_P_NODE_14797_length_248_cov_0.891429_g14719_i0	PRJNA577580	14797	248	0.891429	2.21074392	Satyrvirus sp.	2487771	Viruses	Viruses	53.5	6.12e-6	NR	AYV85210.1	2487771	g14719	i0	37.5	1.95967741935484	80	47	94.4	2	8	241	30	108	AYV85210.1 MAG: serpin [Satyrvirus sp.]	diamond	486	53.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Satyrvirus 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);;