metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA937226" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA937226" 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
1255740	1255740	PRJNA937226_S_NODE_17301_length_197_cov_1.756757_g17174_i0	PRJNA937226	17301	197	1.756757	3.46081129	Hymenobacteraceae	1853232	Bacteria	Bacteria	315	1.9699999999999998e-81	NTclustered	gi\|887498678\|gb\|CP010777.1\|	1379910	g17174	i0	95.431	279.162436548223	197	9	100	0	1	197	2692430	2692234	Rufibacter sp. DG31D, complete genome	blastn	54995	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter radiotolerans
8564940	8564940	PRJNA937226_S_NODE_7207_length_272_cov_1.170404_g7080_i0	PRJNA937226	7207	272	1.170404	3.18349888	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2621786220\|emb\|OY782678.1\|	2030927	g7080	i0	100	0.102941176470588	28	0	10	0	239	266	2364385	2364412	MAG: Bacteroidales bacterium isolate 1f9300ae-d6db-4a26-8fb7-1be2ee45184d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
8908567	8908567	PRJNA937226_S_NODE_14687_length_210_cov_1.366460_g14560_i0	PRJNA937226	14687	210	1.36646	2.869566	Chryseobacterium	59732	Bacteria	Bacteria	385	1.5999999999999995e-102	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g14560	i0	100	521.933333333333	208	0	99	0	3	210	2943601	2943808	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	109606	388	0.992268041237113	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13665462	13665462	PRJNA937226_S_NODE_14591_length_210_cov_5.291925_g14464_i0	PRJNA937226	14591	210	5.291925	11.1130425	uncultured Bacteroidales bacterium	194843	Bacteria	Bacteria	139	1.38e-28	NTclustered	gi\|2729058746\|emb\|OZ007033.1\|	194843	g14464	i0	79.904	7.60952380952381	209	27	95	11	3	201	1232584	1232787	MAG: uncultured Bacteroidales bacterium isolate metabat2_pooled_hifiasm.1162 MAG genome assembly, chromosome: 1	blastn	1598	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			uncultured Bacteroidales bacterium
15283701	15283701	PRJNA937226_S_NODE_28012_length_163_cov_0.912281_g27885_i0	PRJNA937226	28012	163	0.912281	1.48701803	Dysgonomonas	156973	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1821115267\|gb\|CP049857.1\|	2714926	g27885	i0	99.387	275.601226993865	163	1	100	0	1	163	348145	348307	Dysgonomonas sp. HDW5A chromosome, complete genome	blastn	44923	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5A
17490252	17490252	PRJNA937226_S_NODE_8894_length_253_cov_2.725490_g8767_i0	PRJNA937226	8894	253	2.72549	6.8954897	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g8767	i0	99.605	259.292490118577	253	1	100	0	1	253	1744148	1743896	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	65601	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
22588890	22588890	PRJNA937226_S_NODE_14478_length_211_cov_2.296296_g14351_i0	PRJNA937226	14478	211	2.296296	4.84518456	Flavobacterium rivulicola	2732161	Bacteria	Bacteria	294	2.79e-75	NTclustered	gi\|2557550594\|gb\|CP121446.1\|	2732161	g14351	i0	92.271	618.113744075829	207	16	98	0	1	207	1110046	1109840	Flavobacterium rivulicola strain IMCC34852 chromosome, complete genome	blastn	130422	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rivulicola

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