metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
3146737	3146737	PRJNA615351_P_NODE_65723_length_539_cov_12.763889_g52058_i0	PRJNA615351	65723	539	12.763889	68.79736171	Rhodothermales bacterium	2306054	Bacteria	Bacteria	652	0	NTclustered	gi\|2621703415\|emb\|OY762508.1\|	2306054	g52058	i0	88.704	216.317254174397	540	54	99	6	1	537	2026131	2026666	MAG: Rhodothermales bacterium isolate 68d32973-4033-4094-87ac-516b823d41a0 genome assembly, chromosome: 1	blastn	116595	652	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
10078441	10078441	PRJNA615351_P_NODE_146628_length_195_cov_1.575000_g132528_i0	PRJNA615351	146628	195	1.575	3.07125	Salinibacter	146918	Bacteria	Bacteria	60.2	1.01e-4	NTclustered	gi\|1419235469\|gb\|CP030716.1\|	146919	g132528	i0	100	1.64102564102564	32	0	16	0	5	36	681426	681457	Salinibacter ruber strain P13 chromosome, complete genome	blastn	320	60.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter ruber
12074804	12074804	PRJNA615351_P_NODE_116970_length_258_cov_27.695067_g102871_i0	PRJNA615351	116970	258	27.695067	71.45327286	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	375	1.2299999999999998e-99	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g102871	i0	93.676	368.143410852713	253	12	97	4	3	253	805928	806178	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	94981	375	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15898392	15898392	PRJNA615351_P_NODE_120593_length_248_cov_20.849765_g106493_i0	PRJNA615351	120593	248	20.849765	51.7074172	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	366	7.05e-97	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g106493	i0	93.852	468.173387096774	244	14	98	1	1	243	805935	806178	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	116107	366	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15898762	15898762	PRJNA615351_P_NODE_54133_length_669_cov_3.479495_g41502_i0	PRJNA615351	54133	669	3.479495	23.27782155	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g41502	i0	96.97	0.0493273542600897	33	0	5	1	281	312	2845458	2845426	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	33	54.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
20276370	20276370	PRJNA615351_P_NODE_140016_length_206_cov_1.912281_g125916_i0	PRJNA615351	140016	206	1.912281	3.93929886	Rubrivirga	1434037	Bacteria	Bacteria	289	1.26e-73	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g125916	i0	92.233	832.966019417476	206	13	99	3	1	205	807006	807209	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	171591	289	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25376336	25376336	PRJNA615351_P_NODE_158720_length_178_cov_1.776224_g144620_i0	PRJNA615351	158720	178	1.776224	3.16167872	Rubrivirga	1434037	Bacteria	Bacteria	235	1.39e-57	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g144620	i0	91.279	123.573033707865	172	15	97	0	1	172	805866	805695	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	21996	235	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871

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