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

17 rows where analysis = "blastn", bioproject = "PRJNA1111077" 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
214332	214332	PRJNA1111077_P_NODE_11261_length_353_cov_1.100000_g11040_i0	PRJNA1111077	11261	353	1.1	3.883	Luteolibacter luteus	2728835	Bacteria	Bacteria	608	1.579999999999999e-169	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g11040	i0	97.734	41.3314447592068	353	8	100	0	1	353	3804918	3804566	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	14590	608	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
214865	214865	PRJNA1111077_P_NODE_33561_length_246_cov_0.890173_g33340_i0	PRJNA1111077	33561	246	0.890173	2.18982558	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g33340	i0	82.71	4.03658536585366	214	35	87	2	1	213	2872178	2871966	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	993	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1489099	1489099	PRJNA1111077_P_NODE_12842_length_331_cov_1.565891_g12621_i0	PRJNA1111077	12842	331	1.565891	5.18309921	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	329	1.29e-85	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g12621	i0	85.321	6.21450151057402	327	39	99	4	1	327	3216220	3215903	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	2057	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1489777	1489777	PRJNA1111077_P_NODE_6182_length_462_cov_10.084833_g5961_i0	PRJNA1111077	6182	462	10.084833	46.59192846	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	479	1.7399999999999993e-130	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g5961	i0	86.017	34.4502164502165	472	36	99	15	2	462	1316077	1316529	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	15916	479	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1489887	1489887	PRJNA1111077_P_NODE_9642_length_378_cov_12.108197_g9421_i0	PRJNA1111077	9642	378	12.108197	45.76898466	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	496	1.38e-135	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9421	i0	90.642	164.55291005291	374	33	99	2	4	376	1315450	1315078	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	62201	496	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2765631	2765631	PRJNA1111077_P_NODE_34863_length_244_cov_0.900585_g34642_i0	PRJNA1111077	34863	244	0.900585	2.1974274	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g34642	i0	92.653	3.01639344262295	245	17	100	1	1	244	3331327	3331083	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	736	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4041859	4041859	PRJNA1111077_P_NODE_4984_length_511_cov_5.673516_g4763_i0	PRJNA1111077	4984	511	5.673516	28.99166676	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	226	2.7799999999999995e-54	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g4763	i0	97.015	132.724070450098	134	4	62	0	375	508	4718610	4718743	Luteolibacter sp. SL250 chromosome	blastn	67822	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7867763	7867763	PRJNA1111077_P_NODE_38227_length_216_cov_7.797203_g38006_i0	PRJNA1111077	38227	216	7.797203	16.84195848	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	209	1.0700000000000001e-49	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g38006	i0	84.507	207.458333333333	213	31	99	2	1	213	28367	28577	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	44811	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
7867832	7867832	PRJNA1111077_P_NODE_5807_length_476_cov_5.625310_g5586_i0	PRJNA1111077	5807	476	5.62531	26.7764756	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	446	1.82e-120	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g5586	i0	83.958	416.548319327731	480	62	99	13	3	476	276263	276733	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	198277	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
11693117	11693117	PRJNA1111077_P_NODE_15630_length_310_cov_2.864979_g15409_i0	PRJNA1111077	15630	310	2.864979	8.8814349	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	217	9.7e-52	NTclustered	gi\|226525261\|gb\|FJ872372.1\|	156588	g15409	i0	92.667	89.3483870967742	150	11	97	0	161	310	10501	10352	Uncultured Verrucomicrobia bacterium clone 106 genomic sequence	blastn	27698	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12968464	12968464	PRJNA1111077_P_NODE_21811_length_281_cov_1.264423_g21590_i0	PRJNA1111077	21811	281	1.264423	3.55302863	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	477	3.6099999999999986e-130	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g21590	i0	97.173	191.284697508897	283	6	100	2	1	281	3894424	3894706	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	53751	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12968529	12968529	PRJNA1111077_P_NODE_24211_length_272_cov_5.080402_g23990_i0	PRJNA1111077	24211	272	5.080402	13.81869344	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	403	5.98e-108	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g23990	i0	93.382	30.6176470588235	272	18	100	0	1	272	2155	2426	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	8328	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
16792149	16792149	PRJNA1111077_P_NODE_38294_length_212_cov_6.467626_g38073_i0	PRJNA1111077	38294	212	6.467626	13.71136712	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	381	2.0899999999999994e-101	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g38073	i0	99.057	484.075471698113	212	2	100	0	1	212	2833434	2833223	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	102624	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
19340760	19340760	PRJNA1111077_P_NODE_32076_length_248_cov_0.880000_g31855_i0	PRJNA1111077	32076	248	0.88	2.1824	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g31855	i0	91.129	5.75403225806452	248	22	100	0	1	248	3216184	3216431	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1427	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23167353	23167353	PRJNA1111077_P_NODE_37679_length_231_cov_5.177215_g37458_i0	PRJNA1111077	37679	231	5.177215	11.95936665	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	204	5.3799999999999997e-48	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g37458	i0	83.478	114.82683982684	230	27	98	9	1	227	276425	276646	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	26525	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
24440916	24440916	PRJNA1111077_P_NODE_37740_length_230_cov_6.834395_g37519_i0	PRJNA1111077	37740	230	6.834395	15.7191085	Horticoccus luteus	2862869	Bacteria	Bacteria	392	1.07e-104	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g37519	i0	97.391	47.7521739130435	230	6	100	0	1	230	540163	539934	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	10983	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
25247614	25247614	PRJNA1111077_P_NODE_7720_length_419_cov_1.930636_g7499_i0	PRJNA1111077	7720	419	1.930636	8.08936484	Luteolibacter	518753	Bacteria	Bacteria	769	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g7499	i0	99.761	206.207637231504	419	1	100	0	1	419	3804372	3803954	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	86401	769	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus

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