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

5 rows where bioproject = "PRJNA168635", 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
2915327	2915327	PRJNA168635_P_NODE_34763_length_153_cov_15.682692_g34347_i0	PRJNA168635	34763	153	15.682692	23.99451876	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	99	1.59e-16	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g34347	i0	87.5	24.8692810457516	88	7	58	4	49	136	808414	808497	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	3805	99	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
4191533	4191533	PRJNA168635_P_NODE_19384_length_184_cov_3.066667_g18968_i0	PRJNA168635	19384	184	3.066667	5.64266728	Rhodothermales bacterium	2306054	Bacteria	Bacteria	152	1.4999999999999995e-32	NTclustered	gi\|2891482048\|emb\|OZ219799.1\|	2306054	g18968	i0	85.333	171.369565217391	150	19	81	2	3	151	479945	480092	MAG: Rhodothermales bacterium isolate da3e7c24-c5f3-4507-9669-19e8aa5a93cb genome assembly, chromosome: 1	blastn	31532	152	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
4191665	4191665	PRJNA168635_P_NODE_28404_length_165_cov_6.879310_g27988_i0	PRJNA168635	28404	165	6.87931	11.3508615	Rhodothermales bacterium	2306054	Bacteria	Bacteria	143	7.96e-30	NTclustered	gi\|2621702557\|emb\|OY760427.1\|	2306054	g27988	i0	88.235	120.387878787879	119	14	72	0	29	147	5500902	5500784	MAG: Rhodothermales bacterium isolate 1504ddc0-b432-43e2-af37-a45191a88aeb genome assembly, chromosome: 1	blastn	19864	143	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
8017812	8017812	PRJNA168635_P_NODE_22127_length_176_cov_1.614173_g21711_i0	PRJNA168635	22127	176	1.614173	2.84094448	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	169	1.4099999999999998e-37	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g21711	i0	86.452	9.61363636363636	155	19	88	2	22	175	2557950	2558103	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	1692	169	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
27390180	27390180	PRJNA168635_P_NODE_31643_length_162_cov_1.814159_g31227_i0	PRJNA168635	31643	162	1.814159	2.93893758	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.9	0.00481	NR	MEQ9104330.1	2306054	g31227	i0	62.5	0.592592592592593	32	12	59.3	0	127	32	577	608	MEQ9104330.1 AGE family epimerase/isomerase [Rhodothermales bacterium]	diamond	96	43.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;