metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA764222" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA764222" 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
2020816	2020816	PRJNA764222_S_NODE_3362_length_342_cov_2.783051_g3204_i0	PRJNA764222	3362	342	2.783051	9.51803442	Bacteroidales bacterium	2030927	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2621786220\|emb\|OY782678.1\|	2030927	g3204	i0	100	0.0847953216374269	29	0	8	0	146	174	472981	472953	MAG: Bacteroidales bacterium isolate 1f9300ae-d6db-4a26-8fb7-1be2ee45184d genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
4573073	4573073	PRJNA764222_S_NODE_2984_length_354_cov_1.602606_g2826_i0	PRJNA764222	2984	354	1.602606	5.67322524	Fibrella aestuarina	651143	Bacteria	Bacteria	355	2.28e-93	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g2826	i0	86.053	353.231638418079	337	40	95	7	1	333	608627	608960	Fibrella aestuarina BUZ 2 drat genome	blastn	125044	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
5034122	5034122	PRJNA764222_S_NODE_33784_length_154_cov_2.383178_g33626_i0	PRJNA764222	33784	154	2.383178	3.67009412	Blattabacterium	34098	Bacteria	Bacteria	145	2.03e-30	NTclustered	gi\|1893901203\|gb\|CP059198.1\|	1653831	g33626	i0	88.43	62.8376623376623	121	12	78	2	35	154	404589	404708	Blattabacterium cuenoti strain MEGALOsp chromosome	blastn	9677	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
5848121	5848121	PRJNA764222_S_NODE_16645_length_225_cov_1.707865_g16487_i0	PRJNA764222	16645	225	1.707865	3.84269625	Flavobacterium capsici	3075618	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2582099103\|gb\|CP134890.1\|	3075618	g16487	i0	100	0.248888888888889	28	0	12	0	164	191	2977747	2977774	Flavobacterium capsici strain PMTSA4 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium capsici
5848238	5848238	PRJNA764222_S_NODE_25105_length_188_cov_1.113475_g24947_i0	PRJNA764222	25105	188	1.113475	2.093333	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2621786417\|emb\|OY782875.1\|	2053594	g24947	i0	100	0.148936170212766	28	0	15	0	63	90	1412111	1412084	MAG: Prolixibacteraceae bacterium isolate 03360cef-1fb4-4bdc-8d3a-9e0c45a661a4 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
9672985	9672985	PRJNA764222_S_NODE_11248_length_254_cov_3.613527_g11090_i0	PRJNA764222	11248	254	3.613527	9.17835858	Aquimarina sp. LLG6339-5	3160830	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2858555899\|gb\|CP159328.1\|	3160830	g11090	i0	100	0.110236220472441	28	0	11	0	55	82	3361726	3361753	Aquimarina sp. LLG6339-5 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. LLG6339-5
10134393	10134393	PRJNA764222_S_NODE_31868_length_164_cov_1.034188_g31710_i0	PRJNA764222	31868	164	1.034188	1.69606832	Flavobacterium	237	Bacteria	Bacteria	294	2.06e-75	NTclustered	gi\|2922046464\|gb\|CP182943.1\|	1355330	g31710	i0	100	489.615853658537	159	0	97	0	1	159	575228	575070	Flavobacterium faecale strain WV33 chromosome, complete genome	blastn	80297	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium faecale
10134429	10134429	PRJNA764222_S_NODE_8748_length_272_cov_2.048889_g8590_i0	PRJNA764222	8748	272	2.048889	5.57297808	Sphingobacterium	28453	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2463818431\|gb\|CP120231.1\|	341027	g8590	i0	100	0.216911764705882	28	0	10	0	167	194	4695847	4695820	MAG: Sphingobacterium sp. isolate MAG 2 chromosome, complete genome	blastn	59	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp.
12224500	12224500	PRJNA764222_S_NODE_34170_length_150_cov_4.621359_g34012_i0	PRJNA764222	34170	150	4.621359	6.9320385	uncultured Flavobacteriales bacterium	213322	Bacteria	Bacteria	174	2.5e-39	NTclustered	gi\|2308952759\|emb\|OX044359.1\|	213322	g34012	i0	89.706	143.26	136	14	91	0	8	143	217464	217599	MAG: uncultured Flavobacteriales bacterium isolate C_MB391 genome assembly, chromosome: C_MB391_contig-1	blastn	21489	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			uncultured Flavobacteriales bacterium
16508656	16508656	PRJNA764222_S_NODE_21833_length_201_cov_2.032468_g21675_i0	PRJNA764222	21833	201	2.032468	4.08526068	Bacteroides	816	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2032952970\|gb\|CP072244.1\|	28116	g21675	i0	100	1.95024875621891	28	0	14	0	144	171	2899365	2899338	Bacteroides ovatus strain CL06T03C20 chromosome, complete genome	blastn	392	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ovatus
18596452	18596452	PRJNA764222_S_NODE_28955_length_173_cov_1.555556_g28797_i0	PRJNA764222	28955	173	1.555556	2.69111188	Prevotella bivia	28125	Bacteria	Bacteria	270	3.69e-68	NTclustered	gi\|2679198013\|dbj\|AP029376.1\|	28125	g28797	i0	94.828	7.20231213872832	174	8	100	1	1	173	133264	133437	Prevotella bivia TOH-2715 DNA, chromosome 2, complete sequence	blastn	1246	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
18596457	18596457	PRJNA764222_S_NODE_29255_length_172_cov_1.392000_g29097_i0	PRJNA764222	29255	172	1.392	2.39424	Chryseobacterium indologenes	253	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g29097	i0	96.97	0.191860465116279	33	0	19	1	85	116	4565039	4565071	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	33	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
21147376	21147376	PRJNA764222_S_NODE_4737_length_314_cov_1.704120_g4579_i0	PRJNA764222	4737	314	1.70412	5.3509368	Tenacibaculum todarodis	1850252	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1110849530\|gb\|CP018155.1\|	1850252	g4579	i0	94.286	0.111464968152866	35	2	11	0	125	159	1095264	1095230	Tenacibaculum todarodis strain LPB0136 chromosome, complete genome	blastn	35	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum todarodis

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