metadata: contig_metadata: 5 rows where bioproject = "PRJNA734348" and tax

5 rows where bioproject = "PRJNA734348" 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
3748499	3748499	PRJNA734348_P_NODE_103003_length_248_cov_1.560000_g102305_i0	PRJNA734348	103003	248	1.56	3.8688	root	1	Root_unresolved	Root_unresolved	444	3.17e-120	NTclustered	gi\|2288721861\|gb\|OP218818.1\|	10535	g102305	i0	98.805	101.959677419355	251	0	100	1	1	248	2072	2322	Unidentified adenovirus strain CHOP Ad5	blastn	25286	444	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	unidentified adenovirus
13950924	13950924	PRJNA734348_P_NODE_148451_length_204_cov_11.122137_g147753_i0	PRJNA734348	148451	204	11.122137	22.68915948	root	1	Root_unresolved	Root_unresolved	267	5.839999999999999e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g147753	i0	100	70.5882352941177	144	0	71	0	56	199	11236	11379	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14400	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
17295056	17295056	PRJNA734348_P_NODE_115934_length_245_cov_0.895349_g115236_i0	PRJNA734348	115934	245	0.895349	2.19360505	Kratosvirus quantuckense	3060070	Viruses	Viruses	67.6	7.9e-7	NTclustered	gi\|672550958\|ref\|NC_024697.1\|	1474867	g115236	i0	93.333	1.75102040816327	45	3	18	0	125	169	26548	26592	Aureococcus anophagefferens virus isolate BtV-01, complete genome	blastn	429	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Kratosvirus	Kratosvirus quantuckense
22874456	22874456	PRJNA734348_P_NODE_148938_length_202_cov_15.945736_g148240_i0	PRJNA734348	148938	202	15.945736	32.21038672	root	1	Root_unresolved	Root_unresolved	267	5.77e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g148240	i0	99.324	73.2673267326733	148	0	73	1	1	147	11550	11403	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14800	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
28473689	28473689	PRJNA734348_P_NODE_132606_length_241_cov_0.916667_g131908_i0	PRJNA734348	132606	241	0.916667	2.20916747	Gaeavirus sp.	2487767	Viruses	Viruses	85.5	3.18e-17	NR	AYV79921.1	2487767	g131908	i0	55.4	0.921161825726141	74	32	92.1	1	12	233	1114	1186	AYV79921.1 MAG: putative site-specific DNA-methyltransferase [Gaeavirus sp.]	diamond	222	85.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.

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