metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA930380" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA930380" and tax_clade = "FCB group"

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
909312	909312	PRJNA930380_P_NODE_1061_length_583_cov_2.670588_g1008_i0	PRJNA930380	1061	583	2.670588	15.56952804	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1066	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g1008	i0	99.657	466.93653516295	583	2	100	0	1	583	1986355	1986937	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	272224	1066	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
4737714	4737714	PRJNA930380_P_NODE_13864_length_243_cov_0.905882_g13811_i0	PRJNA930380	13864	243	0.905882	2.20129326	Niabella ginsenosidivorans	1176587	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1033838715\|gb\|CP015772.1\|	1176587	g13811	i0	100	0.11522633744856	28	0	12	0	96	123	2659477	2659450	Niabella ginsenosidivorans strain BS26 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella ginsenosidivorans
4737737	4737737	PRJNA930380_P_NODE_1464_length_502_cov_1.668998_g1411_i0	PRJNA930380	1464	502	1.668998	8.37836996	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	784	0	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g1411	i0	94.821	446.56374501992	502	26	100	0	1	502	1236161	1236662	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	224175	784	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
9837244	9837244	PRJNA930380_P_NODE_10088_length_270_cov_1.467005_g10035_i0	PRJNA930380	10088	270	1.467005	3.9609135	Chryseobacterium endophyticum	1854762	Bacteria	Bacteria	481	2.66e-131	NTclustered	gi\|2731632474\|gb\|CP154834.1\|	1854762	g10035	i0	99.248	12.9481481481481	266	2	99	0	3	268	650063	649798	Chryseobacterium endophyticum strain OsEnb-ALM-A6 chromosome, complete genome	blastn	3496	481	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium endophyticum
13662924	13662924	PRJNA930380_P_NODE_1151_length_563_cov_3.132653_g1098_i0	PRJNA930380	1151	563	3.132653	17.63683639	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1027	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g1098	i0	99.644	101.312611012433	562	2	99	0	1	562	1875928	1875367	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	57039	1027	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
13663078	13663078	PRJNA930380_P_NODE_4571_length_306_cov_1.982833_g4518_i0	PRJNA930380	4571	306	1.982833	6.06746898	Prevotella sp.	59823	Bacteria	Bacteria	451	2.41e-122	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g4518	i0	93.464	536.591503267974	306	17	99	3	1	305	2303	2606	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	164197	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
17832416	17832416	PRJNA930380_P_NODE_11314_length_251_cov_0.882022_g11261_i0	PRJNA930380	11314	251	0.882022	2.21387522	Porphyromonas	836	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g11261	i0	90.157	473.155378486056	254	20	100	5	1	251	1546700	1546951	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	118762	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
17832423	17832423	PRJNA930380_P_NODE_1214_length_547_cov_1.829114_g1161_i0	PRJNA930380	1214	547	1.829114	10.00525358	Parabacteroides	375288	Bacteria	Bacteria	577	7.179999999999998e-160	NTclustered	gi\|2784334720\|gb\|CP165599.1\|	328812	g1161	i0	86.106	543.345521023766	547	63	99	11	1	539	4658937	4658396	Parabacteroides goldsteinii strain WXC08 chromosome, complete genome	blastn	297210	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
17832479	17832479	PRJNA930380_P_NODE_8474_length_280_cov_1.487923_g8421_i0	PRJNA930380	8474	280	1.487923	4.1661844	Bacteroides	816	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2759676791\|gb\|CP131538.1\|	338188	g8421	i0	100	0.2	28	0	10	0	119	146	120315	120288	Bacteroides finegoldii strain CL09T03C10 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides finegoldii

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