metadata: contig_metadata: 13 rows where bioproject = "PRJNA983848", tax_phylum = "Mycoplasmatota" and tax

13 rows where bioproject = "PRJNA983848", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

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
3518672	3518672	PRJNA983848_P_NODE_156803_length_243_cov_2.229412_g150920_i0	PRJNA983848	156803	243	2.229412	5.41747116	Candidatus Tyloplasma litorale	3132031	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|2413215879\|dbj\|AP027078.1\|	3132031	g150920	i0	93.827	230.111111111111	243	15	100	0	1	243	149622	149380	MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome	blastn	55917	366	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Tyloplasma	Candidatus Tyloplasma litorale
3520990	3520990	PRJNA983848_P_NODE_70363_length_376_cov_86.363036_g64480_i0	PRJNA983848	70363	376	86.363036	324.72501536	Candidatus Tyloplasma litorale	3132031	Bacteria	Bacteria	608	1.689999999999999e-169	NTclustered	gi\|2413215879\|dbj\|AP027078.1\|	3132031	g64480	i0	95.778	99.0159574468085	379	12	100	4	1	376	150954	150577	MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome	blastn	37230	608	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Tyloplasma	Candidatus Tyloplasma litorale
4796690	4796690	PRJNA983848_P_NODE_26044_length_942_cov_6.059839_g20794_i0	PRJNA983848	26044	942	6.059839	57.08368338	Spiroplasma endosymbiont of Dioctria linearis	3066290	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2719904871\|emb\|OZ034984.1\|	3066290	g20794	i0	97.059	0.176220806794055	34	1	4	0	494	527	1096621	1096588	Spiroplasma endosymbiont of Dioctria linearis isolate 54760 genome assembly, chromosome: 1	blastn	166	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Dioctria linearis
9897589	9897589	PRJNA983848_P_NODE_44108_length_548_cov_50.454737_g38248_i0	PRJNA983848	44108	548	50.454737	276.49195876	uncultured Mycoplasmataceae bacterium	300027	Bacteria	Bacteria	941	0	NTclustered	gi\|371782163\|emb\|HE610322.1\|	300027	g38248	i0	97.628	99.1167883211679	548	13	100	0	1	548	887	1434	Uncultured Mycoplasmataceae bacterium partial 16S rRNA gene, clone 3-B9	blastn	54316	941	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		uncultured Mycoplasmataceae bacterium
12445471	12445471	PRJNA983848_P_NODE_105450_length_293_cov_16.568182_g99567_i0	PRJNA983848	105450	293	16.568182	48.54477326	Candidatus Tyloplasma litorale	3132031	Bacteria	Bacteria	448	2.9699999999999996e-121	NTclustered	gi\|2413215879\|dbj\|AP027078.1\|	3132031	g99567	i0	94.218	411.146757679181	294	15	99	1	2	293	156637	156344	MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome	blastn	120466	448	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Tyloplasma	Candidatus Tyloplasma litorale
13721050	13721050	PRJNA983848_P_NODE_136851_length_253_cov_4.250000_g130968_i0	PRJNA983848	136851	253	4.25	10.7525	uncultured Mycoplasmataceae bacterium	300027	Bacteria	Bacteria	422	1.52e-113	NTclustered	gi\|187372852\|gb\|EU646198.1\|	300027	g130968	i0	96.838	101.110671936759	253	7	100	1	1	253	1035	1286	Uncultured Mycoplasmataceae bacterium clone Lo_Hep1.15 16S ribosomal RNA gene, partial sequence	blastn	25581	422	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		uncultured Mycoplasmataceae bacterium
15299426	15299426	PRJNA983848_P_NODE_48452_length_504_cov_3.712297_g42578_i0	PRJNA983848	48452	504	3.712297	18.70997688	Bacteria	2	Bacteria	Bacteria	904	0	NTclustered	gi\|2606493072\|gb\|CP136954.1\|	3081164	g42578	i0	99.008	772.603174603175	504	5	100	0	1	504	388437	388940	Mollicutes bacterium LVI A0075 chromosome, complete genome	blastn	389392	904	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0075
16270114	16270114	PRJNA983848_P_NODE_130633_length_260_cov_43.010695_g124750_i0	PRJNA983848	130633	260	43.010695	111.827807	Mycoplasma sp. Mirounga ES2774-NASSP4	754513	Bacteria	Bacteria	315	2.7399999999999992e-81	NTclustered	gi\|294768481\|gb\|GU905029.1\|	754513	g124750	i0	88.846	102.984615384615	260	23	99	5	4	260	2021	1765	Mycoplasma sp. Mirounga ES2774-NASSP4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26776	315	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. Mirounga ES2774-NASSP4
17546354	17546354	PRJNA983848_P_NODE_167534_length_202_cov_7.953488_g161651_i0	PRJNA983848	167534	202	7.953488	16.06604576	Candidatus Tyloplasma litorale	3132031	Bacteria	Bacteria	261	2.68e-65	NTclustered	gi\|2413215879\|dbj\|AP027078.1\|	3132031	g161651	i0	90.099	128.386138613861	202	18	99	2	2	202	155241	155041	MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome	blastn	25934	261	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Tyloplasma	Candidatus Tyloplasma litorale
17849168	17849168	PRJNA983848_P_NODE_158634_length_242_cov_16.597633_g152751_i0	PRJNA983848	158634	242	16.597633	40.16627186	Bacteria	2	Bacteria	Bacteria	274	4.27e-69	NTclustered	gi\|2606720429\|gb\|CP136989.1\|	3081162	g152751	i0	87.137	293.454545454545	241	31	99	0	1	241	308239	308479	Mollicutes bacterium LVI A0006 chromosome, complete genome	blastn	71016	274	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0006
18818794	18818794	PRJNA983848_P_NODE_127175_length_264_cov_593.534031_g121292_i0	PRJNA983848	127175	264	593.534031	1566.92984184	Mycoplasma iguanae	292461	Bacteria	Bacteria	340	4.5999999999999996e-89	NTclustered	gi\|2288165161\|gb\|CP102734.1\|	292461	g121292	i0	90.625	139.227272727273	256	24	97	0	6	261	98025	98280	Mycoplasma iguanae strain 2327 chromosome, complete genome	blastn	36756	340	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma iguanae
21673884	21673884	PRJNA983848_P_NODE_164417_length_231_cov_2.759494_g158534_i0	PRJNA983848	164417	231	2.759494	6.37443114	Bacteria	2	Bacteria	Bacteria	411	2.9599999999999995e-110	NTclustered	gi\|2606493072\|gb\|CP136954.1\|	3081164	g158534	i0	98.701	215.718614718615	231	3	100	0	1	231	387788	388018	Mollicutes bacterium LVI A0075 chromosome, complete genome	blastn	49831	411	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0075
22644467	22644467	PRJNA983848_P_NODE_134998_length_255_cov_37.186813_g129115_i0	PRJNA983848	134998	255	37.186813	94.82637315	Candidatus Tyloplasma litorale	3132031	Bacteria	Bacteria	333	7.3899999999999995e-87	NTclustered	gi\|2413215879\|dbj\|AP027078.1\|	3132031	g129115	i0	90.476	963.847058823529	252	24	99	0	1	252	149376	149627	MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome	blastn	245781	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Tyloplasma	Candidatus Tyloplasma litorale

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