metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA998413" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA998413" 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
4807166	4807166	PRJNA998413_S_NODE_7444_length_244_cov_1.060773_g7413_i0	PRJNA998413	7444	244	1.060773	2.58828612	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.006	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g7413	i0	100	0.577868852459016	29	0	12	0	1	29	13	41	Carnation latent virus isolate KL, complete genome	blastn	141	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
7356772	7356772	PRJNA998413_S_NODE_11626_length_214_cov_1.688742_g11595_i0	PRJNA998413	11626	214	1.688742	3.61390788	Emesvirus zinderi	329852	Viruses	Viruses	396	7.559999999999996e-106	NTclustered	gi\|329402167\|gb\|HQ332490.1\|	12022	g11595	i0	100	99.5514018691589	214	0	100	0	1	214	3230	3443	Enterobacteria phage MS2 isolate 862B assembly protein (mat), coat protein (cp), lysis protein (lys), and replicase protein (rep) genes, complete cds	blastn	21304	396	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Emesvirus	Emesvirus zinderi
8632223	8632223	PRJNA998413_S_NODE_2527_length_336_cov_1.062271_g2496_i0	PRJNA998413	2527	336	1.062271	3.56923056	Emesvirus zinderi	329852	Viruses	Viruses	599	9.029999999999998e-167	NTclustered	gi\|225421599\|gb\|FJ799517.1\|	12022	g2496	i0	99.099	94.4047619047619	333	3	99	0	4	336	2274	2606	Enterobacterio phage MS2 clone L1.G40.6 assembly protein (MS2g1), coat protein (MS2g2), lysis protein (MS2g3), and replicase protein (MS2g4) genes, complete cds	blastn	31720	599	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Emesvirus	Emesvirus zinderi
8632280	8632280	PRJNA998413_S_NODE_6027_length_259_cov_2.602041_g5996_i0	PRJNA998413	6027	259	2.602041	6.73928619	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	473	4.25e-129	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g5996	i0	99.614	8.86486486486486	259	1	100	0	1	259	1995	2253	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	2296	473	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
11182430	11182430	PRJNA998413_S_NODE_13029_length_210_cov_0.911565_g12998_i0	PRJNA998413	13029	210	0.911565	1.9142865	Biavirus raunefjordenense	3059777	Viruses	Viruses	60.2	1.1e-4	NTclustered	gi\|2500387999\|ref\|NC_077221.1\|	1499987	g12998	i0	100	0.152380952380952	32	0	15	0	78	109	480766	480735	Prymnesium kappa virus genome assembly, chromosome: 1	blastn	32	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Biavirus	Biavirus raunefjordenense
21381305	21381305	PRJNA998413_S_NODE_2237_length_347_cov_46.908451_g2206_i0	PRJNA998413	2237	347	46.908451	162.77232497	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.033	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g2206	i0	94.286	0.100864553314121	35	1	10	1	105	138	153475	153509	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
21676369	21676369	PRJNA998413_S_NODE_4957_length_275_cov_1.570755_g4926_i0	PRJNA998413	4957	275	1.570755	4.31957625	Copiparvovirus	1511888	Viruses	Viruses	464	2.7399999999999998e-126	NTclustered	gi\|1725344901\|ref\|NC_031959.2\|	1917013	g4926	i0	99.222	4.21454545454545	257	2	93	0	1	257	5307	5051	Bosavirus MS-2016a, complete genome	blastn	1159	464	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Copiparvovirus	Copiparvovirus ungulate5

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