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

5 rows where bioproject = "PRJNA909412" 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
27277427	27277427	PRJNA909412_P_NODE_3223_length_293_cov_2.515748_g3082_i0	PRJNA909412	3223	293	2.515748	7.37114164	Terrestrivirus sp.	2487775	Viruses	Viruses	53.5	5.45e-6	NR	AYV76183.1	2487775	g3082	i0	47.9	0.491467576791809	48	25	49.1	0	281	138	157	204	AYV76183.1 MAG: hypothetical protein Terrestrivirus5_5 [Terrestrivirus sp.]	diamond	144	53.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
28800171	28800171	PRJNA909412_P_NODE_1487_length_452_cov_3.285714_g1347_i0	PRJNA909412	1487	452	3.285714	14.85142728	Mimiviridae	549779	Viruses	Viruses	67	4.28e-10	NR	YP_010782374.1	2126985	g1347	i0	27.8	1.65929203539823	126	84	80.3	2	86	448	55	178	YP_010782374.1 hypothetical protein QJ857_gp0333 [Tupanvirus soda lake]	diamond	750	67.4	0.99406528189911	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
29898196	29898196	PRJNA909412_P_NODE_4671_length_241_cov_3.465347_g4530_i0	PRJNA909412	4671	241	3.465347	8.35148627	Edafosvirus sp.	2487765	Viruses	Viruses	49.3	1.31e-4	NR	AYV78538.1	2487765	g4530	i0	47.4	0.473029045643154	38	20	47.3	0	14	127	146	183	AYV78538.1 MAG: hypothetical protein Edafosvirus17_14 [Edafosvirus sp.]	diamond	114	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
32269213	32269213	PRJNA909412_P_NODE_18058_length_150_cov_1.495495_g17917_i0	PRJNA909412	18058	150	1.495495	2.2432425	Klosneuvirus KNV1	1977640	Viruses	Viruses	62.8	8.59e-10	NR	ARF12269.1	1977640	g17917	i0	62	1	50	18	98	1	2	148	274	323	ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1]	diamond	150	62.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32774143	32774143	PRJNA909412_P_NODE_8380_length_184_cov_1.503448_g8239_i0	PRJNA909412	8380	184	1.503448	2.76634432	Orchesella springtail adintovirus	2609862	Viruses	Viruses	95.5	1.35e-22	NR	DAC81369.1	2609862	g8239	i0	67.8	0.96195652173913	59	19	96.2	0	179	3	5	63	DAC81369.1 TPA_asm: FtsK [Orchesella springtail adintovirus]	diamond	177	95.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Orchesella springtail adintovirus

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