metadata: contig_metadata: 6 rows where bioproject = "PRJNA564013", tax_phylum = "Preplasmiviricota" and tax

6 rows where bioproject = "PRJNA564013", tax_phylum = "Preplasmiviricota" 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_species
12026992	12026992	PRJNA564013_P_NODE_159470_length_343_cov_4.319149_g156620_i0	PRJNA564013	159470	343	4.319149	14.81468107	Adintovirus androctonus13035	3115887	Viruses	Viruses	427	4.609999999999999e-115	NTclustered	gi\|2710390252\|tpg\|BK066392.1\|	3115887	g156620	i0	94.286	0.816326530612245	280	15	82	1	1	280	6995	7273	MAG TPA_asm: Adintovirus androctonus13035 isolate Adinto13035 genomic sequence	blastn	280	427	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus androctonus13035
27110646	27110646	PRJNA564013_P_NODE_101382_length_407_cov_137.609827_g98548_i0	PRJNA564013	101382	407	137.609827	560.07199589	Lake Baikal virophage 5	3086128	Viruses	Viruses	57	6.3e-7	NR	WPF46558.1	3086128	g98548	i0	43.1	0.479115479115479	65	33	47.9	2	130	324	8	68	WPF46558.1 MAG: hypothetical protein [Lake Baikal virophage 5]	diamond	195	57	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae	Lake Baikal virophage 5
27364028	27364028	PRJNA564013_P_NODE_245303_length_265_cov_4.750000_g242451_i0	PRJNA564013	245303	265	4.75	12.5875	Lake Baikal virophage 9	3086132	Viruses	Viruses	57	4.58e-7	NR	WPF46692.1	3086132	g242451	i0	41.1	0.826415094339623	73	40	82.6	1	263	45	100	169	WPF46692.1 MAG: hypothetical protein [Lake Baikal virophage 9]	diamond	219	57	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae	Lake Baikal virophage 9
27552946	27552946	PRJNA564013_P_NODE_169884_length_334_cov_2.271062_g167034_i0	PRJNA564013	169884	334	2.271062	7.58534708	Lake Baikal virophage 9	3086132	Viruses	Viruses	73.6	6.75e-13	NR	WPF46688.1	3086132	g167034	i0	41	0.898203592814371	100	54	85.3	1	35	319	139	238	WPF46688.1 MAG: hypothetical protein [Lake Baikal virophage 9]	diamond	300	73.6	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae	Lake Baikal virophage 9
27868771	27868771	PRJNA564013_P_NODE_251125_length_260_cov_5.638191_g248273_i0	PRJNA564013	251125	260	5.638191	14.6592966	Lake Baikal virophage 9	3086132	Viruses	Viruses	84.3	1.07e-16	NR	WPF46692.1	3086132	g248273	i0	42.4	0.980769230769231	85	49	98.1	0	257	3	12	96	WPF46692.1 MAG: hypothetical protein [Lake Baikal virophage 9]	diamond	255	84.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae	Lake Baikal virophage 9
28215981	28215981	PRJNA564013_P_NODE_193166_length_312_cov_14.274900_g190315_i0	PRJNA564013	193166	312	14.2749	44.537688	Adenovirus acanthiza15342	3115873	Viruses	Viruses	55.8	2.3e-7	NR	DBA47579.1	3115873	g190315	i0	39.2	0.759615384615385	79	48	76	0	25	261	39	117	DBA47579.1 MAG TPA_asm: Oncoid2 [Adenovirus acanthiza15342]	diamond	237	55.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Adenovirus acanthiza15342

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