metadata: contig_metadata: 5 rows where bioproject = "PRJNA330616", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA330616", 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
4897367	4897367	PRJNA330616_P_NODE_9544_length_269_cov_1.222727_g9135_i0	PRJNA330616	9544	269	1.222727	3.28913563	Rubrivirga	1434037	Bacteria	Bacteria	309	1.32e-79	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g9135	i0	87.454	8.65055762081784	271	31	100	3	1	269	805887	805618	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	2327	309	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15097114	15097114	PRJNA330616_P_NODE_14992_length_215_cov_3.704819_g14583_i0	PRJNA330616	14992	215	3.704819	7.96536085	Pseudomonadati	3379134	Bacteria	Bacteria	200	6.4e-47	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g14583	i0	84.653	161.344186046512	202	30	94	1	12	213	2903916	2904116	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	34689	200	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
15692281	15692281	PRJNA330616_P_NODE_18593_length_195_cov_1.547945_g18184_i0	PRJNA330616	18593	195	1.547945	3.01849275	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g18184	i0	94.924	213.4	197	7	100	3	1	195	806378	806573	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	41613	305	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
22066105	22066105	PRJNA330616_P_NODE_22698_length_177_cov_1.984375_g22289_i0	PRJNA330616	22698	177	1.984375	3.51234375	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	272	1.0499999999999998e-68	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g22289	i0	94.382	280.361581920904	178	8	100	2	1	177	1307792	1307616	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	49624	272	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
24615768	24615768	PRJNA330616_P_NODE_21480_length_182_cov_1.992481_g21071_i0	PRJNA330616	21480	182	1.992481	3.62631542	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	261	2.36e-65	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g21071	i0	93.678	315.043956043956	174	11	96	0	9	182	3833047	3832874	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	57338	261	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206

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