metadata: contig_metadata: 11 rows where bioproject = "PRJNA812715", tax_kingdom = "Bacillati" and tax

11 rows where bioproject = "PRJNA812715", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

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
13978717	13978717	PRJNA812715_P_NODE_26531_length_608_cov_5.213084_g24799_i0	PRJNA812715	26531	608	5.213084	31.69555072	Mycoplasma	2093	Bacteria	Bacteria	76.8	3.57e-9	NTclustered	gi\|526641973\|ref\|NR_103970.1\|	57372	g24799	i0	87.143	11.4473684210526	70	5	11	4	144	209	557	488	Mycoplasma suis strain Illinois 23S ribosomal RNA gene, complete sequence	blastn	6960	76.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma suis
17390881	17390881	PRJNA812715_P_NODE_18594_length_803_cov_1.923288_g17031_i0	PRJNA812715	18594	803	1.923288	15.44400264	Mollicutes bacterium	37628	Bacteria	Bacteria	95.1	3.96e-18	NR	NLL44669.1	37628	g17031	i0	42.4	1.39352428393524	125	43	46.3	3	3	374	408	504	NLL44669.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Mollicutes bacterium]	diamond	1119	95.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
26801069	26801069	PRJNA812715_P_NODE_62221_length_330_cov_75.634241_g60422_i0	PRJNA812715	62221	330	75.634241	249.5929953	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	108	2.56e-27	NR	MBW0597145.1	171279	g60422	i0	63.5	0.872727272727273	96	35	87.3	0	41	328	62	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	288	108	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
26832868	26832868	PRJNA812715_P_NODE_64861_length_321_cov_79.004032_g63061_i0	PRJNA812715	64861	321	79.004032	253.60294272	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	115	2.14e-30	NR	MBW0597145.1	171279	g63061	i0	67.7	0.897196261682243	96	31	89.7	0	290	3	62	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	288	115	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
28096589	28096589	PRJNA812715_P_NODE_110265_length_247_cov_0.885057_g108464_i0	PRJNA812715	110265	247	0.885057	2.18609079	Acholeplasma sp.	33015	Bacteria	Bacteria	52.4	1.49e-5	NR	MFA7417213.1	33015	g108464	i0	43.4	1.34817813765182	53	30	64.4	0	87	245	290	342	MFA7417213.1 SLC13 family permease [Acholeplasma sp.]	diamond	333	52.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma sp.
28759602	28759602	PRJNA812715_P_NODE_71387_length_302_cov_80.283843_g69587_i0	PRJNA812715	71387	302	80.283843	242.45720586	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	99	7.689999999999998e-24	NR	MBW0597145.1	171279	g69587	i0	57.3	0.95364238410596	96	41	95.4	0	13	300	62	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	288	99	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
29928119	29928119	PRJNA812715_P_NODE_28691_length_572_cov_51.284569_g26934_i0	PRJNA812715	28691	572	51.284569	293.34773468	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	112	9.33e-28	NR	MBW0597145.1	171279	g26934	i0	65.6	0.503496503496504	96	33	50.3	0	283	570	62	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	288	112	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
30180611	30180611	PRJNA812715_P_NODE_28692_length_572_cov_40.192385_g26935_i0	PRJNA812715	28692	572	40.192385	229.9004422	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	106	2.34e-25	NR	MBW0597145.1	171279	g26935	i0	64.6	0.503496503496504	96	34	50.3	0	290	3	62	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	288	106	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
31603024	31603024	PRJNA812715_P_NODE_37476_length_468_cov_2.141772_g35687_i0	PRJNA812715	37476	468	2.141772	10.02349296	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	121	9.95e-32	NR	MBW0597145.1	171279	g35687	i0	78.1	1.27564102564103	96	21	61.5	0	180	467	63	158	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	597	121	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
31950826	31950826	PRJNA812715_P_NODE_79217_length_285_cov_94.891509_g77417_i0	PRJNA812715	79217	285	94.891509	270.44080065000003	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	109	3.5399999999999993e-28	NR	MBW0597145.1	171279	g77417	i0	66	0.989473684210526	94	32	98.9	0	2	283	64	157	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	282	109	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis
32077427	32077427	PRJNA812715_P_NODE_24298_length_653_cov_50.853448_g22594_i0	PRJNA812715	24298	653	50.853448	332.07301544	Mycoplasmopsis anatis	171279	Bacteria	Bacteria	108	6.610000000000001e-26	NR	MBW0597145.1	171279	g22594	i0	64.9	0.445635528330781	97	34	44.6	0	41	331	62	158	MBW0597145.1 hypothetical protein [Mycoplasmopsis anatis]	diamond	291	108	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis anatis

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