metadata: contig_metadata: 7 rows where bioproject = "PRJNA605033", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA605033", 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
1144773	1144773	PRJNA605033_P_NODE_127241_length_219_cov_5.701087_g125672_i0	PRJNA605033	127241	219	5.701087	12.48538053	Rubrivirga	1434037	Bacteria	Bacteria	244	2.98e-60	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g125672	i0	86.818	153.890410958904	220	28	100	1	1	219	1309214	1308995	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	33702	244	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
4409581	4409581	PRJNA605033_P_NODE_184804_length_172_cov_3.678832_g183235_i0	PRJNA605033	184804	172	3.678832	6.32759104	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g183235	i0	100	55.5697674418605	172	0	100	0	1	172	806233	806404	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	9558	318	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
9510452	9510452	PRJNA605033_P_NODE_193848_length_168_cov_2.706767_g192279_i0	PRJNA605033	193848	168	2.706767	4.54736856	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g192279	i0	94.118	182.779761904762	170	6	100	4	1	168	805524	805357	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	30707	255	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
13899880	13899880	PRJNA605033_P_NODE_86091_length_222_cov_2.294118_g84522_i0	PRJNA605033	86091	222	2.294118	5.09294196	Roseithermus	2893044	Bacteria	Bacteria	126	1.1399999999999999e-24	NTclustered	gi\|2893358395\|emb\|OZ220686.1\|	2306054	g84522	i0	97.297	126.716216216216	74	2	33	0	149	222	1667164	1667237	MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1	blastn	28131	126	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
24809216	24809216	PRJNA605033_P_NODE_52340_length_236_cov_2.213930_g50772_i0	PRJNA605033	52340	236	2.21393	5.2248748	Rhodothermales bacterium	2306054	Bacteria	Bacteria	298	2.46e-76	NTclustered	gi\|2893358427\|emb\|OZ220719.1\|	2306054	g50772	i0	89.7	89.9745762711864	233	24	99	0	4	236	2488722	2488490	MAG: Rhodothermales bacterium isolate dfa80fe1-3418-4a7a-9107-99a60459722b genome assembly, chromosome: 1	blastn	21234	298	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
25370921	25370921	PRJNA605033_P_NODE_10800_length_423_cov_2.672680_g9271_i0	PRJNA605033	10800	423	2.67268	11.3054364	Rhodocaloribacter	2893090	Bacteria	Bacteria	374	7.66e-99	NTclustered	gi\|2893358395\|emb\|OZ220686.1\|	2306054	g9271	i0	84.715	173.886524822695	386	46	91	11	2	384	1667255	1667630	MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1	blastn	73554	374	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30680137	30680137	PRJNA605033_P_NODE_124713_length_221_cov_1.709677_g123144_i0	PRJNA605033	124713	221	1.709677	3.77838617	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.9	0.0111	NR	MFQ5571675.1	2306054	g123144	i0	40.3	0.909502262443439	67	40	91	0	207	7	840	906	MFQ5571675.1 tetratricopeptide repeat protein [Rhodothermales bacterium]	diamond	201	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);;