metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
2249291	2249291	PRJNA986481_P_NODE_9522_length_529_cov_19.095833_g9003_i0	PRJNA986481	9522	529	19.095833	101.01695657	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	706	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9003	i0	91.813	74.9848771266541	513	33	96	8	1	509	1315424	1314917	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	39667	706	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3523904	3523904	PRJNA986481_P_NODE_1863_length_1045_cov_68.939759_g352_i3	PRJNA986481	1863	1045	68.939759	720.42048155	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1218	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g352	i3	89.228	162.977033492823	984	93	93	10	41	1017	1316491	1315514	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	170311	1218	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4801325	4801325	PRJNA986481_P_NODE_26644_length_318_cov_1.724907_g26119_i0	PRJNA986481	26644	318	1.724907	5.48520426	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	375	1.5599999999999995e-99	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g26119	i0	88.125	51.1792452830189	320	33	100	5	1	318	3833122	3833438	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	16275	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6376103	6376103	PRJNA986481_P_NODE_1705_length_1076_cov_6.920156_g736_i2	PRJNA986481	1705	1076	6.920156	74.46087856	Opitutaceae	134623	Bacteria	Bacteria	1090	0	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g736	i2	88.116	95.3066914498141	934	89	86	15	150	1076	1422	504	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	102550	1090	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
6376145	6376145	PRJNA986481_P_NODE_2645_length_911_cov_7.353828_g736_i3	PRJNA986481	2645	911	7.353828	66.99337308	Verrucomicrobiota	74201	Bacteria	Bacteria	1360	0	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g736	i3	93.64	136.252469813392	912	54	100	4	1	911	504	1412	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	124126	1360	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
8626951	8626951	PRJNA986481_P_NODE_59687_length_241_cov_3.609375_g59162_i0	PRJNA986481	59687	241	3.609375	8.69859375	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	267	7.12e-67	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g59162	i0	88.688	175.626556016598	221	22	91	3	1	220	3989885	3989667	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	42326	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
9902227	9902227	PRJNA986481_P_NODE_9508_length_530_cov_1.767152_g8989_i0	PRJNA986481	9508	530	1.767152	9.3659056	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	339	3.5699999999999995e-88	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g8989	i0	82.443	1.74150943396226	393	63	73	4	2	388	5716299	5715907	Luteolibacter sp. Populi chromosome, complete genome	blastn	923	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
11177068	11177068	PRJNA986481_P_NODE_44249_length_259_cov_0.961905_g43724_i0	PRJNA986481	44249	259	0.961905	2.49133395	Luteolibacter luteus	2728835	Bacteria	Bacteria	318	2.11e-82	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g43724	i0	88.889	22.2895752895753	261	25	100	4	1	259	2316408	2316150	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	5773	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
11177246	11177246	PRJNA986481_P_NODE_55089_length_246_cov_27.812183_g54564_i0	PRJNA986481	55089	246	27.812183	68.41797018	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	351	1.96e-92	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g54564	i0	94.69	82.0243902439024	226	12	92	0	1	226	3557830	3558055	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	20178	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12452941	12452941	PRJNA986481_P_NODE_450_length_1631_cov_48.512010_g352_i0	PRJNA986481	450	1631	48.51201	791.2308831	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1881	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g352	i0	88.306	156.315757204169	1582	167	96	15	41	1611	1316491	1314917	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	254951	1881	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13726837	13726837	PRJNA986481_P_NODE_12671_length_460_cov_8.381995_g12147_i0	PRJNA986481	12671	460	8.381995	38.557177	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g12147	i0	100	0.132608695652174	30	0	7	0	71	100	2857683	2857712	Opitutaceae bacterium TAV5, complete genome	blastn	61	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
13727653	13727653	PRJNA986481_P_NODE_911_length_1348_cov_9.161663_g736_i0	PRJNA986481	911	1348	9.161663	123.49921724	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	2102	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g736	i0	94.819	87.799703264095	1351	64	100	5	1	1348	3556184	3557531	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	118354	2102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15001094	15001094	PRJNA986481_P_NODE_1052_length_1274_cov_12.088980_g736_i1	PRJNA986481	1052	1274	12.08898	154.0136052	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	1973	0	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g736	i1	94.662	89.2794348508634	1274	64	99	3	3	1274	2557994	2556723	Lacunisphaera limnophila strain IG16b, complete genome	blastn	113742	1973	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
15001398	15001398	PRJNA986481_P_NODE_28432_length_307_cov_3.879845_g27907_i0	PRJNA986481	28432	307	3.879845	11.91112415	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	529	1.0899999999999996e-145	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g27907	i0	97.72	99.599348534202	307	7	100	0	1	307	1438	1132	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	30577	529	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15299972	15299972	PRJNA986481_P_NODE_31712_length_290_cov_1.983402_g31187_i0	PRJNA986481	31712	290	1.983402	5.7518658	Bacteria	2	Bacteria	Bacteria	263	1.14e-65	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g31187	i0	89.252	61.7931034482759	214	18	73	5	1	211	2749648	2749859	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	17920	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17551932	17551932	PRJNA986481_P_NODE_9014_length_542_cov_81.981744_g352_i4	PRJNA986481	9014	542	81.981744	444.34105248	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	662	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g352	i4	90.514	85.7214022140221	506	41	93	5	41	542	1316491	1315989	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	46461	662	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18825329	18825329	PRJNA986481_P_NODE_34975_length_276_cov_1.841410_g34450_i0	PRJNA986481	34975	276	1.84141	5.0822916	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	368	2.22e-97	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g34450	i0	90.714	28.0652173913043	280	20	100	6	1	276	3832757	3832480	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	7746	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18825495	18825495	PRJNA986481_P_NODE_455_length_1625_cov_72.541878_g352_i1	PRJNA986481	455	1625	72.541878	1178.8055175	Fontisphaera persica	2974023	Bacteria	Bacteria	1659	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g352	i1	85.599	133.198769230769	1611	199	98	28	22	1611	3861031	3862629	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	216448	1659	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
18825820	18825820	PRJNA986481_P_NODE_9595_length_527_cov_10.991632_g9076_i0	PRJNA986481	9595	527	10.991632	57.92590064	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	584	4.119999999999998e-162	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g9076	i0	87.698	175.764705882353	504	58	95	3	1	502	503	2	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	92628	584	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
21375925	21375925	PRJNA986481_P_NODE_49517_length_253_cov_0.990196_g48992_i0	PRJNA986481	49517	253	0.990196	2.50519588	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	202	2.15e-47	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g48992	i0	88.957	34.7667984189723	163	18	64	0	19	181	4127480	4127318	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	8796	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22650820	22650820	PRJNA986481_P_NODE_458_length_1623_cov_46.689327_g352_i2	PRJNA986481	458	1623	46.689327	757.76777721	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1714	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g352	i2	86.519	133.920517560074	1580	187	96	22	41	1602	1316491	1314920	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	217353	1714	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;