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

5 rows where analysis = "diamond", bioproject = "PRJNA770361" 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
27116233	27116233	PRJNA770361_P_NODE_16882_length_246_cov_0.901734_g16787_i0	PRJNA770361	16882	246	0.901734	2.21826564	uncultured Caudovirales phage	2100421	Viruses	Viruses	67	3.64e-12	NR	CAB4154815.1	2100421	g16787	i0	46.4	0.841463414634146	69	36	82.9	1	205	2	1	69	CAB4154815.1 COG1525 Micrococcal nuclease (thermonuclease) homologs [uncultured Caudovirales phage]	diamond	207	67	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
29390210	29390210	PRJNA770361_P_NODE_3789_length_484_cov_1.897810_g3694_i0	PRJNA770361	3789	484	1.89781	9.1854004	Colletotrichum camelliae hypovirus 1	3071075	Viruses	Viruses	84.3	1.67e-15	NR	WMI30737.1	3071075	g3694	i0	62.7	0.365702479338843	59	22	36.6	0	482	306	2824	2882	WMI30737.1 RNA-dependent RNA polymerase [Colletotrichum camelliae hypovirus 1]	diamond	177	84.3	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Colletotrichum camelliae hypovirus 1
29768849	29768849	PRJNA770361_P_NODE_17051_length_246_cov_0.901734_g16956_i0	PRJNA770361	17051	246	0.901734	2.21826564	Kaumoebavirus	1859492	Viruses	Viruses	107	4.24e-25	NR	QQV29307.1	1859492	g16956	i0	67.5	5.85365853658537	80	25	97.6	1	242	3	144	222	QQV29307.1 hypothetical protein K-LCC10_0052 [Kaumoebavirus]	diamond	1440	107	1	Viruses							Kaumoebavirus
30716627	30716627	PRJNA770361_P_NODE_17654_length_245_cov_0.906977_g17559_i0	PRJNA770361	17654	245	0.906977	2.22209365	Durnavirales sp.	2809355	Viruses	Viruses	52	2.05e-5	NR	WRQ64726.1	2809355	g17559	i0	34.2	0.96734693877551	79	50	96.7	1	245	9	169	245	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	237	52	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
32802885	32802885	PRJNA770361_P_NODE_580_length_1178_cov_1.550226_g531_i0	PRJNA770361	580	1178	1.550226	18.26166228	Narnavirus sp.	2587225	Viruses	Viruses	65.1	1.47e-8	NR	CAK8705411.1	2587225	g531	i0	34.4	1.16638370118846	128	73	32.1	3	1085	708	4	122	CAK8705411.1 uncharacterized [Narnavirus sp.]	diamond	1374	65.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus 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);;