metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax_kingdom = "Orthornavirae"

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_species
367170	367170	PRJNA222400_P_NODE_1_length_9208_cov_13.034829_g0_i0	PRJNA222400	1	9208	13.034829	1200.24705432	Hangzhou marna-like virus 1	3029006	Viruses	Viruses	3395	0	NR	WEU70895.1	3029006	g0	i0	62.8	0.891724587315378	2737	957	88.9	17	836	9022	12	2694	WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1]	diamond	8211	3395	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Hangzhou marna-like virus 1
16944497	16944497	PRJNA222400_P_NODE_5454_length_192_cov_1.090909_g5421_i0	PRJNA222400	5454	192	1.090909	2.09454528	Perth bee virus 4	2201298	Viruses	Viruses	117	6.53e-29	NR	AWK77899.1	2201298	g5421	i0	93.8	1	64	4	100	0	192	1	91	154	AWK77899.1 structural polyprotein [Perth bee virus 4]	diamond	192	117	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
27453394	27453394	PRJNA222400_P_NODE_183_length_1095_cov_2.627151_g168_i0	PRJNA222400	183	1095	2.627151	28.76730345	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	84	2.33e-13	NR	XCM67955.1	3003959	g168	i0	29.9	0.76986301369863	281	155	71.8	13	8	793	2165	2422	XCM67955.1 MAG: polyprotein [Picornavirales sp.]	diamond	843	84	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
29694639	29694639	PRJNA222400_P_NODE_7130_length_169_cov_1.283333_g7097_i0	PRJNA222400	7130	169	1.283333	2.16883277	Perth bee virus 4	2201298	Viruses	Viruses	90.5	1.98e-19	NR	AWK77898.1	2201298	g7097	i0	72.7	0.976331360946746	55	15	97.6	0	167	3	969	1023	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	165	90.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
30358832	30358832	PRJNA222400_P_NODE_1532_length_414_cov_1.361644_g1499_i0	PRJNA222400	1532	414	1.361644	5.63720616	Perth bee virus 4	2201298	Viruses	Viruses	97.8	1.44e-20	NR	AWK77898.1	2201298	g1499	i0	34.8	0.978260869565217	135	87	97.1	1	413	12	514	648	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	405	97.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
30358834	30358834	PRJNA222400_P_NODE_2812_length_284_cov_1.548936_g2779_i0	PRJNA222400	2812	284	1.548936	4.39897824	Perth bee virus 4	2201298	Viruses	Viruses	171	6.38e-47	NR	AWK77898.1	2201298	g2779	i0	79.8	0.992957746478873	94	19	99.3	0	283	2	1208	1301	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	282	171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
31242973	31242973	PRJNA222400_P_NODE_3435_length_247_cov_1.313131_g3402_i0	PRJNA222400	3435	247	1.313131	3.24343357	Perth bee virus 4	2201298	Viruses	Viruses	148	4.49e-40	NR	AWK77899.1	2201298	g3402	i0	91.4	0.983805668016194	81	7	98.4	0	245	3	389	469	AWK77899.1 structural polyprotein [Perth bee virus 4]	diamond	243	148	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
31274644	31274644	PRJNA222400_P_NODE_1815_length_377_cov_1.722561_g1782_i0	PRJNA222400	1815	377	1.722561	6.49405497	Picornaviridae sp.	1530251	Viruses	Viruses	64.7	3.49e-9	NR	URG14784.1	1530251	g1782	i0	34.4	0.994694960212202	125	75	93.9	3	5	358	649	773	URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	375	64.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
31622532	31622532	PRJNA222400_P_NODE_1756_length_385_cov_1.098214_g1723_i0	PRJNA222400	1756	385	1.098214	4.2281239	Picornaviridae sp.	1530251	Viruses	Viruses	122	2.34e-29	NR	URG14992.1	1530251	g1723	i0	50.8	0.997402597402597	128	61	98.2	1	1	378	124	251	URG14992.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	384	122	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
32065434	32065434	PRJNA222400_P_NODE_5738_length_187_cov_1.507246_g5705_i0	PRJNA222400	5738	187	1.507246	2.81855002	Perth bee virus 4	2201298	Viruses	Viruses	123	8.739999999999999e-31	NR	AWK77898.1	2201298	g5705	i0	88.7	0.994652406417112	62	7	99.5	0	186	1	1104	1165	AWK77898.1 nonstructural polyprotein, partial [Perth bee virus 4]	diamond	186	123	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4
32540336	32540336	PRJNA222400_P_NODE_5839_length_186_cov_1.138686_g5806_i0	PRJNA222400	5839	186	1.138686	2.11795596	Perth bee virus 4	2201298	Viruses	Viruses	130	1.33e-33	NR	AWK77899.1	2201298	g5806	i0	98.4	0.983870967741935	61	1	98.4	0	2	184	160	220	AWK77899.1 structural polyprotein [Perth bee virus 4]	diamond	183	130	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Perth bee virus 4

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