metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_clade = "PVC group"

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
1419792	1419792	PRJNA1000943_P_NODE_11822_length_251_cov_0.876404_g11684_i0	PRJNA1000943	11822	251	0.876404	2.19977404	Rosistilla ulvae	1930277	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g11684	i0	100	0.115537848605578	29	0	12	0	118	146	6523009	6522981	Rosistilla ulvae strain EC9 chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
2695312	2695312	PRJNA1000943_P_NODE_143_length_1549_cov_2.367209_g116_i0	PRJNA1000943	143	1549	2.367209	36.66806741	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2540	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g116	i0	96.26	103.848934796643	1551	54	100	4	1	1549	737142	735594	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	160862	2540	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3549847	3549847	PRJNA1000943_P_NODE_6923_length_310_cov_1.316456_g6785_i0	PRJNA1000943	6923	310	1.316456	4.0810136	Pseudomonadati	3379134	Bacteria	Bacteria	431	3.18e-116	NTclustered	gi\|117550329\|gb\|DQ903988.1\|	199738	g6785	i0	91.693	114.964516129032	313	22	100	3	1	310	62	373	Uncultured Chlamydia sp. clone PRPR10 16S ribosomal RNA gene, partial sequence	blastn	35639	435	0.990804597701149	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	uncultured Chlamydia sp.
3971486	3971486	PRJNA1000943_P_NODE_7264_length_304_cov_1.350649_g7126_i0	PRJNA1000943	7264	304	1.350649	4.10597296	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	289	1.9799999999999996e-73	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g7126	i0	89.823	443.861842105263	226	22	74	1	35	259	2749638	2749863	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	134934	289	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4827296	4827296	PRJNA1000943_P_NODE_4864_length_360_cov_1.379791_g4727_i0	PRJNA1000943	4864	360	1.379791	4.9672476	Pseudomonadati	3379134	Bacteria	Bacteria	161	5.429999999999998e-35	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g4727	i0	79.31	31.8888888888889	232	46	64	2	130	360	3320639	3320869	Planctomyces sp. SH-PL62, complete genome	blastn	11480	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
7797676	7797676	PRJNA1000943_P_NODE_5867_length_332_cov_1.204633_g5729_i0	PRJNA1000943	5867	332	1.204633	3.99938156	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	387	7.549999999999998e-103	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5729	i0	88.06	69.1686746987952	335	28	98	10	6	332	7051489	7051819	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	22964	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9072538	9072538	PRJNA1000943_P_NODE_12088_length_250_cov_1.418079_g11950_i0	PRJNA1000943	12088	250	1.418079	3.5451975	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g11950	i0	91.346	70.06	208	15	83	3	1	207	1315122	1314917	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	17515	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14173811	14173811	PRJNA1000943_P_NODE_6912_length_310_cov_1.696203_g6774_i0	PRJNA1000943	6912	310	1.696203	5.2582293	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	429	1.15e-115	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g6774	i0	91.935	88.658064516129	310	19	100	4	1	310	4421886	4421583	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	27484	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14173816	14173816	PRJNA1000943_P_NODE_7292_length_304_cov_0.874459_g7154_i0	PRJNA1000943	7292	304	0.874459	2.65835536	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	374	5.319999999999998e-99	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g7154	i0	89.333	76.6842105263158	300	29	98	3	1	298	1315203	1315501	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23312	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15447827	15447827	PRJNA1000943_P_NODE_15253_length_242_cov_1.520710_g15115_i0	PRJNA1000943	15253	242	1.52071	3.6801182	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	374	4.1e-99	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g15115	i0	94.628	149.297520661157	242	12	100	1	1	242	3096873	3097113	Pirellula sp. SH-Sr6A, complete genome	blastn	36130	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15447914	15447914	PRJNA1000943_P_NODE_7973_length_292_cov_1.552511_g7835_i0	PRJNA1000943	7973	292	1.552511	4.53333212	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.42e-94	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g7835	i0	89.68	200.332191780822	281	29	96	0	12	292	3894740	3894460	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	58497	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17996823	17996823	PRJNA1000943_P_NODE_15115_length_243_cov_0.917647_g14977_i0	PRJNA1000943	15115	243	0.917647	2.22988221	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	165	2.6999999999999997e-36	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g14977	i0	79.184	26.1646090534979	245	45	99	6	1	242	6569312	6569071	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	6358	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
17996834	17996834	PRJNA1000943_P_NODE_15735_length_237_cov_2.817073_g15597_i0	PRJNA1000943	15735	237	2.817073	6.67646301	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	366	6.69e-97	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g15597	i0	94.561	154.725738396624	239	9	100	4	1	237	737308	737544	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	36670	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25225387	25225387	PRJNA1000943_P_NODE_9620_length_269_cov_1.260204_g9482_i0	PRJNA1000943	9620	269	1.260204	3.38994876	Pseudomonadati	3379134	Bacteria	Bacteria	359	1.3e-94	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g9482	i0	90.741	118.234200743494	270	24	100	1	1	269	2168321	2168590	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	31805	359	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);;