metadata: contig_metadata: 12 rows where bioproject = "PRJEB64798" and tax

12 rows where bioproject = "PRJEB64798" and tax_phylum = "Deferribacterota"

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
992852	992852	PRJEB64798_P_NODE_137521_length_194_cov_18.006897_g135755_i0	PRJEB64798	137521	194	18.006897	34.93338018	Bacteria	2	Bacteria	Bacteria	315	1.93e-81	NTclustered	gi\|9858891\|gb\|AY005447.1\|	135004	g135755	i0	97.79	92.6030927835052	181	4	93	0	13	193	1	181	Flexistipes-like sp. oral clone BH007 16S ribosomal RNA gene, partial sequence	blastn	17965	315	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres				Flexistipes-like sp. oral clone BH007
8646113	8646113	PRJEB64798_P_NODE_177307_length_175_cov_8.246032_g175541_i0	PRJEB64798	177307	175	8.246032	14.430556	Mucispirillum	248038	Bacteria	Bacteria	91.6	3.12e-14	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g175541	i0	96.364	1.88571428571429	55	2	31	0	1	55	867922	867868	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	330	91.6	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
11196314	11196314	PRJEB64798_P_NODE_171049_length_178_cov_4.550388_g169283_i0	PRJEB64798	171049	178	4.550388	8.09969064	Denitrovibrio	117999	Bacteria	Bacteria	117	5.26e-22	NTclustered	gi\|470486080\|ref\|NR_076734.1\|	118000	g169283	i0	91.667	151.64606741573	84	7	47	0	68	151	127	44	Denitrovibrio acetiphilus strain N2460 23S ribosomal RNA gene, complete sequence	blastn	26993	117	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Denitrovibrio	Denitrovibrio acetiphilus
13747183	13747183	PRJEB64798_P_NODE_83091_length_213_cov_7.542683_g81325_i0	PRJEB64798	83091	213	7.542683	16.06591479	Mucispirillum	248038	Bacteria	Bacteria	172	1.3799999999999999e-38	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g81325	i0	97.059	44.6244131455399	102	3	93	0	1	102	866961	866860	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	9505	172	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
15020929	15020929	PRJEB64798_P_NODE_177392_length_175_cov_7.301587_g175626_i0	PRJEB64798	177392	175	7.301587	12.77777725	Mucispirillum	248038	Bacteria	Bacteria	263	6.26e-66	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g175626	i0	93.714	243.937142857143	175	11	100	0	1	175	867597	867423	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	42689	263	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
16295865	16295865	PRJEB64798_P_NODE_212653_length_164_cov_1.826087_g210887_i0	PRJEB64798	212653	164	1.826087	2.99478268	Denitrovibrio	117999	Bacteria	Bacteria	73.1	1.05e-8	NTclustered	gi\|470486080\|ref\|NR_076734.1\|	118000	g210887	i0	89.474	2.43292682926829	57	6	35	0	6	62	1328	1272	Denitrovibrio acetiphilus strain N2460 23S ribosomal RNA gene, complete sequence	blastn	399	73.1	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Denitrovibrio	Denitrovibrio acetiphilus
18845401	18845401	PRJEB64798_P_NODE_82215_length_213_cov_13.189024_g80449_i0	PRJEB64798	82215	213	13.189024	28.09262112	Mucispirillum	248038	Bacteria	Bacteria	237	4.82e-58	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g80449	i0	85.333	129.516431924883	225	17	98	2	1	209	866516	866292	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	27587	237	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
21395039	21395039	PRJEB64798_P_NODE_155537_length_185_cov_12.080882_g153771_i0	PRJEB64798	155537	185	12.080882	22.3496317	Mucispirillum	248038	Bacteria	Bacteria	156	1.17e-33	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g153771	i0	98.851	59.8432432432432	87	1	47	0	8	94	2003736	2003650	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	11071	156	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
22670430	22670430	PRJEB64798_P_NODE_4538_length_904_cov_19.715789_g3583_i0	PRJEB64798	4538	904	19.715789	178.23073256	Mucispirillum	248038	Bacteria	Bacteria	292	4.9399999999999986e-74	NTclustered	gi\|2211256631\|emb\|OW091398.1\|	248039	g3583	i0	73.526	115.105088495575	865	190	94	33	11	858	866470	865628	Mucispirillum schaedleri isolate Mucispirillum_schaedleri_DSM104751 genome assembly, chromosome: Mucispirillum_schaedleri_1	blastn	104055	292	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
27001998	27001998	PRJEB64798_P_NODE_72942_length_226_cov_3.531073_g71177_i0	PRJEB64798	72942	226	3.531073	7.98022498	Flexistipes sinusarabici	2352	Bacteria	Bacteria	65.5	2.4e-10	NR	WP_013886089.1	2352	g71177	i0	58.9	2.11061946902655	56	19	69	1	7	162	225	280	WP_013886089.1 Fe(3+) ABC transporter substrate-binding protein [Flexistipes sinusarabici]	diamond	477	65.5	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Flexistipitaceae	Flexistipes	Flexistipes sinusarabici
30981820	30981820	PRJEB64798_P_NODE_209674_length_165_cov_0.896552_g207908_i0	PRJEB64798	209674	165	0.896552	1.4793108	Mucispirillum schaedleri ASF457	1379858	Bacteria	Bacteria	45.1	1.99e-4	NR	SIW06123.1	1379858	g207908	i0	60	0.727272727272727	40	15	70.9	1	127	11	25	64	SIW06123.1 hypothetical protein MCSV2_20152 [Mucispirillum schaedleri ASF457]	diamond	120	45.1	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum schaedleri
31006311	31006311	PRJEB64798_P_NODE_97414_length_212_cov_3.662577_g95648_i0	PRJEB64798	97414	212	3.662577	7.76466324	Pseudomonadati	3379134	Bacteria	Bacteria	64.7	9.87e-11	NR	MCI6476336.1	1965235	g95648	i0	84.8	64.372641509434	33	5	46.7	0	99	1	8	40	MCI6476336.1 lyase family protein [Mucispirillum sp.]	diamond	13647	64.7	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum sp.

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