metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
1181898	1181898	PRJNA695273_P_NODE_119941_length_257_cov_1.255435_g119183_i0	PRJNA695273	119941	257	1.255435	3.22646795	Deltaentomopoxvirus	2733302	Viruses	Viruses	370	5.68e-98	NTclustered	gi\|9631294\|ref\|NC_001993.1\|	83191	g119183	i0	92.607	2	257	19	100	0	1	257	53891	53635	Melanoplus sanguinipes entomopoxvirus, complete genome	blastn	514	370	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Deltaentomopoxvirus	Deltaentomopoxvirus msanguinipes
2457183	2457183	PRJNA695273_P_NODE_127662_length_251_cov_0.865169_g126904_i0	PRJNA695273	127662	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	464	2.47e-126	NTclustered	gi\|2079660852\|emb\|OU501478.1\|	10515	g126904	i0	100	100	251	0	100	0	1	251	5153	5403	Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE	blastn	25100	464	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
10880883	10880883	PRJNA695273_P_NODE_129369_length_250_cov_0.870056_g128611_i0	PRJNA695273	129369	250	0.870056	2.17514	Anacridium aegyptium entomopoxvirus	124304	Viruses	Viruses	374	4.2499999999999986e-99	NTclustered	gi\|7804886\|gb\|AF242294.1\|AF242294	124304	g128611	i0	93.6	4.888	250	16	100	0	1	250	2929	2680	Anacridium aegyptium entomopoxvirus spheroidin gene, complete cds; and unknown gene	blastn	1222	374	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Anacridium aegyptium entomopoxvirus
14708395	14708395	PRJNA695273_P_NODE_98072_length_282_cov_1.220096_g97314_i0	PRJNA695273	98072	282	1.220096	3.44067072	Terrestrivirus sp.	2487775	Viruses	Viruses	52.8	0.026	NTclustered	gi\|1512471161\|gb\|MK071982.1\|	2487775	g97314	i0	90.244	0.145390070921986	41	2	14	2	226	265	111451	111490	MAG: Terrestrivirus sp. clone Terrestrivirus_4 genomic sequence	blastn	41	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
25410168	25410168	PRJNA695273_P_NODE_98980_length_281_cov_1.173077_g98222_i0	PRJNA695273	98980	281	1.173077	3.29634637	Deltaentomopoxvirus	2733302	Viruses	Viruses	178	4.1e-40	NTclustered	gi\|9631294\|ref\|NC_001993.1\|	83191	g98222	i0	79.693	1.8576512455516	261	41	91	11	27	281	205061	204807	Melanoplus sanguinipes entomopoxvirus, complete genome	blastn	522	178	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Deltaentomopoxvirus	Deltaentomopoxvirus msanguinipes

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