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

5 rows where bioproject = "PRJNA832865" 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
823172	823172	PRJNA832865_S_NODE_42481_length_401_cov_2.314024_g37395_i0	PRJNA832865	42481	401	2.314024	9.27923624	Rheavirus sinusmexicani	3047716	Viruses	Viruses	58.4	8.26e-4	NTclustered	gi\|310830989\|ref\|NC_014637.1\|	693272	g37395	i0	88	0.124688279301746	50	5	12	1	285	334	113263	113215	Cafeteria roenbergensis virus BV-PW1, complete genome	blastn	50	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Rheavirus	Rheavirus sinusmexicani
9750752	9750752	PRJNA832865_S_NODE_24988_length_633_cov_1.641071_g20034_i0	PRJNA832865	24988	633	1.641071	10.38797943	Cotonvirus japonicum	3059904	Viruses	Viruses	56.5	0.005	NTclustered	gi\|2500766720\|ref\|NC_079139.1\|	2811091	g20034	i0	100	0.0473933649289099	30	0	5	0	551	580	1303349	1303378	Cotonvirus japonicus DNA, complete genome	blastn	30	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
29612081	29612081	PRJNA832865_S_NODE_108490_length_242_cov_1.266272_g103404_i0	PRJNA832865	108490	242	1.266272	3.06437824	Adintovirus anguilla10665	3115889	Viruses	Viruses	53.1	1.52e-6	NR	DBA48430.1	3115889	g103404	i0	44.1	0.84297520661157	68	37	84.3	1	6	209	65	131	DBA48430.1 MAG TPA_asm: Adenain [Adintovirus abramis16382]	diamond	204	53.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguilla10665
29865029	29865029	PRJNA832865_S_NODE_81411_length_272_cov_1.160804_g76325_i0	PRJNA832865	81411	272	1.160804	3.15738688	Drosophila-associated adintovirus 1	2744816	Viruses	Viruses	62.8	4.73e-9	NR	QKS69560.1	2744816	g76325	i0	49.2	0.672794117647059	61	31	67.3	0	271	89	260	320	QKS69560.1 PolB [Drosophila-associated adintovirus 1]	diamond	183	62.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Drosophila-associated adintovirus 1
31255239	31255239	PRJNA832865_S_NODE_49155_length_363_cov_1.100000_g44069_i0	PRJNA832865	49155	363	1.1	3.993	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	159	7.92e-44	NR	YP_010803522.1	3060017	g44069	i0	63.9	0.983471074380165	119	42	97.5	1	362	9	356	474	YP_010803522.1 flotillin domain-containing protein [Fadolivirus algeromassiliense]	diamond	357	159	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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