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

7 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Candidatus Melainabacteria"

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_species
17300148	17300148	PRJNA743294_P_NODE_26834_length_319_cov_1.833333_g26378_i0	PRJNA743294	26834	319	1.833333	5.84833227	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	339	2.05e-88	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26378	i0	87.333	174.489028213166	300	32	93	6	23	319	3682353	3682057	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	55662	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
17300265	17300265	PRJNA743294_P_NODE_42214_length_262_cov_5.433862_g41758_i0	PRJNA743294	42214	262	5.433862	14.23671844	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	283	7.789999999999999e-72	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g41758	i0	86.957	97.0343511450382	253	31	96	2	11	262	3681454	3681203	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25423	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
21124445	21124445	PRJNA743294_P_NODE_12357_length_453_cov_2.115789_g11901_i0	PRJNA743294	12357	453	2.115789	9.58452417	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11901	i0	96.97	0.717439293598234	33	1	7	0	355	387	2336664	2336696	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	325	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22399473	22399473	PRJNA743294_P_NODE_28298_length_312_cov_1.100418_g27842_i0	PRJNA743294	28298	312	1.100418	3.43330416	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	243	1.61e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g27842	i0	80.818	158.144230769231	318	53	100	7	1	312	3681334	3681019	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49341	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22399545	22399545	PRJNA743294_P_NODE_38438_length_273_cov_2.300000_g37982_i0	PRJNA743294	38438	273	2.3	6.279	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	241	4.98e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g37982	i0	83.209	34.7619047619048	268	39	97	5	8	271	3682269	3682534	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9490	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22399632	22399632	PRJNA743294_P_NODE_5078_length_678_cov_2.624793_g4637_i0	PRJNA743294	5078	678	2.624793	17.79609654	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	898	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4637	i0	90.588	175.856932153392	680	61	100	3	1	678	3682258	3681580	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	119231	898	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23675055	23675055	PRJNA743294_P_NODE_34699_length_285_cov_2.882075_g34243_i0	PRJNA743294	34699	285	2.882075	8.21391375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	318	2.3499999999999991e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34243	i0	86.76	42.4631578947368	287	36	100	1	1	285	3679729	3680015	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	12102	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria 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);;