metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA591000" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA591000" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
564962	564962	PRJNA591000_P_NODE_14701_length_385_cov_2.196629_g13099_i0	PRJNA591000	14701	385	2.196629	8.45702165	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	147	1.64e-30	NTclustered	gi\|2119748049\|dbj\|AP025183.1\|	1751056	g13099	i0	91.509	0.27532467532467497	106	9	28	0	2	107	2025329	2025224	Flavobacterium ammonificans GENT11 DNA, complete genome	blastn	106	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
1840476	1840476	PRJNA591000_P_NODE_16202_length_173_cov_2.277778_g14596_i0	PRJNA591000	16202	173	2.277778	3.94055594	Segatella oris	28135	Bacteria	Bacteria	174	2.97e-39	NTclustered	gi\|1540054687\|emb\|LR134384.1\|	28135	g14596	i0	98	246.491329479769	100	2	97	0	1	100	442438	442537	Prevotella oris strain NCTC13071 genome assembly, chromosome: 1	blastn	42643	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella oris
3115854	3115854	PRJNA591000_P_NODE_13903_length_396_cov_0.841962_g12308_i0	PRJNA591000	13903	396	0.841962	3.33416952	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	161	6.04e-35	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g12308	i0	97.849	10.2449494949495	93	2	39	0	1	93	2116879	2116971	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	4057	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
5668665	5668665	PRJNA591000_P_NODE_11625_length_422_cov_1.427481_g10044_i0	PRJNA591000	11625	422	1.427481	6.02396982	Marinilabiliaceae bacterium	2053574	Bacteria	Bacteria	99	5.15e-16	NTclustered	gi\|2621704345\|emb\|OY760941.1\|	2053574	g10044	i0	82.883	0.26303317535545	111	17	26	2	1	110	1430044	1429935	MAG: Marinilabiliaceae bacterium isolate 2264d8ac-961e-4ead-949a-d386559d349b genome assembly, chromosome: 1	blastn	111	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae		Marinilabiliaceae bacterium
8218140	8218140	PRJNA591000_P_NODE_1287_length_1052_cov_2.852395_g908_i0	PRJNA591000	1287	1052	2.852395	30.0071954	Parabacteroides chongii	2685834	Bacteria	Bacteria	523	1.8799999999999999e-143	NTclustered	gi\|2474587498\|gb\|CP120849.1\|	2685834	g908	i0	86.207	233.941064638783	493	57	46	10	388	873	345431	345919	Parabacteroides chongii strain YMC B3181 chromosome	blastn	246106	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides chongii
12617699	12617699	PRJNA591000_P_NODE_16870_length_151_cov_1.860656_g15264_i0	PRJNA591000	16870	151	1.860656	2.80959056	Emticicia	312278	Bacteria	Bacteria	206	8.94e-49	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g15264	i0	94.697	297.781456953642	132	7	87	0	20	151	1028	897	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	44965	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
13318901	13318901	PRJNA591000_P_NODE_1331_length_1037_cov_5.610119_g940_i0	PRJNA591000	1331	1037	5.610119	58.17693403	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	874	0	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g940	i0	99.175	36.7213114754098	485	4	97	0	55	539	712615	713099	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	38080	874	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
14593765	14593765	PRJNA591000_P_NODE_11172_length_428_cov_0.914787_g9594_i0	PRJNA591000	11172	428	0.914787	3.91528836	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	206	2.99e-48	NTclustered	gi\|2119748049\|dbj\|AP025183.1\|	1751056	g9594	i0	94.074	1.03738317757009	135	8	52	0	1	135	745629	745763	Flavobacterium ammonificans GENT11 DNA, complete genome	blastn	444	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
14593767	14593767	PRJNA591000_P_NODE_15412_length_340_cov_3.707395_g13806_i0	PRJNA591000	15412	340	3.707395	12.605143	Runella sp. SP2	2268026	Bacteria	Bacteria	99	4.07e-16	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g13806	i0	92.754	16.8794117647059	69	4	20	1	272	340	996910	996843	Runella sp. SP2 chromosome, complete genome	blastn	5739	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
15867600	15867600	PRJNA591000_P_NODE_16913_length_150_cov_1.826446_g15307_i0	PRJNA591000	16913	150	1.826446	2.739669	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g15307	i0	100	2	150	0	100	0	1	150	2045700	2045849	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	300	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
18416783	18416783	PRJNA591000_P_NODE_4035_length_721_cov_27.572254_g3175_i0	PRJNA591000	4035	721	27.572254	198.79595134	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	678	0	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g3175	i0	90.631	335.217753120666	523	31	88	10	1	519	2324062	2324570	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	241692	678	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
22242044	22242044	PRJNA591000_P_NODE_11418_length_424_cov_3.534177_g9837_i0	PRJNA591000	11418	424	3.534177	14.98491048	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	300	1.32e-76	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g9837	i0	97.175	0.761792452830189	177	5	74	0	54	230	1660558	1660734	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	323	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
22242056	22242056	PRJNA591000_P_NODE_7298_length_517_cov_4.372951_g5850_i0	PRJNA591000	7298	517	4.372951	22.60815667	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	756	0	NTclustered	gi\|2119748049\|dbj\|AP025183.1\|	1751056	g5850	i0	94.639	35.1663442940039	485	21	94	1	33	517	1514397	1514876	Flavobacterium ammonificans GENT11 DNA, complete genome	blastn	18181	756	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
22815807	22815807	PRJNA591000_P_NODE_16458_length_162_cov_1.894737_g14852_i0	PRJNA591000	16458	162	1.894737	3.06947394	Niabella	379899	Bacteria	Bacteria	132	1.68e-26	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g14852	i0	83.333	2.99382716049383	144	23	89	1	1	144	244486	244344	Niabella sp. I6 chromosome	blastn	485	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6

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