metadata: contig_metadata: 10 rows where bioproject = "PRJNA494251", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA494251", 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
13860560	13860560	PRJNA494251_P_NODE_6171_length_521_cov_1.973214_g5871_i0	PRJNA494251	6171	521	1.973214	10.28044494	Acholeplasmataceae	2146	Bacteria	Bacteria	108	1.07e-18	NTclustered	gi\|383505802\|gb\|JQ390343.1\|	2150	g5871	i0	76.777	96.7946257197697	211	37	40	10	13	218	391	188	Acholeplasma modicum strain PG49 23S ribosomal RNA gene, partial sequence	blastn	50430	108	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma modicum
15134949	15134949	PRJNA494251_P_NODE_35652_length_254_cov_1.596685_g35338_i0	PRJNA494251	35652	254	1.596685	4.0555799	Mycoplasma	2093	Bacteria	Bacteria	161	3.67e-35	NTclustered	gi\|636559261\|ref\|NR_115318.1\|	297515	g35338	i0	81.771	8.22834645669291	192	35	76	0	9	200	410	601	Mycoplasma sphenisci strain UCMJ 16S ribosomal RNA, partial sequence	blastn	2090	161	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sphenisci
17684594	17684594	PRJNA494251_P_NODE_11254_length_402_cov_2.851064_g10948_i0	PRJNA494251	11254	402	2.851064	11.46127728	Mycoplasma	2093	Bacteria	Bacteria	732	0	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g10948	i0	99.749	191.559701492537	399	1	99	0	1	399	270102	269704	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	77007	737	0.993215739484396	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
17684653	17684653	PRJNA494251_P_NODE_32434_length_263_cov_6.347368_g32120_i0	PRJNA494251	32434	263	6.347368	16.69357784	Bacteria	2	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|2294977822\|gb\|OP364020.1\|	2108	g32120	i0	99.231	158.19391634981	260	2	99	0	1	260	758	499	Mycoplasma sp. strain unknow 16S ribosomal RNA gene, partial sequence	blastn	41605	470	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
17684711	17684711	PRJNA494251_P_NODE_52154_length_217_cov_10.479167_g51840_i0	PRJNA494251	52154	217	10.479167	22.73979239	Mycoplasma	2093	Bacteria	Bacteria	392	9.94e-105	NTclustered	gi\|54609775\|gb\|AY765214.1\|	51364	g51840	i0	100	182.691244239631	212	0	98	0	3	214	588	377	Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39644	392	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
21508819	21508819	PRJNA494251_P_NODE_22017_length_305_cov_7.681034_g21703_i0	PRJNA494251	22017	305	7.681034	23.4271537	Bacteria	2	Bacteria	Bacteria	521	1.8e-143	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g21703	i0	98.969	170.245901639344	291	3	95	0	12	302	1500	1210	Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51925	521	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
23427580	23427580	PRJNA494251_P_NODE_16699_length_341_cov_8.608209_g16386_i0	PRJNA494251	16699	341	8.608209	29.35399269	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	257	6.360000000000001e-64	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g16386	i0	82.333	403.020527859238	300	50	88	3	4	302	373472	373769	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	137430	257	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
26760273	26760273	PRJNA494251_P_NODE_14701_length_361_cov_0.920139_g14390_i0	PRJNA494251	14701	361	0.920139	3.32170179	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	48.9	8.05e-4	NR	QVK17080.1	2231116	g14390	i0	30.2	1.42105263157895	86	47	71.5	1	340	83	48	120	QVK17080.1 GNAT family N-acetyltransferase [Mycoplasmatota bacterium]	diamond	513	48.9	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
26982038	26982038	PRJNA494251_P_NODE_41682_length_247_cov_0.885057_g41368_i0	PRJNA494251	41682	247	0.885057	2.18609079	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	45.1	0.00486	NR	MDR0986010.1	2685873	g41368	i0	35.8	0.813765182186235	67	39	76.5	1	211	23	157	223	MDR0986010.1 ribonuclease III [Mycoplasmataceae bacterium]	diamond	201	45.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
28561338	28561338	PRJNA494251_P_NODE_12967_length_379_cov_1.509804_g12659_i0	PRJNA494251	12967	379	1.509804	5.72215716	Candidatus Faecisoma merdavium	2840801	Bacteria	Bacteria	44.3	0.0447	NR	HIS90586.1	2840801	g12659	i0	35.1	0.767810026385224	97	49	69.7	4	348	85	50	141	HIS90586.1 hypothetical protein [Candidatus Faecisoma merdavium]	diamond	291	44.3	1	Bacteria	Bacillati	Mycoplasmatota				Candidatus Faecisoma	Candidatus Faecisoma merdavium

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