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

22 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
1033686	1033686	PRJNA1146029_P_NODE_9781_length_292_cov_1.168950_g9500_i0	PRJNA1146029	9781	292	1.16895	3.413334	Pseudomonadati	3379134	Bacteria	Bacteria	82.4	3.45e-11	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g9500	i0	97.872	27.1198630136986	47	1	16	0	1	47	3690	3644	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	7919	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
1564645	1564645	PRJNA1146029_P_NODE_11862_length_279_cov_1.339806_g11581_i0	PRJNA1146029	11862	279	1.339806	3.73805874	Congregicoccus parvus	3081749	Bacteria	Bacteria	195	4.03e-45	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g11581	i0	81.224	45.4444444444444	245	42	87	4	36	278	5717537	5717295	Opitutales bacterium ASA1 DNA, complete genome	blastn	12679	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
4116967	4116967	PRJNA1146029_P_NODE_1044_length_879_cov_2.267990_g826_i0	PRJNA1146029	1044	879	2.26799	19.9356321	Luteolibacter luteus	2728835	Bacteria	Bacteria	1386	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g826	i0	95.108	287.849829351536	879	43	100	0	1	879	3804816	3803938	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	253020	1386	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
4116989	4116989	PRJNA1146029_P_NODE_11764_length_279_cov_5.451456_g11483_i0	PRJNA1146029	11764	279	5.451456	15.20956224	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|2754040313\|dbj\|LC785860.1\|	2026799	g11483	i0	100	100.659498207885	279	0	100	0	1	279	532	810	Verrucomicrobiota bacterium AR-M27MN gene for 16S rRNA, partial sequence	blastn	28084	516	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
4861717	4861717	PRJNA1146029_P_NODE_10624_length_286_cov_2.746479_g10343_i0	PRJNA1146029	10624	286	2.746479	7.85492994	Candidatus Xiphinematobacter	134550	Bacteria	Bacteria	372	1.79e-98	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g10343	i0	90.244	128.346153846154	287	25	100	3	1	286	15598	15314	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	36707	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
6667889	6667889	PRJNA1146029_P_NODE_12406_length_275_cov_1.836634_g12125_i0	PRJNA1146029	12406	275	1.836634	5.0507435	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	226	1.41e-54	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g12125	i0	81.786	51.5418181818182	280	42	100	8	1	275	27053	27328	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	14174	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6668123	6668123	PRJNA1146029_P_NODE_646_length_1126_cov_3.069326_g473_i0	PRJNA1146029	646	1126	3.069326	34.56061076	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1170	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g473	i0	86.785	145.634103019538	1067	120	94	20	66	1122	2750504	2749449	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	163984	1170	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8686781	8686781	PRJNA1146029_P_NODE_627_length_1149_cov_13.866171_g454_i0	PRJNA1146029	627	1149	13.866171	159.32230479	Opitutaceae	134623	Bacteria	Bacteria	1604	0	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g454	i0	91.927	168.917319408181	1152	83	99	9	3	1149	5637602	5636456	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	194086	1613	0.994420334779913	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
9218115	9218115	PRJNA1146029_P_NODE_18968_length_246_cov_1.138728_g18687_i0	PRJNA1146029	18968	246	1.138728	2.80127088	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	337	5.479999999999998e-88	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g18687	i0	93.392	233.418699186992	227	15	92	0	20	246	16055	15829	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	57421	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10493860	10493860	PRJNA1146029_P_NODE_4089_length_423_cov_3.848571_g3811_i0	PRJNA1146029	4089	423	3.848571	16.27945533	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	383	1.2699999999999998e-101	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3811	i0	83.488	155.697399527187	430	51	100	18	1	423	15430	15846	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	65860	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11768653	11768653	PRJNA1146029_P_NODE_1170_length_824_cov_2.529960_g935_i0	PRJNA1146029	1170	824	2.52996	20.8468704	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	1319	0	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g935	i0	95.531	288.730582524272	828	32	100	4	1	824	457053	456227	Luteolibacter sp. AS25 chromosome, complete genome	blastn	237914	1319	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
11768912	11768912	PRJNA1146029_P_NODE_690_length_1098_cov_2.040976_g511_i0	PRJNA1146029	690	1098	2.040976	22.40991648	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	1685	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g511	i0	94.369	272.765027322404	1101	56	100	6	1	1098	1296	199	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	299496	1685	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13043770	13043770	PRJNA1146029_P_NODE_18371_length_247_cov_1.229885_g18090_i0	PRJNA1146029	18371	247	1.229885	3.03781595	Verrucomicrobia bacterium enrichment culture clone Lt-H7	863496	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|306569404\|gb\|GQ902886.1\|	863496	g18090	i0	100	99.1214574898785	247	0	100	0	1	247	95	341	Verrucomicrobia bacterium enrichment culture clone Lt-H7 16S ribosomal RNA gene, partial sequence	blastn	24483	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium enrichment culture clone Lt-H7
15061407	15061407	PRJNA1146029_P_NODE_7172_length_333_cov_2.815385_g6894_i0	PRJNA1146029	7172	333	2.815385	9.37523205	Verrucomicrobiota	74201	Bacteria	Bacteria	505	1.9999999999999995e-138	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g6894	i0	94.012	196.918918918919	334	19	100	1	1	333	5153208	5152875	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	65574	510	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15593075	15593075	PRJNA1146029_P_NODE_3853_length_435_cov_2.044199_g3575_i0	PRJNA1146029	3853	435	2.044199	8.89226565	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	436	9.93e-118	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3575	i0	84.966	257.519540229885	439	56	100	10	1	435	15401	15833	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	112021	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18141698	18141698	PRJNA1146029_P_NODE_11355_length_282_cov_1.473684_g11074_i0	PRJNA1146029	11355	282	1.473684	4.15578888	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	477	3.6199999999999986e-130	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11074	i0	97.163	103.067375886525	282	8	100	0	1	282	3557204	3556923	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	29065	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
19416341	19416341	PRJNA1146029_P_NODE_8416_length_312_cov_1.627615_g8135_i0	PRJNA1146029	8416	312	1.627615	5.0781588	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	377	4.24e-100	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g8135	i0	88.462	107.451923076923	312	36	100	0	1	312	5152707	5152396	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33525	377	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19416360	19416360	PRJNA1146029_P_NODE_9716_length_293_cov_0.759091_g9435_i0	PRJNA1146029	9716	293	0.759091	2.22413663	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	429	1.07e-115	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g9435	i0	93.174	284.853242320819	293	18	99	2	1	292	3411874	3412165	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	83462	429	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
21966881	21966881	PRJNA1146029_P_NODE_1458_length_733_cov_3.646970_g1208_i0	PRJNA1146029	1458	733	3.64697	26.7322901	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	1112	0	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g1208	i0	94.022	291.165075034106	736	41	100	2	1	733	456154	455419	Luteolibacter sp. AS25 chromosome, complete genome	blastn	213424	1112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
21967024	21967024	PRJNA1146029_P_NODE_3478_length_458_cov_1.805195_g3200_i0	PRJNA1146029	3478	458	1.805195	8.2677931	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	444	6.27e-120	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g3200	i0	85.748	295.257641921397	428	51	93	10	35	458	28484	28063	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	135228	444	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
24515901	24515901	PRJNA1146029_P_NODE_12740_length_273_cov_1.540000_g12459_i0	PRJNA1146029	12740	273	1.54	4.2042	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	399	7.769999999999998e-107	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g12459	i0	93.04	1	273	19	100	0	1	273	1140881	1140609	Luteolibacter sp. SL250 chromosome	blastn	273	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24516155	24516155	PRJNA1146029_P_NODE_7460_length_328_cov_2.403922_g7181_i0	PRJNA1146029	7460	328	2.403922	7.88486416	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	545	1.1599999999999999e-150	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g7181	i0	96.646	245.737804878049	328	11	100	0	1	328	1440	1767	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	80602	545	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii

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