metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB6584" 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
32911952	32911952	PRJEB6584h_S_NODE_57185_length_162_cov_1.685039_g57123_i0	PRJEB6584	57185	162	1.685039	2.72976318	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	94	1.1e-20	NR	WWZ85593.1	3132542	g57123	i0	84.9	0.981481481481482	53	8	98.1	0	3	161	739	791	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	159	94	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
32957499	32957499	PRJEB6584o_S_NODE_53234_length_165_cov_3.053846_g53126_i0	PRJEB6584	53234	165	3.053846	5.0388459	Viruses	10239	Viruses	Viruses	43.9	0.0053	NR	AWK77852.1	2201285	g53126	i0	40.4	1.61818181818182	47	28	85.5	0	159	19	259	305	AWK77852.1 nonstructural polyprotein, partial [Bundaberg bee virus 2]	diamond	267	44.3	0.99097065462754	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Bundaberg bee virus 2
32997451	32997451	PRJEB6584h_S_NODE_2315_length_315_cov_4.560714_g2253_i0	PRJEB6584	2315	315	4.560714	14.3662491	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	110	1.47e-25	NR	WWZ85593.1	3132542	g2253	i0	65	0.761904761904762	80	28	76.2	0	314	75	1800	1879	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	240	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like virus 4
33133995	33133995	PRJEB6584f_S_NODE_2975_length_187_cov_3.914474_g2969_i0	PRJEB6584	2975	187	3.914474	7.32006638	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	47	5.83e-4	NR	WKU61618.1	3063761	g2969	i0	91.3	0.368983957219251	23	2	36.9	0	184	116	2198	2220	WKU61618.1 polyprotein [Zebrafish picornavirus 2]	diamond	69	47	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Danio blood picornavirus/Zebrafish picornavirus 2
33134016	33134016	PRJEB6584h_S_NODE_615_length_447_cov_22.189320_g555_i0	PRJEB6584	615	447	22.18932	99.1862604	Macrobrachium rosenbergii picorna-like virus 4	3132542	Viruses	Viruses	119	4.7000000000000005e-28	NR	WWZ85593.1	3132542	g555	i0	44.6	0.932885906040268	139	75	91.9	2	445	35	145	283	WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4]	diamond	417	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Macrobrachium rosenbergii picorna-like 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);;