metadata: contig_metadata: 7 rows where bioproject = "PRJNA914897" and tax

7 rows where bioproject = "PRJNA914897" 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
4723321	4723321	PRJNA914897_P_NODE_15824_length_443_cov_1.408108_g15402_i0	PRJNA914897	15824	443	1.408108	6.23791844	Spiroplasma culicicola	216935	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|583840421\|gb\|CP006681.1\|	1276246	g15402	i0	96.774	0.069977426636568807	31	1	7	0	38	68	947483	947513	Spiroplasma culicicola AES-1, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma culicicola
4723414	4723414	PRJNA914897_P_NODE_27284_length_308_cov_1.310638_g26860_i0	PRJNA914897	27284	308	1.310638	4.03676504	Bacillati	1783272	Bacteria	Bacteria	84	1.81e-16	NR	OHE35454.1	1802350	g26860	i0	55.9	9.92532467532468	59	26	57.5	0	188	12	57	115	OHE35454.1 MAG: malate dehydrogenase [Tenericutes bacterium GWE2_38_8]	diamond	3057	84.7	0.991735537190083	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium GWE2_38_8
11098417	11098417	PRJNA914897_P_NODE_30789_length_284_cov_1.241706_g30365_i0	PRJNA914897	30789	284	1.241706	3.52644504	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	58.4	5.64e-4	NTclustered	gi\|1951464263\|gb\|CP058416.1\|	28903	g30365	i0	97.059	1.26056338028169	34	1	12	0	170	203	274351	274384	Mycoplasmopsis bovis strain Mb200 chromosome	blastn	358	58.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
11098570	11098570	PRJNA914897_P_NODE_8009_length_684_cov_1.371522_g7608_i0	PRJNA914897	8009	684	1.371522	9.38121048	Spiroplasma endosymbiont of Polydrusus formosus	3139326	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|2802839271\|emb\|OZ181656.1\|	3139326	g7608	i0	100	0.0423976608187134	29	0	4	0	73	101	1283150	1283178	Spiroplasma endosymbiont of Polydrusus formosus isolate 995c39d1-0117-465c-80e3-e7618475d57f genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Polydrusus formosus
14005003	14005003	PRJNA914897_P_NODE_3171_length_1109_cov_1.818533_g2914_i0	PRJNA914897	3171	1109	1.818533	20.16753097	Spiroplasma	2132	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2721114795\|dbj\|AP028955.1\|	2141	g2914	i0	94.595	0.597835888187556	37	2	3	0	932	968	831057	831021	Spiroplasma ixodetis sAp269 DNA, complete genome	blastn	663	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
27821832	27821832	PRJNA914897_P_NODE_34884_length_260_cov_1.235294_g34460_i0	PRJNA914897	34884	260	1.235294	3.2117644	Bacillati	1783272	Bacteria	Bacteria	44.3	0.0121	NR	OHE24823.1	1802344	g34460	i0	36.1	1.66153846153846	72	43	80.8	3	220	11	108	178	OHE24823.1 MAG: hypothetical protein A2Z84_04860 [Tenericutes bacterium GWA2_35_7]	diamond	432	44.3	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium GWA2_35_7
30341006	30341006	PRJNA914897_P_NODE_10252_length_587_cov_2.107004_g9835_i0	PRJNA914897	10252	587	2.107004	12.36811348	Acholeplasma oculi	35623	Bacteria	Bacteria	298	3.05e-100	NR	WP_045749762.1	35623	g9835	i0	78.8	0.965928449744463	189	40	96.6	0	20	586	14	202	WP_045749762.1 uracil phosphoribosyltransferase [Acholeplasma oculi]	diamond	567	298	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma oculi

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