metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA404067" 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
414662	414662	PRJNA404067_P_NODE_33521_length_206_cov_1.420690_g33134_i0	PRJNA404067	33521	206	1.42069	2.9266214	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	169	1.71e-37	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g33134	i0	81.463	0.995145631067961	205	38	99	0	1	205	6643370	6643574	Opitutaceae bacterium TAV5, complete genome	blastn	205	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
1689489	1689489	PRJNA404067_P_NODE_29902_length_211_cov_3.213333_g29515_i0	PRJNA404067	29902	211	3.213333	6.78013263	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	283	6.039999999999999e-72	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g29515	i0	90.995	112.900473933649	211	17	100	2	1	211	3991802	3992010	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	23822	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
3631940	3631940	PRJNA404067_P_NODE_10443_length_336_cov_7.876364_g10058_i0	PRJNA404067	10443	336	7.876364	26.46458304	Pseudomonadati	3379134	Bacteria	Bacteria	405	2.11e-108	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g10058	i0	88.462	27.1279761904762	338	36	100	3	1	336	405209	404873	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	9115	405	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4241482	4241482	PRJNA404067_P_NODE_12264_length_301_cov_1.091667_g11878_i0	PRJNA404067	12264	301	1.091667	3.28591767	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	453	6.57e-123	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g11878	i0	93.75	287.445182724253	304	16	100	3	1	301	2310	2007	Luteolibacter sp. SL250 chromosome	blastn	86521	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9343043	9343043	PRJNA404067_P_NODE_42128_length_188_cov_2.519685_g41741_i0	PRJNA404067	42128	188	2.519685	4.7370078	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	265	1.9000000000000001e-66	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g41741	i0	92.105	140.228723404255	190	11	100	3	1	188	2558367	2558180	Lacunisphaera limnophila strain IG16b, complete genome	blastn	26363	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
10618333	10618333	PRJNA404067_P_NODE_13209_length_288_cov_1.466960_g12822_i0	PRJNA404067	13209	288	1.46696	4.2248448	Luteolibacter sp.	1962973	Bacteria	Bacteria	381	2.9899999999999995e-101	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g12822	i0	91.398	92.4201388888889	279	22	97	2	1	278	1010101	1010378	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	26617	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
10618784	10618784	PRJNA404067_P_NODE_40589_length_194_cov_4.451128_g40202_i0	PRJNA404067	40589	194	4.451128	8.63518832	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	320	4.16e-83	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g40202	i0	96.392	186.159793814433	194	7	100	0	1	194	547	354	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	36115	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13168191	13168191	PRJNA404067_P_NODE_14971_length_268_cov_1.743961_g14584_i0	PRJNA404067	14971	268	1.743961	4.67381548	Fontisphaera persica	2974023	Bacteria	Bacteria	344	3.61e-90	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g14584	i0	91.27	16.9850746268657	252	22	94	0	1	252	3862267	3862518	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	4552	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
13834861	13834861	PRJNA404067_P_NODE_29811_length_212_cov_0.748344_g29424_i0	PRJNA404067	29811	212	0.748344	1.58648928	Luteolibacter	518753	Bacteria	Bacteria	309	1e-79	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g29424	i0	92.925	289	212	15	100	0	1	212	2217524	2217313	Luteolibacter sp. LG18 DNA, complete genome	blastn	61268	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
15717115	15717115	PRJNA404067_P_NODE_14833_length_269_cov_2.985577_g14446_i0	PRJNA404067	14833	269	2.985577	8.03120213	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	335	2.18e-87	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g14446	i0	89.474	80.003717472119	266	26	99	2	1	265	3832592	3832328	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	21521	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15717551	15717551	PRJNA404067_P_NODE_41633_length_190_cov_2.170543_g41246_i0	PRJNA404067	41633	190	2.170543	4.1240317	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	348	1.86e-91	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g41246	i0	100	0.989473684210526	188	0	99	0	3	190	4599582	4599395	Luteolibacter sp. SL250 chromosome	blastn	188	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15717609	15717609	PRJNA404067_P_NODE_9293_length_365_cov_5.990132_g8908_i0	PRJNA404067	9293	365	5.990132	21.8639818	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	520	7.8999999999999985e-143	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g8908	i0	92.391	196.049315068493	368	22	100	4	1	365	737514	737150	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	71558	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18266090	18266090	PRJNA404067_P_NODE_18695_length_241_cov_2.877778_g18308_i0	PRJNA404067	18695	241	2.877778	6.93544498	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	311	3.24e-80	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g18308	i0	90.456	125.107883817427	241	15	100	3	1	241	1316568	1316800	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	30151	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20207320	20207320	PRJNA404067_P_NODE_11716_length_309_cov_4.088710_g11330_i0	PRJNA404067	11716	309	4.08871	12.6341139	Verrucomicrobiota	74201	Bacteria	Bacteria	298	3.36e-76	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g11330	i0	89.496	68.4045307443366	238	22	76	3	66	301	4611617	4611381	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	21137	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20816518	20816518	PRJNA404067_P_NODE_42797_length_183_cov_6.598361_g42410_i0	PRJNA404067	42797	183	6.598361	12.07500063	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	235	1.4399999999999998e-57	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g42410	i0	92.216	254.174863387978	167	12	91	1	9	174	465	631	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	46514	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
20816559	20816559	PRJNA404067_P_NODE_9397_length_362_cov_2.202658_g9012_i0	PRJNA404067	9397	362	2.202658	7.97362196	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	508	1.69e-139	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9012	i0	91.989	277.541436464088	362	29	100	0	1	362	1315638	1315999	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	100470	508	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22090911	22090911	PRJNA404067_P_NODE_16778_length_254_cov_1.067358_g16391_i0	PRJNA404067	16778	254	1.067358	2.71108932	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	303	5.77e-78	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g16391	i0	88.235	64.2874015748032	255	28	100	2	1	254	2727052	2726799	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	16329	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23366478	23366478	PRJNA404067_P_NODE_12819_length_293_cov_1.051724_g12432_i0	PRJNA404067	12819	293	1.051724	3.08155132	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	307	5.25e-79	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g12432	i0	85.714	1.48122866894198	294	38	99	3	1	292	2287120	2287411	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	434	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
23366592	23366592	PRJNA404067_P_NODE_23739_length_226_cov_1.400000_g23352_i0	PRJNA404067	23739	226	1.4	3.164	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	244	3.0899999999999997e-60	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g23352	i0	86.547	9.54424778761062	223	28	98	2	4	225	2091700	2091921	Lacunisphaera limnophila strain IG16b, complete genome	blastn	2157	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
24640828	24640828	PRJNA404067_P_NODE_14160_length_276_cov_3.000000_g13773_i0	PRJNA404067	14160	276	3	8.28	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	422	1.68e-113	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g13773	i0	94.815	28.518115942029	270	14	98	0	1	270	405204	404935	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	7871	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24640838	24640838	PRJNA404067_P_NODE_15280_length_265_cov_1.612745_g14893_i0	PRJNA404067	15280	265	1.612745	4.27377425	Luteolibacter sp.	1962973	Bacteria	Bacteria	377	3.5200000000000003e-100	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g14893	i0	94.355	283.607547169811	248	11	92	1	1	245	1009029	1008782	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	75156	377	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
24641014	24641014	PRJNA404067_P_NODE_27300_length_217_cov_1.583333_g26913_i0	PRJNA404067	27300	217	1.583333	3.43583261	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	191	3.89e-44	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g26913	i0	82.569	69.0138248847926	218	37	100	1	1	217	16817	17034	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	14976	191	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);;