metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
1701762	1701762	PRJNA429937_P_NODE_51942_length_489_cov_10.832609_g34166_i0	PRJNA429937	51942	489	10.832609	52.97145801	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	451	4.02e-122	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g34166	i0	84.289	213.014314928425	471	64	96	10	2	468	15839	15375	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	104164	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
1702486	1702486	PRJNA429937_P_NODE_90342_length_332_cov_3.419142_g67764_i0	PRJNA429937	90342	332	3.419142	11.35155144	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	233	1.04e-56	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g67764	i0	99.225	110.144578313253	129	1	56	0	1	129	456758	456630	Luteolibacter sp. AS25 chromosome, complete genome	blastn	36568	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
4254633	4254633	PRJNA429937_P_NODE_96844_length_311_cov_8.255319_g74245_i0	PRJNA429937	96844	311	8.255319	25.67404209	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	272	2.0499999999999993e-68	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g74245	i0	83.333	106.263665594855	300	45	95	5	1	296	28232	27934	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	33048	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5530349	5530349	PRJNA429937_P_NODE_39405_length_574_cov_17.234862_g24772_i1	PRJNA429937	39405	574	17.234862	98.92810788	Luteolibacter sp.	1962973	Bacteria	Bacteria	392	2.939999999999999e-104	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g24772	i1	88.545	235.247386759582	323	18	95	3	1	305	1009553	1009232	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	135032	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
5530815	5530815	PRJNA429937_P_NODE_62565_length_435_cov_2.830049_g42361_i0	PRJNA429937	62565	435	2.830049	12.31071315	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	233	1.3999999999999997e-56	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g42361	i0	99.225	87.5402298850575	129	1	57	0	175	303	456630	456758	Luteolibacter sp. AS25 chromosome, complete genome	blastn	38080	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
5531092	5531092	PRJNA429937_P_NODE_77625_length_374_cov_3.327536_g55367_i0	PRJNA429937	77625	374	3.327536	12.44498464	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	235	3.29e-57	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g55367	i0	99.231	100.957219251337	130	1	66	0	58	187	456759	456630	Luteolibacter sp. AS25 chromosome, complete genome	blastn	37758	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
8080357	8080357	PRJNA429937_P_NODE_57987_length_457_cov_4.341121_g38770_i0	PRJNA429937	57987	457	4.341121	19.83892297	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	272	3.1299999999999996e-68	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g38770	i0	86.9	146.413566739606	229	27	49	1	1	226	3412683	3412455	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	66911	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9354512	9354512	PRJNA429937_P_NODE_2748_length_1909_cov_39.231383_g1630_i0	PRJNA429937	2748	1909	39.231383	748.92710147	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	2117	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1630	i0	87.294	211.000523834468	1881	203	98	31	18	1886	26803	28659	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	402800	2117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
13181417	13181417	PRJNA429937_P_NODE_98171_length_307_cov_24.841727_g75563_i0	PRJNA429937	98171	307	24.841727	76.26410189	Luteolibacter luteus	2728835	Bacteria	Bacteria	468	2.4e-127	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g75563	i0	94.137	279.133550488599	307	18	100	0	1	307	3803537	3803843	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	85694	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
14455599	14455599	PRJNA429937_P_NODE_4252_length_1627_cov_31.050063_g1630_i1	PRJNA429937	4252	1627	31.050063	505.18452501	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1615	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1630	i1	87.043	208.320221266134	1451	162	88	22	24	1461	28659	27222	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	338937	1615	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18278885	18278885	PRJNA429937_P_NODE_7035_length_1327_cov_14.922188_g4145_i0	PRJNA429937	7035	1327	14.922188	198.01743476	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1583	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4145	i0	89.269	202.084400904295	1286	109	96	24	38	1307	1315515	1316787	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	268166	1583	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18938877	18938877	PRJNA429937_P_NODE_154455_length_165_cov_3.264706_g131828_i0	PRJNA429937	154455	165	3.264706	5.3867649	Opitutaceae	134623	Bacteria	Bacteria	215	1.66e-51	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g131828	i0	97.6	20.3515151515152	125	3	76	0	1	125	969	1093	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	3358	217	0.990783410138249	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
19551576	19551576	PRJNA429937_P_NODE_116476_length_257_cov_3.451754_g93850_i0	PRJNA429937	116476	257	3.451754	8.87100778	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	233	7.78e-57	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g93850	i0	99.225	140.070038910506	129	1	50	0	1	129	456630	456758	Luteolibacter sp. AS25 chromosome, complete genome	blastn	35998	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
19552964	19552964	PRJNA429937_P_NODE_59076_length_451_cov_23.774882_g39619_i0	PRJNA429937	59076	451	23.774882	107.22471782	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	339	3e-88	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g39619	i0	81.473	205.343680709534	421	71	93	5	2	420	2749462	2749877	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	92610	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23378784	23378784	PRJNA429937_P_NODE_39299_length_575_cov_17.071429_g24772_i0	PRJNA429937	39299	575	17.071429	98.16071675	Luteolibacter sp.	1962973	Bacteria	Bacteria	353	1.39e-92	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g24772	i0	95.89	233.725217391304	219	8	93	1	88	306	1009449	1009232	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	134392	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
23379508	23379508	PRJNA429937_P_NODE_7619_length_1280_cov_8.914468_g4145_i1	PRJNA429937	7619	1280	8.914468	114.1051904	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1628	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4145	i1	90.59	225.77578125	1254	81	97	26	38	1280	1315515	1316742	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	288993	1628	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);;