metadata: contig_metadata: 11 rows where bioproject = "PRJNA492406", tax_phylum = "Mycoplasmatota" and tax

11 rows where bioproject = "PRJNA492406", 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
452632	452632	PRJNA492406_P_NODE_26721_length_251_cov_0.865169_g26422_i0	PRJNA492406	26721	251	0.865169	2.17157419	Mycoplasma cottewii	51364	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g26422	i0	93.227	1.9003984063745	251	17	100	0	1	251	722801	722551	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	477	370	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
8106005	8106005	PRJNA492406_P_NODE_9467_length_399_cov_0.944785_g9168_i0	PRJNA492406	9467	399	0.944785	3.76969215	Mycoplasma cottewii	51364	Bacteria	Bacteria	206	2.7699999999999996e-48	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g9168	i0	85.5	21.1052631578947	200	25	50	4	171	368	473674	473871	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	8421	206	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
8752228	8752228	PRJNA492406_P_NODE_32527_length_234_cov_2.782609_g32228_i0	PRJNA492406	32527	234	2.782609	6.51130506	Mesomycoplasma	2923352	Bacteria	Bacteria	420	4.99e-113	NTclustered	gi\|2065475\|gb\|U35016.1\|MHU35016	2100	g32228	i0	100	15.8333333333333	227	0	97	0	1	227	1318	1544	Mycoplasma hyorhinis VlpD prolipoprotein (vlpD), VlpE prolipoprotein (vlpE), VlpF prolipoprotein (vlpF) genes, complete cds	blastn	3705	420	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10656293	10656293	PRJNA492406_P_NODE_26709_length_251_cov_0.865169_g26410_i0	PRJNA492406	26709	251	0.865169	2.17157419	Tenericutes bacterium MO-XQ	1911684	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|1307784757\|gb\|CP017948.1\|	1911684	g26410	i0	100	3.07171314741036	31	0	12	0	221	251	2036513	2036543	Tenericutes bacterium MO-XQ chromosome, complete sequence	blastn	771	58.4	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium MO-XQ
13206369	13206369	PRJNA492406_P_NODE_29511_length_246_cov_0.884393_g29212_i0	PRJNA492406	29511	246	0.884393	2.17560678	Mycoplasma cottewii	51364	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g29212	i0	97.561	72.5609756097561	246	6	100	0	1	246	137375	137130	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	17850	422	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
17029853	17029853	PRJNA492406_P_NODE_26274_length_252_cov_1.290503_g25975_i0	PRJNA492406	26274	252	1.290503	3.25206756	Mycoplasma yeatsii	51365	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g25975	i0	99.603	91.6785714285714	252	1	100	0	1	252	529433	529684	Mycoplasma yeatsii GM274B	blastn	23103	460	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
17676967	17676967	PRJNA492406_P_NODE_32374_length_238_cov_2.169697_g32075_i0	PRJNA492406	32374	238	2.169697	5.16387886	Mycoplasma	2093	Bacteria	Bacteria	429	8.45e-116	NTclustered	gi\|54609775\|gb\|AY765214.1\|	51364	g32075	i0	99.16	195.659663865546	238	2	100	0	1	238	490	253	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	46567	429	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
18950810	18950810	PRJNA492406_P_NODE_29715_length_245_cov_1.343023_g29416_i0	PRJNA492406	29715	245	1.343023	3.29040635	Mycoplasma	2093	Bacteria	Bacteria	435	1.88e-117	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g29416	i0	98.77	12.3102040816327	244	3	99	0	2	245	903520	903763	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	3016	435	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
19578433	19578433	PRJNA492406_P_NODE_27576_length_249_cov_1.096591_g27277_i0	PRJNA492406	27576	249	1.096591	2.73051159	Mycoplasma yeatsii	51365	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g27277	i0	97.992	97.5502008032128	249	5	100	0	1	249	135874	136122	Mycoplasma yeatsii GM274B	blastn	24290	433	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
22776389	22776389	PRJNA492406_P_NODE_5858_length_495_cov_19.251185_g5559_i0	PRJNA492406	5858	495	19.251185	95.29336575	Bacteria	2	Bacteria	Bacteria	904	0	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g5559	i0	99.596	173.80202020202	495	2	100	0	1	495	922	1416	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	86032	904	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
24678603	24678603	PRJNA492406_P_NODE_26760_length_251_cov_0.865169_g26461_i0	PRJNA492406	26760	251	0.865169	2.17157419	Mycoplasma cottewii	51364	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g26461	i0	98.008	24.3386454183267	251	5	100	0	1	251	324597	324847	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	6109	436	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii

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