metadata: contig_metadata: 2 rows where analysis = "blastn", bioproject = "PRJNA1253303" and tax

2 rows where analysis = "blastn", bioproject = "PRJNA1253303" and tax_phylum = "Pisuviricota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7430475	7430475	PRJNA1253303_P_NODE_486_length_676_cov_1.318408_g464_i0	PRJNA1253303	486	676	1.318408	8.91243808	Betacoronavirus	694002	Viruses	Viruses	1099	0		NTclustered	gi\|331813\|gb\|M35253.1\|MHV1NP	11138	g464	i0	96.006	93.8905325443787	676	27	100	0	1	676	699	1374	Murine hepatitis virus hepatitis virus nucleocapsid (N-MHV1) ORF 1 and hepatitis virus nucleocapsid (N-MHV1) ORF 2 genes, complete cds	blastn	63470	1099	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus muris
13113297	13113297	PRJNA1253303_P_NODE_3811_length_283_cov_1.114286_g3789_i0	PRJNA1253303	3811	283	1.114286	3.15342938	Murine astrovirus 2	2171380	Viruses	Viruses	401	2.2499999999999992e-107		NTclustered	gi\|1761122528\|gb\|MN503237.1\|	2171380	g3789	i0	92.226	37.4558303886926	283	22	100	0	1	283	3479	3197	Murine astrovirus 2 isolate WCM2/NY/USA/2018 nonstructural protein (OFR1ab) and ORF1a (ORF1a) genes, complete cds; and capsid protein (OFR2) gene, partial cds	blastn	10600	401	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Murine astrovirus 2

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