metadata: contig_metadata: 4 rows where bioproject = "PRJNA1253303", tax_phylum = "Pisuviricota" and tax

4 rows where bioproject = "PRJNA1253303", tax_phylum = "Pisuviricota" 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
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
18211119	18211119	PRJNA1253303_P_NODE_2355_length_341_cov_0.873134_g2333_i0	PRJNA1253303	2355	341	0.873134	2.97738694	Murine astrovirus 2	2171380	Viruses	Viruses	217	8.46e-64	NR	QFP20151.1	2171380	g2333	i0	86.7	0.994134897360704	113	15	99.4	0	3	341	492	604	QFP20151.1 capsid protein [Murine astrovirus 2]	diamond	339	217	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Murine astrovirus 2
32665913	32665913	PRJNA1253303_P_NODE_6720_length_247_cov_1.574713_g6698_i0	PRJNA1253303	6720	247	1.574713	3.88954111	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	65.5	4e-10	NR	XCM67999.1	3003959	g6698	i0	45.3	0.910931174089069	75	37	91.1	1	246	22	2364	2434	XCM67999.1 MAG: polyprotein [Picornavirales sp.]	diamond	225	65.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3

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