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

7 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Kapaibacteriota"

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
524303	524303	PRJNA556992_P_NODE_136501_length_368_cov_4.837288_g134314_i0	PRJNA556992	136501	368	4.837288	17.80121984	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2621704217\|emb\|OY761611.1\|	2447898	g134314	i0	100	0.244565217391304	28	0	8	0	96	123	1397216	1397243	MAG: Candidatus Kapabacteria bacterium isolate 963550f5-4d88-4eb0-99f7-25ebda648600 genome assembly, chromosome: 1	blastn	90	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
5638941	5638941	PRJNA556992_P_NODE_950005_length_235_cov_6.685185_g947815_i0	PRJNA556992	950005	235	6.685185	15.71018475	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	174	4.31e-39	NTclustered	gi\|2621703255\|emb\|OY762428.1\|	2447898	g947815	i0	81.364	101.948936170213	220	35	92	5	12	228	2511275	2511059	MAG: Candidatus Kapabacteria bacterium isolate a44c304e-2480-4604-92e3-6035b9b042d9 genome assembly, chromosome: 1	blastn	23958	174	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
9458780	9458780	PRJNA556992_P_NODE_564788_length_261_cov_22.106383_g562599_i0	PRJNA556992	564788	261	22.106383	57.69765963	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	158	4.9000000000000005e-34	NTclustered	gi\|2518551211\|emb\|OX638338.1\|	2447898	g562599	i0	80.822	4.07662835249042	219	26	81	9	1	212	1104340	1104549	MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1	blastn	1064	158	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
10739222	10739222	PRJNA556992_P_NODE_95169_length_411_cov_3.792899_g92985_i0	PRJNA556992	95169	411	3.792899	15.58881489	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	429	1.56e-115	NTclustered	gi\|2907625638\|emb\|OZ223198.1\|	2447898	g92985	i0	85.577	80.9683698296837	416	52	100	6	1	411	1118211	1117799	MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 2	blastn	33278	429	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
15826022	15826022	PRJNA556992_P_NODE_1114853_length_209_cov_5.727941_g1112662_i0	PRJNA556992	1114853	209	5.727941	11.97139669	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	154	4.88e-33	NTclustered	gi\|2518551211\|emb\|OX638338.1\|	2447898	g1112662	i0	80.095	46.2822966507177	211	39	99	3	1	208	2781101	2781311	MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1	blastn	9673	154	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
15834437	15834437	PRJNA556992_P_NODE_67253_length_460_cov_3.245478_g65080_i0	PRJNA556992	67253	460	3.245478	14.9291988	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	518	3.66e-142	NTclustered	gi\|2518551211\|emb\|OX638338.1\|	2447898	g65080	i0	87.528	243.547826086957	449	54	97	1	1	447	2780479	2780927	MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1	blastn	112032	518	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
23475690	23475690	PRJNA556992_P_NODE_1119739_length_208_cov_5.318519_g1117548_i0	PRJNA556992	1119739	208	5.318519	11.06251952	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	244	2.8e-60	NTclustered	gi\|2518551211\|emb\|OX638338.1\|	2447898	g1117548	i0	87.981	197.086538461538	208	23	99	2	1	207	2780358	2780564	MAG: Candidatus Kapabacteria bacterium isolate 9634bca7-0036-4470-acfa-8c32e30c46ef genome assembly, chromosome: 1	blastn	40994	244	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.

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