metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_phylum = "Nucleocytoviricota" and tax

5 rows where bioproject = "PRJNA1160211", tax_phylum = "Nucleocytoviricota" and tax_superkingdom = "Viruses"

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
10513158	10513158	PRJNA1160211_S_NODE_161489_length_358_cov_70.164912_g160256_i0	PRJNA1160211	161489	358	70.164912	251.19038496	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.034	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g160256	i0	94.286	0.0977653631284916	35	1	9	1	108	141	153475	153509	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
28335299	28335299	PRJNA1160211_S_NODE_9306_length_829_cov_4.419312_g8558_i0	PRJNA1160211	9306	829	4.419312	36.63609648	Tupanvirus deep ocean	2126984	Viruses	Viruses	238	8.609999999999997e-74	NR	YP_010781083.1	2126984	g8558	i0	48.5	1.93244873341375	264	122	94.8	5	827	42	72	323	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	1602	238	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
29030181	29030181	PRJNA1160211_S_NODE_231628_length_278_cov_2.224390_g230395_i0	PRJNA1160211	231628	278	2.22439	6.1838042	Tupanvirus deep ocean	2126984	Viruses	Viruses	99.8	8.63e-23	NR	YP_010781083.1	2126984	g230395	i0	53.9	1.93165467625899	89	40	96	1	271	5	221	308	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	537	99.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
30009030	30009030	PRJNA1160211_S_NODE_283751_length_240_cov_8.976048_g282518_i0	PRJNA1160211	283751	240	8.976048	21.5425152	Medusavirus sp. 'euryale'	3349365	Viruses	Viruses	68.2	3.54e-13	NR	BFT93466.1	3349365	g282518	i0	61.4	0.7125	57	21	70	1	53	220	4	60	BFT93466.1 hypothetical protein F10_00311 [Medusavirus sp. 'euryale']	diamond	171	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes		Mamonoviridae	Medusavirus	Medusavirus sp. 'euryale'
30419924	30419924	PRJNA1160211_S_NODE_43313_length_598_cov_2.815238_g42161_i0	PRJNA1160211	43313	598	2.815238	16.83512324	Tupanvirus soda lake	2126985	Viruses	Viruses	119	1.51e-29	NR	YP_010782214.1	2126985	g42161	i0	44.2	0.77257525083612	154	71	76.8	5	572	114	57	196	YP_010782214.1 exonuclease [Tupanvirus soda lake]	diamond	462	119	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum

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