metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
1001907	1001907	PRJNA1011844_P_NODE_145581_length_251_cov_1.887640_g137002_i0	PRJNA1011844	145581	251	1.88764	4.7379764	Verrucomicrobiota	74201	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g137002	i0	89.627	45.1792828685259	241	22	96	3	2	242	2292	2055	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	11340	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
5258846	5258846	PRJNA1011844_P_NODE_124865_length_276_cov_4.448276_g116288_i0	PRJNA1011844	124865	276	4.448276	12.27724176	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g116288	i0	92.5	0.246376811594203	40	2	14	1	137	175	4227024	4226985	Opitutaceae bacterium TAV5, complete genome	blastn	68	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
6105067	6105067	PRJNA1011844_P_NODE_140805_length_256_cov_3.393443_g132227_i0	PRJNA1011844	140805	256	3.393443	8.68721408	Verrucomicrobiota	74201	Bacteria	Bacteria	322	1.61e-83	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g132227	i0	92.478	198.05859375	226	16	88	1	29	254	1618	1842	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	50703	324	0.993827160493827	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
6534564	6534564	PRJNA1011844_P_NODE_159566_length_242_cov_1.568047_g150986_i0	PRJNA1011844	159566	242	1.568047	3.79467374	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	202	2.0499999999999998e-47	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g150986	i0	83.784	30.4090909090909	222	27	90	7	4	221	3832288	3832504	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	7359	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7808495	7808495	PRJNA1011844_P_NODE_125267_length_276_cov_1.438424_g116690_i0	PRJNA1011844	125267	276	1.438424	3.97005024	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	267	8.33e-67	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g116690	i0	87.5	170.210144927536	232	28	84	1	46	276	2751068	2750837	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	46978	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7809719	7809719	PRJNA1011844_P_NODE_42147_length_730_cov_2.876712_g34241_i0	PRJNA1011844	42147	730	2.876712	20.9999976	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	706	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g34241	i0	84.658	279.649315068493	730	88	99	21	1	722	4718245	4718958	Luteolibacter sp. SL250 chromosome	blastn	204144	706	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
8655097	8655097	PRJNA1011844_P_NODE_151267_length_247_cov_2.632184_g142688_i0	PRJNA1011844	151267	247	2.632184	6.50149448	Luteolibacter	518753	Bacteria	Bacteria	152	2.1399999999999998e-32	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g142688	i0	87.692	37.2672064777328	130	16	53	0	30	159	266173	266044	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	9205	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
14184633	14184633	PRJNA1011844_P_NODE_131652_length_267_cov_3.793814_g123074_i0	PRJNA1011844	131652	267	3.793814	10.12948338	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|2442650069\|gb\|OQ422736.1\|	156588	g123074	i0	99.216	93.8277153558052	255	1	95	1	2	255	908	654	Uncultured Verrucomicrobia bacterium clone KCM_4_1_112 16S ribosomal RNA gene, partial sequence	blastn	25052	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15459119	15459119	PRJNA1011844_P_NODE_166293_length_234_cov_2.652174_g157712_i0	PRJNA1011844	166293	234	2.652174	6.20608716	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	374	3.94e-99	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g157712	i0	98.14	153.735042735043	215	3	92	1	9	223	3556185	3556398	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	35974	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15459437	15459437	PRJNA1011844_P_NODE_24813_length_1095_cov_7.752446_g18908_i0	PRJNA1011844	24813	1095	7.752446	84.889283699999993	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	56.5	0.009	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g18908	i0	100	0.0547945205479452	30	0	3	0	61	90	417619	417648	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	60	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15460022	15460022	PRJNA1011844_P_NODE_55033_length_572_cov_3.028056_g46698_i0	PRJNA1011844	55033	572	3.028056	17.32048032	Pedosphaera parvula	1032527	Bacteria	Bacteria	730	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g46698	i0	90.248	97.5052447552448	564	47	98	5	13	572	1459	900	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55773	730	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16732868	16732868	PRJNA1011844_P_NODE_124434_length_277_cov_1.985294_g115857_i0	PRJNA1011844	124434	277	1.985294	5.49926438	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	161	4.06e-35	NTclustered	gi\|1999103383\|gb\|CP066203.1\|	2796139	g115857	i0	78.599	72.072202166065	257	46	91	8	17	269	2070483	2070734	Methylacidimicrobium sp. B4 chromosome, complete genome	blastn	19964	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
18009739	18009739	PRJNA1011844_P_NODE_94395_length_344_cov_2.929889_g85833_i0	PRJNA1011844	94395	344	2.929889	10.07881816	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	322	2.25e-83	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g85833	i0	84.639	76.9040697674419	332	41	96	6	6	334	1389	1065	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	26455	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19281780	19281780	PRJNA1011844_P_NODE_147696_length_250_cov_0.870056_g139117_i0	PRJNA1011844	147696	250	0.870056	2.17514	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g139117	i0	96.875	0.24	32	1	13	0	23	54	2458216	2458185	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	60	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23108424	23108424	PRJNA1011844_P_NODE_138639_length_259_cov_1.543011_g130061_i0	PRJNA1011844	138639	259	1.543011	3.99639849	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	350	7.47e-92	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g130061	i0	94.372	143.436293436293	231	7	88	6	30	257	1315317	1315544	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	37150	350	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24381956	24381956	PRJNA1011844_P_NODE_120400_length_283_cov_1.400000_g111823_i0	PRJNA1011844	120400	283	1.4	3.962	Luteolibacter luteus	2728835	Bacteria	Bacteria	110	1.53e-19	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g111823	i0	88.764	124.212014134276	89	10	31	0	178	266	3804790	3804702	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	35152	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
25228537	25228537	PRJNA1011844_P_NODE_76480_length_417_cov_1.183140_g67978_i0	PRJNA1011844	76480	417	1.18314	4.9336938	Opitutaceae	134623	Bacteria	Bacteria	84.2	1.42e-11	NTclustered	gi\|226525261\|gb\|FJ872372.1\|	156588	g67978	i0	75.132	42.3189448441247	189	41	45	5	60	245	11481	11666	Uncultured Verrucomicrobia bacterium clone 106 genomic sequence	blastn	17647	84.2	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);;