metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA891846" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA891846" 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
5071107	5071107	PRJNA891846_P_NODE_1204_length_1204_cov_4.015031_g1096_i0	PRJNA891846	1204	1204	4.015031	48.34097324	Chryseobacterium	59732	Bacteria	Bacteria	2180	0	NTclustered	gi\|1494289966\|gb\|CP033070.1\|	2478663	g1096	i0	99.336	503.901993355482	1204	8	100	0	1	1204	1908455	1907252	Chryseobacterium sp. 3008163 chromosome, complete genome	blastn	606698	2185	0.997711670480549	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 3008163
11446909	11446909	PRJNA891846_P_NODE_45869_length_242_cov_0.928994_g45649_i0	PRJNA891846	45869	242	0.928994	2.24816548	Flectobacillaceae	3141701	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|61097596\|emb\|AJ746140.1\|	280934	g45649	i0	100	102	242	0	100	0	1	242	1299	1058	Arcicella sp. MG83 partial 16S rRNA gene, isolate MG83	blastn	24684	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Arcicella	Arcicella sp. MG83
19094595	19094595	PRJNA891846_P_NODE_20935_length_334_cov_1.363985_g20716_i0	PRJNA891846	20935	334	1.363985	4.5557099	Chitinophagaceae	563835	Bacteria	Bacteria	556	5.469999999999999e-154	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g20716	i0	96.707	222.988023952096	334	11	100	0	1	334	1673151	1672818	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	74478	556	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
20369439	20369439	PRJNA891846_P_NODE_22636_length_321_cov_0.887097_g22417_i0	PRJNA891846	22636	321	0.887097	2.84758137	Algoriphagus	246875	Bacteria	Bacteria	492	1.4999999999999995e-134	NTclustered	gi\|2797090529\|gb\|CP146486.1\|	226505	g22417	i0	94.654	260.931464174455	318	15	98	2	2	317	1482189	1482506	Algoriphagus halophilus strain SOCE003 chromosome, complete genome	blastn	83759	492	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus halophilus
25093308	25093308	PRJNA891846_P_NODE_37300_length_251_cov_0.865169_g37080_i0	PRJNA891846	37300	251	0.865169	2.17157419	Dysgonomonas capnocytophagoides	45254	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2574691227\|dbj\|AP028867.1\|	45254	g37080	i0	100	0.111553784860558	28	0	11	0	32	59	3418298	3418271	Dysgonomonas capnocytophagoides SMU001 DNA, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas capnocytophagoides

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