metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
199076	199076	PRJNA1093380_P_NODE_13881_length_247_cov_1.729885_g13775_i0	PRJNA1093380	13881	247	1.729885	4.27281595	Opitutus terrae	107709	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g13775	i0	84.274	11.2550607287449	248	34	100	4	1	247	3507688	3507445	Opitutus terrae PB90-1, complete genome	blastn	2780	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
199131	199131	PRJNA1093380_P_NODE_17501_length_235_cov_2.191358_g17395_i0	PRJNA1093380	17501	235	2.191358	5.1496913	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	398	2.349999999999999e-106	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g17395	i0	99.095	299.442553191489	221	2	94	0	15	235	27211	27431	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	70369	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5301918	5301918	PRJNA1093380_P_NODE_12005_length_251_cov_0.865169_g11899_i0	PRJNA1093380	12005	251	0.865169	2.17157419	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	422	1.4999999999999998e-113	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g11899	i0	97.189	240.02390438247	249	7	99	0	3	251	915172	915420	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	60246	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6577101	6577101	PRJNA1093380_P_NODE_3046_length_345_cov_1.794118_g2940_i0	PRJNA1093380	3046	345	1.794118	6.1897071	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	571	2.0299999999999996e-158	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g2940	i0	96.522	90.4376811594203	345	12	100	0	1	345	27753	27409	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	31201	571	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
7851880	7851880	PRJNA1093380_P_NODE_307_length_1025_cov_2.407563_g234_i0	PRJNA1093380	307	1025	2.407563	24.67752075	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1485	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g234	i0	93.113	83.8546341463415	1031	44	100	13	1	1025	1315791	1316800	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	85951	1485	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11677723	11677723	PRJNA1093380_P_NODE_1430_length_462_cov_2.290488_g1325_i0	PRJNA1093380	1430	462	2.290488	10.58205456	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	776	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1325	i0	96.97	211.5670995671	462	14	100	0	1	462	5153307	5152846	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	97744	776	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16776254	16776254	PRJNA1093380_P_NODE_2294_length_382_cov_1.983819_g2188_i0	PRJNA1093380	2294	382	1.983819	7.57818858	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	544	4.93e-150	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2188	i0	94.828	112.973821989529	348	18	91	0	1	348	1315425	1315078	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	43156	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16776326	16776326	PRJNA1093380_P_NODE_7254_length_277_cov_1.965686_g7148_i0	PRJNA1093380	7254	277	1.965686	5.44495022	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	255	1.81e-63	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g7148	i0	83.509	2.05054151624549	285	35	99	6	2	277	2924625	2924344	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	568	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18870808	18870808	PRJNA1093380_P_NODE_2575_length_366_cov_1.443686_g2469_i0	PRJNA1093380	2575	366	1.443686	5.28389076	Luteolibacter	518753	Bacteria	Bacteria	571	2.1599999999999996e-158	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g2469	i0	94.809	258.713114754098	366	19	100	0	1	366	1008768	1009133	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	94689	571	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
20600218	20600218	PRJNA1093380_P_NODE_3597_length_325_cov_1.519841_g3491_i0	PRJNA1093380	3597	325	1.519841	4.93948325	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	383	9.53e-102	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3491	i0	88.11	166.230769230769	328	32	99	7	3	325	1315544	1315219	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	54025	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21875991	21875991	PRJNA1093380_P_NODE_1898_length_412_cov_2.477876_g1792_i0	PRJNA1093380	1898	412	2.477876	10.20884912	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	706	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1792	i0	97.573	215.06067961165	412	10	100	0	1	412	26240	25829	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	88605	706	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21876019	21876019	PRJNA1093380_P_NODE_4818_length_295_cov_1.265766_g4712_i0	PRJNA1093380	4818	295	1.265766	3.7340097	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	392	1.4199999999999998e-104	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g4712	i0	91.096	7.63050847457627	292	22	98	3	6	295	3334	3623	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	2251	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21876024	21876024	PRJNA1093380_P_NODE_5098_length_291_cov_1.059633_g4992_i0	PRJNA1093380	5098	291	1.059633	3.08353203	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.7600000000000003e-123	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g4992	i0	94.845	10.0549828178694	291	15	100	0	1	291	5153951	5153661	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	2926	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23151571	23151571	PRJNA1093380_P_NODE_919_length_577_cov_2.222222_g816_i0	PRJNA1093380	919	577	2.222222	12.82222094	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	983	0	NTclustered	gi\|220682213\|gb\|FJ542820.1\|	100234	g816	i0	97.405	98.6395147313691	578	13	100	2	1	577	580	4	Uncultured Verrucomicrobiales bacterium clone A02-04D 16S ribosomal RNA gene, partial sequence	blastn	56915	983	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
24425076	24425076	PRJNA1093380_P_NODE_360_length_941_cov_1.710829_g280_i0	PRJNA1093380	360	941	1.710829	16.09890089	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1408	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g280	i0	93.737	222.959617428268	942	54	99	5	1	940	28646	27708	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	209805	1408	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;