metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
13851558	13851558	PRJNA488043_P_NODE_17251_length_200_cov_1.210526_g15009_i0	PRJNA488043	17251	200	1.210526	2.421052	Mollicutes	31969	Bacteria	Bacteria	93.5	1.02e-14	NTclustered	gi\|1150393080\|gb\|KY674413.1\|	2141	g15009	i0	88.312	38.775	77	9	39	0	28	104	482	406	Spiroplasma ixodetis isolate Ixosp1Tickpanthr11 16S ribosomal RNA gene, partial sequence	blastn	7755	93.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
15752443	15752443	PRJNA488043_P_NODE_11413_length_297_cov_3.395522_g9172_i0	PRJNA488043	11413	297	3.395522	10.08470034	Malacoplasma muris	2119	Bacteria	Bacteria	363	1.1199999999999999e-95	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g9172	i0	88.889	358.740740740741	297	29	100	2	1	297	910	1202	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	106546	363	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
15752503	15752503	PRJNA488043_P_NODE_15573_length_219_cov_7.663158_g13331_i0	PRJNA488043	15573	219	7.663158	16.78231602	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	185	1.8299999999999994e-42	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g13331	i0	82.192	394.401826484018	219	35	99	4	1	218	373699	373484	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	86374	185	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
16400573	16400573	PRJNA488043_P_NODE_6773_length_479_cov_8.508889_g4680_i0	PRJNA488043	6773	479	8.508889	40.75757831	Malacoplasma	2791001	Bacteria	Bacteria	573	8.049999999999998e-159	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g4680	i0	88.518	134.730688935282	479	47	99	8	5	479	492	18	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	64536	573	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
20851646	20851646	PRJNA488043_P_NODE_9077_length_371_cov_4.467836_g6852_i0	PRJNA488043	9077	371	4.467836	16.57567156	Malacoplasma microti	38746	Bacteria	Bacteria	412	1.4e-110	NTclustered	gi\|299851939\|gb\|HM135466.1\|	38746	g6852	i0	86.933	146.805929919137	375	39	100	8	1	371	1188	1556	Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence	blastn	54465	412	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma microti
25324227	25324227	PRJNA488043_P_NODE_7140_length_457_cov_5.820093_g5010_i0	PRJNA488043	7140	457	5.820093	26.59782501	Mollicutes	31969	Bacteria	Bacteria	658	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g5010	i0	92.779	140.886214442013	457	30	99	3	1	456	449	903	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	64385	658	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris

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