metadata: contig_metadata: 4 rows where bioproject = "PRJNA1111077", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA1111077", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

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
19340577	19340577	PRJNA1111077_P_NODE_24516_length_271_cov_5.010101_g24295_i0	PRJNA1111077	24516	271	5.010101	13.57737371	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	248	2.95e-61	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g24295	i0	85.897	4.3542435424354196	234	31	86	2	39	271	885739	885971	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1180	248	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
21891582	21891582	PRJNA1111077_P_NODE_27218_length_262_cov_1.359788_g26997_i0	PRJNA1111077	27218	262	1.359788	3.56264456	Rhodothermia bacterium	2497633	Bacteria	Bacteria	99.4	3.68e-22	NR	MBN8589814.1	2497633	g26997	i0	66.7	1.43129770992366	63	21	72.1	0	2	190	386	448	MBN8589814.1 family 1 glycosylhydrolase [Rhodothermia bacterium]	diamond	375	99.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
28701341	28701341	PRJNA1111077_P_NODE_26647_length_264_cov_1.570681_g26426_i0	PRJNA1111077	26647	264	1.570681	4.14659784	Rubricoccus	907202	Bacteria	Bacteria	142	4.529999999999999e-37	NR	WP_143536710.1	716817	g26426	i0	79.3	4.77272727272727	87	18	98.9	0	2	262	571	657	WP_143536710.1 M36 family metallopeptidase [Rubricoccus marinus]	diamond	1260	142	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
31774419	31774419	PRJNA1111077_P_NODE_18917_length_290_cov_1.949309_g18696_i0	PRJNA1111077	18917	290	1.949309	5.6529961	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	140	3.79e-38	NR	HEX9951672.1	2838334	g18696	i0	57.4	1.40689655172414	136	18	99.3	1	3	290	14	149	HEX9951672.1 WG repeat-containing protein [Rubricoccaceae bacterium]	diamond	408	140	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium

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