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

7 rows where analysis = "blastn", bioproject = "PRJNA492363" 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
25565877	25565877	PRJNA492363_S_NODE_14817_length_260_cov_1.854271_g13996_i0	PRJNA492363	14817	260	1.854271	4.8211046	Balneolaceae bacterium	2053516	Bacteria	Bacteria	93.5	1.4e-14	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g13996	i0	100	144.180769230769	50	0	19	0	1	50	2213	2262	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	37487	93.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25566180	25566180	PRJNA492363_S_NODE_29809_length_241_cov_2.027778_g28988_i0	PRJNA492363	29809	241	2.027778	4.88694498	Balneolaceae bacterium	2053516	Bacteria	Bacteria	89.8	1.65e-13	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g28988	i0	96.364	183.846473029046	55	1	23	1	1	55	2211	2264	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44307	89.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25837990	25837990	PRJNA492363_S_NODE_12299_length_279_cov_1.256881_g11478_i0	PRJNA492363	12299	279	1.256881	3.50669799	Balneolaceae bacterium	2053516	Bacteria	Bacteria	89.8	1.96e-13	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g11478	i0	98.039	134.204301075269	51	1	18	0	1	51	2214	2264	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	37443	89.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25838553	25838553	PRJNA492363_S_NODE_4019_length_442_cov_1.753281_g3198_i0	PRJNA492363	4019	442	1.753281	7.74950202	Balneolaceae bacterium	2053516	Bacteria	Bacteria	78.7	7.05e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g3198	i0	100	166.966063348416	42	0	17	0	1	42	2222	2263	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	73799	78.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
25975293	25975293	PRJNA492363_S_NODE_76956_length_218_cov_1.267516_g76135_i0	PRJNA492363	76956	218	1.267516	2.76318488	Balneolaceae bacterium	2053516	Bacteria	Bacteria	102	1.89e-17	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g76135	i0	98.276	202.353211009174	58	1	27	0	161	218	2268	2211	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	44113	102	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26382945	26382945	PRJNA492363_S_NODE_4927_length_403_cov_2.403509_g4106_i0	PRJNA492363	4927	403	2.403509	9.68614127	Balneolaceae bacterium	2053516	Bacteria	Bacteria	102	3.78e-17	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g4106	i0	98.276	119.920595533499	58	1	14	0	346	403	2262	2205	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	48328	102	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneolaceae bacterium
26520067	26520067	PRJNA492363_S_NODE_9704_length_309_cov_0.911290_g8883_i0	PRJNA492363	9704	309	0.91129	2.8158861	Balneolaceae bacterium	2053516	Bacteria	Bacteria	78.7	4.76e-10	NTclustered	gi\|2166246313\|dbj\|LC663133.1\|	2053516	g8883	i0	100	139.734627831715	42	0	14	0	265	306	2100	2141	Balneolaceae bacterium ARSSAG-00002149 DNA, putative prophage region, clone: 00002149_pp2	blastn	43178	78.7	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);;