metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA484127" 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
27044686	27044686	PRJNA484127_P_NODE_21642_length_286_cov_1.403756_g21493_i0	PRJNA484127	21642	286	1.403756	4.01474216	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	84	2.14e-16	NR	XBS25272.1	RQ08	g21493	i0	46.3	0.996503496503496	95	50	99.7	1	286	2	1827	1920	XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1]	diamond	285	84	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
27834316	27834316	PRJNA484127_P_NODE_38884_length_242_cov_0.923077_g38735_i0	PRJNA484127	38884	242	0.923077	2.23384634	Caudoviricetes sp.	2832643	Viruses	Viruses	61.2	2.06e-10	NR	QHJ79471.1	2832643	g38735	i0	52.5	0.756198347107438	61	29	75.6	0	27	209	1	61	QHJ79471.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	183	61.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28781432	28781432	PRJNA484127_P_NODE_7_length_5013_cov_9.529960_g6_i0	PRJNA484127	7	5013	9.52996	477.7368948	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	1168	0	NR	XBS25272.1	RQ08	g6	i0	41.6	0.935368043087971	1563	830	89.9	27	5004	496	664	2203	XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1]	diamond	4689	1168	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
29334478	29334478	PRJNA484127_P_NODE_37969_length_243_cov_0.917647_g37820_i0	PRJNA484127	37969	243	0.917647	2.22988221	Ripduovirus	2560215	Viruses	Viruses	92.4	1.2e-19	NR	YP_009598718.1	1923889	g37820	i0	50.6	1.96296296296296	81	39	100	1	1	243	171	250	YP_009598718.1 virion structural protein [Ralstonia phage RP12]	diamond	477	92.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Ripduovirus	Ripduovirus RP12
30076181	30076181	PRJNA484127_P_NODE_39772_length_234_cov_4.279503_g39623_i0	PRJNA484127	39772	234	4.279503	10.01403702	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	42.4	0.0465	NR	AVM87224.1	RQ08	g39623	i0	37.8	0.948717948717949	74	39	89.7	4	211	2	34	104	AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus]	diamond	222	42.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
30202458	30202458	PRJNA484127_P_NODE_412_length_1418_cov_5.441636_g357_i0	PRJNA484127	412	1418	5.441636	77.16239848	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	340	6.36e-100	NR	XBS25272.1	RQ08	g357	i0	43.3	0.98589562764457	466	245	96.9	11	1376	3	199	653	XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1]	diamond	1398	340	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
31245318	31245318	PRJNA484127_P_NODE_24235_length_274_cov_1.164179_g24086_i0	PRJNA484127	24235	274	1.164179	3.18985046	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	82.8	4.64e-16	NR	AVM87212.1	RQ08	g24086	i0	52.3	0.941605839416058	86	39	94.2	2	261	4	688	771	AVM87212.1 polyprotein [Dongbei arctic lamprey calicivirus 2]	diamond	258	82.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
31593492	31593492	PRJNA484127_P_NODE_33916_length_248_cov_0.891429_g33767_i0	PRJNA484127	33916	248	0.891429	2.21074392	Wenzhou rodent rhabdovirus 1	3084690	Viruses	Viruses	45.4	0.0039	NR	WPV62747.1	3084690	g33767	i0	36.3	0.967741935483871	80	50	96.8	1	5	244	177	255	WPV62747.1 MAG: phosphoprotein [Wenzhou rodent rhabdovirus 1]	diamond	240	45.4	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Wenzhou rodent rhabdovirus 1
31640911	31640911	PRJNA484127_P_NODE_11476_length_363_cov_1.327586_g11327_i0	PRJNA484127	11476	363	1.327586	4.81913718	Viruses	10239	Viruses	Viruses	80.5	9.15e-15	NR	AVM87224.1	2116168	g11327	i0	35.8	3	120	76	98.3	1	3	359	332	451	AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus]	diamond	1089	80.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Fujian spotted paddle-tail newt calicivirus
32857387	32857387	PRJNA484127_P_NODE_37780_length_243_cov_0.917647_g37631_i0	PRJNA484127	37780	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	2.33e-6	NR	DAK55183.1	2832643	g37631	i0	47.6	0.777777777777778	63	32	77.8	1	241	53	824	885	DAK55183.1 MAG TPA: crystallin beta/gamma motif-containing protein [Caudoviricetes sp.]	diamond	189	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;