metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1253303" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1253303" 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
18211119	18211119	PRJNA1253303_P_NODE_2355_length_341_cov_0.873134_g2333_i0	PRJNA1253303	2355	341	0.873134	2.97738694	Murine astrovirus 2	2171380	Viruses	Viruses	217	8.46e-64	NR	QFP20151.1	2171380	g2333	i0	86.7	0.994134897360704	113	15	99.4	0	3	341	492	604	QFP20151.1 capsid protein [Murine astrovirus 2]	diamond	339	217	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Murine astrovirus 2
27231809	27231809	PRJNA1253303_P_NODE_7943_length_244_cov_0.912281_g7921_i0	PRJNA1253303	7943	244	0.912281	2.22596564	Caudoviricetes sp.	2832643	Viruses	Viruses	138	2.17e-36	NR	DAL27657.1	2832643	g7921	i0	85.7	0.94672131147541	77	11	94.7	0	9	239	189	265	DAL27657.1 MAG TPA_asm: carboxylesterase family protein [Caudoviricetes sp.]	diamond	231	138	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28052863	28052863	PRJNA1253303_P_NODE_6645_length_248_cov_0.891429_g6623_i0	PRJNA1253303	6645	248	0.891429	2.21074392	Carya illinoinensis carlavirus 1	2794420	Viruses	Viruses	124	5.959999999999999e-31	NR	QQG34672.1	2794420	g6623	i0	74.4	0.991935483870968	82	21	99.2	0	246	1	893	974	QQG34672.1 RdRp [Carya illinoinensis carlavirus 1]	diamond	246	124	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carya illinoinensis carlavirus 1
30421728	30421728	PRJNA1253303_P_NODE_6833_length_247_cov_0.896552_g6811_i0	PRJNA1253303	6833	247	0.896552	2.21448344	Prochlorococcus phage P-SSM7	445688	Viruses	Viruses	64.7	1.55e-11	NR	YP_004324882.1	445688	g6811	i0	68.4	0.923076923076923	38	12	46.2	0	119	6	1	38	YP_004324882.1 hypothetical protein PSSM7_051 [Prochlorococcus phage P-SSM7]	diamond	228	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Palaemonvirus	Palaemonvirus pssm7
30642369	30642369	PRJNA1253303_P_NODE_2113_length_358_cov_1.164912_g2091_i0	PRJNA1253303	2113	358	1.164912	4.17038496	Chrysanthemum yellow edge associated virus 2	3025447	Viruses	Viruses	77	1.23e-13	NR	WCL16046.1	3025447	g2091	i0	46.5	0.720670391061452	86	45	71.2	1	1	255	351	436	WCL16046.1 inclusion body protein [Chrysanthemum yellow edge associated virus 2]	diamond	258	77	1	Viruses							Chrysanthemum yellow edge associated virus 2
31577187	31577187	PRJNA1253303_P_NODE_6996_length_247_cov_0.896552_g6974_i0	PRJNA1253303	6996	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	51.6	1.27e-5	NR	BAR18313.1	1407671	g6974	i0	43.1	2.61133603238866	72	36	87.4	1	6	221	39	105	BAR18313.1 hypothetical protein [uncultured Mediterranean phage uvMED]	diamond	645	52	0.992307692307692	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
31924946	31924946	PRJNA1253303_P_NODE_3797_length_283_cov_1.328571_g3775_i0	PRJNA1253303	3797	283	1.328571	3.75985593	Marchewkavirus	3425052	Viruses	Viruses	150	3.66e-44	NR	USN14802.1	2948598	g3775	i0	68.1	1.99293286219081	94	30	99.6	0	2	283	55	148	USN14802.1 hypothetical protein DOMOVOI_03280 [Brevundimonas phage vB_BpoS-Domovoi]	diamond	564	150	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Jeanschmidtviridae	Marchewkavirus	Marchewkavirus domovoi
31938599	31938599	PRJNA1253303_P_NODE_6517_length_248_cov_0.891429_g6495_i0	PRJNA1253303	6517	248	0.891429	2.21074392	uncultured marine virus	186617	Viruses	Viruses	107	8.2e-28	NR	BCV08434.1	186617	g6495	i0	87	0.653225806451613	54	6	65.3	1	3	164	66	118	BCV08434.1 MAG: hypothetical protein CM15mL5_2090 [uncultured marine virus]	diamond	162	107	1	Viruses							uncultured marine virus
32665913	32665913	PRJNA1253303_P_NODE_6720_length_247_cov_1.574713_g6698_i0	PRJNA1253303	6720	247	1.574713	3.88954111	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	65.5	4e-10	NR	XCM67999.1	3003959	g6698	i0	45.3	0.910931174089069	75	37	91.1	1	246	22	2364	2434	XCM67999.1 MAG: polyprotein [Picornavirales sp.]	diamond	225	65.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3

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