metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax_phylum = "Verrucomicrobiota"

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
3670659	3670659	PRJNA546018_S_NODE_8283_length_612_cov_2.010889_g7972_i0	PRJNA546018	8283	612	2.010889	12.30664068	Verrucomicrobiota	74201	Bacteria	Bacteria	946	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g7972	i0	96.075	103.392156862745	586	14	95	6	6	585	5153531	5152949	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	63276	952	0.993697478991597	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6888568	6888568	PRJNA546018_S_NODE_2926_length_1092_cov_12.659554_g2741_i0	PRJNA546018	2926	1092	12.659554	138.24232968	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1164	0	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g2741	i0	86.397	168.71978021978	1088	121	98	26	20	1092	2168185	2169260	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	184242	1164	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9439703	9439703	PRJNA546018_S_NODE_55788_length_204_cov_2.853147_g55463_i0	PRJNA546018	55788	204	2.853147	5.82041988	Actomonas aquatica	2866162	Bacteria	Bacteria	152	1.71e-32	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g55463	i0	81.967	21.7696078431373	183	30	89	3	23	203	3833904	3834085	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	4441	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
10715051	10715051	PRJNA546018_S_NODE_30469_length_284_cov_3.044843_g30144_i0	PRJNA546018	30469	284	3.044843	8.64735412	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	374	4.93e-99	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g30144	i0	92.366	47.6971830985916	262	20	92	0	2	263	513332	513071	Lacunisphaera limnophila strain IG16b, complete genome	blastn	13546	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
11989431	11989431	PRJNA546018_S_NODE_12710_length_474_cov_4.426150_g12386_i0	PRJNA546018	12710	474	4.42615	20.979951	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	302	4.15e-77	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g12386	i0	79.186	1.11814345991561	442	86	93	5	22	460	1270089	1270527	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	530	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
15813751	15813751	PRJNA546018_S_NODE_33193_length_270_cov_3.095694_g32868_i0	PRJNA546018	33193	270	3.095694	8.3583738	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	333	7.8899999999999995e-87	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g32868	i0	91.358	2.6037037037037	243	21	90	0	7	249	3492672	3492430	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	703	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
19637243	19637243	PRJNA546018_S_NODE_39796_length_244_cov_1.546448_g39471_i0	PRJNA546018	39796	244	1.546448	3.77333312	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g39471	i0	97.872	175.561475409836	235	5	96	0	10	244	501	735	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	42837	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22187676	22187676	PRJNA546018_S_NODE_26538_length_308_cov_2.906883_g26213_i0	PRJNA546018	26538	308	2.906883	8.95319964	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	326	1.53e-84	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g26213	i0	87.197	19.0097402597403	289	33	93	4	22	308	2630169	2630455	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	5855	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368

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