metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_phylum = "Balneolota"

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_species
25601627	25601627	PRJNA816047d_S_NODE_131737_length_229_cov_1315.107955_g129902_i0	PRJNA816047	131737	229	1315.107955	3011.59721695	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	4.36e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g129902	i0	100	187.991266375546	40	0	17	0	18	57	2141	2102	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43050	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25738831	25738831	PRJNA816047d_S_NODE_192074_length_201_cov_3239.067568_g190239_i0	PRJNA816047	192074	201	3239.067568	6510.52581168	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	3.73e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g190239	i0	97.727	219.487562189055	44	0	21	1	19	61	2141	2098	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44117	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25740253	25740253	PRJNA816047d_S_NODE_40522_length_339_cov_65652.968531_g38687_i0	PRJNA816047	40522	339	65652.968531	222563.56332009	Balneolaceae bacterium	2053516	Bacteria	Bacteria	73.1	2.46e-8	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g38687	i0	93.878	119.047197640118	49	1	14	2	110	156	79	31	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	40357	73.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25741765	25741765	PRJNA816047d_S_NODE_67362_length_278_cov_725.142222_g65527_i0	PRJNA816047	67362	278	725.142222	2015.89537716	Balneolaceae bacterium	2053516	Bacteria	Bacteria	80.5	1.17e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g65527	i0	94.34	156.143884892086	53	1	19	2	208	260	2090	2140	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43408	80.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26147270	26147270	PRJNA816047d_S_NODE_209973_length_197_cov_68.236111_g208138_i0	PRJNA816047	209973	197	68.236111	134.42513867	Balneolaceae bacterium	2053516	Bacteria	Bacteria	75	3.64e-9	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g208138	i0	97.727	219.807106598985	44	0	22	1	144	187	2099	2141	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43302	75	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26150553	26150553	PRJNA816047d_S_NODE_77333_length_264_cov_5707.061611_g75498_i0	PRJNA816047	77333	264	5707.061611	15066.64265304	Balneolaceae bacterium	2053516	Bacteria	Bacteria	76.8	1.43e-9	NTclustered	gi\|2166246688\|dbj\|LC663154.1\|	2053516	g75498	i0	94.118	162.689393939394	51	1	19	2	194	243	10259	10308	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp1	blastn	42950	76.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26179900	26179900	PRJNA816047d_S_NODE_184277_length_203_cov_2544.800000_g182442_i0	PRJNA816047	184277	203	2544.8	5165.944	Pseudomonadati	3379134	Bacteria	Bacteria	71.3	4.88e-8	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g182442	i0	95.556	83.35960591133	45	0	22	2	27	70	38	81	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	16922	71.3	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26283059	26283059	PRJNA816047d_S_NODE_188278_length_202_cov_1943.865772_g186443_i0	PRJNA816047	188278	202	1943.865772	3926.60885944	Balneolaceae bacterium	2053516	Bacteria	Bacteria	78.7	2.9e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g186443	i0	100	223.029702970297	42	0	21	0	16	57	2143	2102	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	45052	78.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26555004	26555004	PRJNA816047d_S_NODE_191832_length_201_cov_7609.013514_g189997_i0	PRJNA816047	191832	201	7609.013514	15294.11716314	Balneolaceae bacterium	2053516	Bacteria	Bacteria	76.8	1.04e-9	NTclustered	gi\|2166246568\|dbj\|LC663148.1\|	2053516	g189997	i0	100	210.63184079602	41	0	20	0	141	181	78	38	Balneolaceae bacterium ARSSAG-00002351 DNA, putative prophage region, clone: 00002351_pp2	blastn	42337	76.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae 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);;