metadata: contig_metadata: 4 rows where bioproject = "PRJNA1122875" and tax

4 rows where bioproject = "PRJNA1122875" 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
6655653	6655653	PRJNA1122875_P_NODE_45986_length_248_cov_1.702857_g45762_i0	PRJNA1122875	45986	248	1.702857	4.22308536	Bacteria	2	Bacteria	Bacteria	115	8.36e-28	NR	HYE56995.1	2306054	g45762	i0	72	4.95967741935484	82	22	99.2	1	247	2	500	580	HYE56995.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Rhodothermales bacterium]	diamond	1230	115	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
11232182	11232182	PRJNA1122875_P_NODE_9609_length_532_cov_3.893246_g9390_i0	PRJNA1122875	9609	532	3.893246	20.71206872	FCB group	1783270	Bacteria	Bacteria	84.2	1.85e-11	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g9390	i0	86.076	11.6109022556391	79	9	15	2	94	171	3342121	3342198	Salinibacter ruber strain P13 chromosome, complete genome	blastn	6177	84.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
20679324	20679324	PRJNA1122875_P_NODE_52357_length_242_cov_0.911243_g52133_i0	PRJNA1122875	52357	242	0.911243	2.20520806	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	207	4.4e-49	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g52133	i0	86.082	3.94214876033058	194	25	80	2	50	242	4236131	4235939	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	954	207	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
29059705	29059705	PRJNA1122875_P_NODE_11768_length_485_cov_1.618932_g11546_i0	PRJNA1122875	11768	485	1.618932	7.8518202	Rhodothermus bifroesti	2823335	Bacteria	Bacteria	147	1.6799999999999999e-40	NR	WP_210376410.1	2823335	g11546	i0	44.2	1.02061855670103	165	87	99	2	484	5	66	230	WP_210376410.1 GH12 family glycosyl hydrolase domain-containing protein [Rhodothermus bifroesti]	diamond	495	147	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus bifroesti

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