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

5 rows where analysis = "blastn", bioproject = "PRJNA951388" 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
4763128	4763128	PRJNA951388_S_NODE_9544_length_269_cov_1.903061_g9417_i0	PRJNA951388	9544	269	1.903061	5.11923409	Flexibacter flexilis	998	Bacteria	Bacteria	279	1.04e-70	NTclustered	gi\|38374131\|gb\|M62806.2\|FBCRRL	927664	g9417	i0	87.654	253.494423791822	243	25	89	4	1	240	112	352	Flexibacter flexilis large subunit ribosomal RNA gene, partial sequence	blastn	68190	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	Flexibacter flexilis
11466541	11466541	PRJNA951388_S_NODE_3589_length_423_cov_4.425714_g3462_i0	PRJNA951388	3589	423	4.425714	18.72077022	Lutibacter	358023	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2919513563\|emb\|OZ238267.1\|	1871037	g3462	i0	100	0.132387706855792	28	0	7	0	97	124	1479933	1479960	MAG: Flavobacteriaceae bacterium isolate 09b6b137-068c-45fe-842c-bd307207bc05 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
14016622	14016622	PRJNA951388_S_NODE_6891_length_324_cov_2.454183_g6764_i0	PRJNA951388	6891	324	2.454183	7.95155292	Mucilaginibacter	423349	Bacteria	Bacteria	588	1.88e-163	NTclustered	gi\|1850321202\|gb\|CP054139.1\|	2740462	g6764	i0	99.385	403.685185185185	325	1	100	1	1	324	1171811	1171487	Mucilaginibacter mali strain G2-14 chromosome, complete genome	blastn	130794	593	0.991568296795953	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter mali
14016623	14016623	PRJNA951388_S_NODE_7711_length_305_cov_3.297414_g7584_i0	PRJNA951388	7711	305	3.297414	10.0571127	Bergeyella	59735	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|1566846313\|dbj\|LC460817.1\|	1015	g7584	i0	100	103.062295081967	305	0	100	0	1	305	567	263	Bergeyella zoohelcum 26-5 gene for 16S ribosomal RNA, partial sequence	blastn	31434	564	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella zoohelcum
14016624	14016624	PRJNA951388_S_NODE_9231_length_275_cov_2.009901_g9104_i0	PRJNA951388	9231	275	2.009901	5.52722775	Aquimarina	290174	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2261239293\|emb\|OX030782.1\|	1191912	g9104	i0	100	0.203636363636364	28	0	10	0	177	204	3383349	3383376	Aquimarina sp. Aq107 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. Aq107

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