metadata: contig_metadata: 11 rows where bioproject = "PRJNA994052" and tax

11 rows where bioproject = "PRJNA994052" and tax_kingdom = "Sangervirae"

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
21378574	21378574	PRJNA994052_P_NODE_39257_length_260_cov_27.267380_g38011_i0	PRJNA994052	39257	260	27.26738	70.895188	Microviridae sp. ct	2202644	Viruses	Viruses	133	1.74e-34	NR	QGH72837.1	2656693	g38011	i0	75	6.46153846153846	80	20	92.3	0	20	259	393	472	QGH72837.1 MAG: major capsid protein [Microviridae sp. ct0DW36]	diamond	1680	133	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp. ct0DW36
22653345	22653345	PRJNA994052_P_NODE_25218_length_294_cov_28.895928_g23981_i0	PRJNA994052	25218	294	28.895928	84.95402832	Microvirus sp.	2202559	Viruses	Viruses	162	6.74e-45	NR	WNK12593.1	2202559	g23981	i0	80.6	0.948979591836735	93	18	94.9	0	279	1	368	460	WNK12593.1 MAG: major capsid protein [Microvirus sp.]	diamond	279	162	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
23928878	23928878	PRJNA994052_P_NODE_34179_length_271_cov_30.419192_g32935_i0	PRJNA994052	34179	271	30.419192	82.43601032	Microviridae sp.	2202644	Viruses	Viruses	363	1.01e-95	NTclustered	gi\|2906151359\|gb\|PQ646576.1\|	2202644	g32935	i0	97.196	1.57564575645756	214	6	79	0	14	227	2055	1842	MAG: Microviridae sp. isolate k127_3173000 genomic sequence	blastn	427	363	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
27026453	27026453	PRJNA994052_P_NODE_74022_length_207_cov_128.582090_g72766_i0	PRJNA994052	74022	207	128.58209	266.1649263	Microvirus sp.	2202559	Viruses	Viruses	68.2	7e-13	NR	QJB19012.1	2202559	g72766	i0	45.2	2.59420289855072	62	34	89.9	0	193	8	7	68	QJB19012.1 MAG: nonstructural protein [Microvirus sp.]	diamond	537	68.2	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus sp.
27184380	27184380	PRJNA994052_P_NODE_60962_length_224_cov_111.821192_g59706_i0	PRJNA994052	60962	224	111.821192	250.47947008	Microviridae sp.	2202644	Viruses	Viruses	118	1.2399999999999998e-31	NR	XOE97986.1	2202644	g59706	i0	87	0.924107142857143	69	9	92.4	0	223	17	49	117	XOE97986.1 MAG: minor tail protein [Microviridae sp.]	diamond	207	118	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
27595332	27595332	PRJNA994052_P_NODE_11984_length_322_cov_223.108434_g10765_i0	PRJNA994052	11984	322	223.108434	718.40915748	Microviridae sp.	2202644	Viruses	Viruses	57.8	2.17e-8	NR	AXL14456.1	2202644	g10765	i0	53.3	0.419254658385093	45	21	41.9	0	318	184	36	80	AXL14456.1 nonstructural protein [Microviridae sp.]	diamond	135	57.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
29868569	29868569	PRJNA994052_P_NODE_13691_length_315_cov_19.359504_g12470_i0	PRJNA994052	13691	315	19.359504	60.9824376	Apis mellifera associated microvirus 29	2494757	Viruses	Viruses	57.4	2.47e-8	NR	AZL82930.1	2494757	g12470	i0	75.8	0.314285714285714	33	8	31.4	0	215	313	1	33	AZL82930.1 nonstructural protein [Apis mellifera associated microvirus 29]	diamond	99	57.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Apis mellifera associated microvirus 29
31416932	31416932	PRJNA994052_P_NODE_27616_length_288_cov_12.986047_g26375_i0	PRJNA994052	27616	288	12.986047	37.39981536	Microviridae sp.	2202644	Viruses	Viruses	72	1.4e-12	NR	AXL14948.1	2202644	g26375	i0	33.3	2.28125	111	52	92.7	2	279	13	112	222	AXL14948.1 replication initiator protein [Microviridae sp.]	diamond	657	72	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
31638228	31638228	PRJNA994052_P_NODE_67756_length_215_cov_48.711268_g66500_i0	PRJNA994052	67756	215	48.711268	104.7292262	Wigfec virus K19_81	2985969	Viruses	Viruses	70.5	4.29e-12	NR	UYL83847.1	2985969	g66500	i0	85.7	1.3953488372093	35	5	48.8	0	192	88	167	201	UYL83847.1 MAG: major capsid protein [Wigfec virus K19_81]	diamond	300	70.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Wigfec virus K19_81
32207858	32207858	PRJNA994052_P_NODE_22658_length_302_cov_7.755459_g21429_i0	PRJNA994052	22658	302	7.755459	23.42148618	Microviridae sp.	2202644	Viruses	Viruses	77.8	2.34e-14	NR	AXH74815.1	2202644	g21429	i0	76.7	1.37086092715232	43	10	42.7	0	169	297	105	147	AXH74815.1 MAG: replication initiator protein [Microviridae sp.]	diamond	414	77.8	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microviridae sp.
32744934	32744934	PRJNA994052_P_NODE_60840_length_225_cov_4.460526_g59584_i0	PRJNA994052	60840	225	4.460526	10.0361835	Microvirus sp.	2202559	Viruses	Viruses	82.4	2.6e-16	NR	QJB20386.1	2202559	g59584	i0	59.4	0.92	69	27	92	1	15	221	341	408	QJB20386.1 MAG: major capsid protein [Microvirus sp.]	diamond	207	82.4	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae	Microvirus 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);;