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

17 rows where analysis = "blastn", bioproject = "PRJNA1034994" 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
168239	168239	PRJNA1034994_P_NODE_661_length_642_cov_5.370826_g578_i0	PRJNA1034994	661	642	5.370826	34.48070292	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	680	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g578	i0	85.802	144.806853582555	648	85	100	6	1	642	2623571	2622925	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	92966	680	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
1442953	1442953	PRJNA1034994_P_NODE_1022_length_508_cov_4.482759_g938_i0	PRJNA1034994	1022	508	4.482759	22.77241572	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	625	2.3399999999999997e-174	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g938	i0	88.867	195.785433070866	512	52	100	5	1	508	3833068	3833578	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	99459	625	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2282765	2282765	PRJNA1034994_P_NODE_3122_length_293_cov_1.050000_g3038_i0	PRJNA1034994	3122	293	1.05	3.0765	Planctomycetaceae	126	Bacteria	Bacteria	296	1.14e-75	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3038	i0	90.991	178.59385665529	222	17	75	2	73	293	3083037	3082818	Stratiformator vulcanicus strain Pan189 chromosome	blastn	52328	298	0.993288590604027	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
6110755	6110755	PRJNA1034994_P_NODE_4685_length_272_cov_1.547739_g4601_i0	PRJNA1034994	4685	272	1.547739	4.20985008	Planctomycetaceae	126	Bacteria	Bacteria	291	4.86e-74	NTclustered	gi\|1712549334\|gb\|CP036343.1\|	2527971	g4601	i0	86.081	157.033088235294	273	35	99	3	2	272	2344413	2344684	Gimesia algae strain Pan161 chromosome	blastn	42713	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia algae
6546261	6546261	PRJNA1034994_P_NODE_1726_length_387_cov_1.958599_g1642_i0	PRJNA1034994	1726	387	1.958599	7.57977813	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	462	1.44e-125	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g1642	i0	88.402	116.875968992248	388	39	99	6	3	387	1844561	1844945	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	45231	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
9095795	9095795	PRJNA1034994_P_NODE_5428_length_264_cov_1.382199_g5344_i0	PRJNA1034994	5428	264	1.382199	3.64900536	Urbifossiella limnaea	2528023	Bacteria	Bacteria	198	2.93e-46	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g5344	i0	80.451	88.75	266	47	100	5	1	264	4212458	4212196	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	23430	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11646790	11646790	PRJNA1034994_P_NODE_1450_length_422_cov_1.128940_g1366_i0	PRJNA1034994	1450	422	1.12894	4.7641268	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	713	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1366	i0	97.156	127.13981042654	422	12	100	0	1	422	1903300	1903721	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	53653	713	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
11646840	11646840	PRJNA1034994_P_NODE_7890_length_247_cov_1.971264_g7806_i0	PRJNA1034994	7890	247	1.971264	4.86902208	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g7806	i0	99.19	156.246963562753	247	2	100	0	1	247	3095125	3095371	Pirellula sp. SH-Sr6A, complete genome	blastn	38593	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12921929	12921929	PRJNA1034994_P_NODE_1131_length_480_cov_2.385749_g1047_i0	PRJNA1034994	1131	480	2.385749	11.4515952	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	617	3.68e-172	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g1047	i0	89.979	97.7291666666667	479	47	99	1	1	478	5637774	5638252	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	46910	617	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
12921933	12921933	PRJNA1034994_P_NODE_1551_length_406_cov_1.879880_g1467_i0	PRJNA1034994	1551	406	1.87988	7.6323128	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	381	4.369999999999999e-101	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g1467	i0	83.942	155.869458128079	411	53	99	12	1	405	2663972	2664375	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	63283	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15471095	15471095	PRJNA1034994_P_NODE_3193_length_290_cov_3.129032_g3109_i0	PRJNA1034994	3193	290	3.129032	9.0741928	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	420	6.39e-113	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g3109	i0	92.881	56.5758620689655	295	12	100	8	1	290	4031	4321	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	16407	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
16309936	16309936	PRJNA1034994_P_NODE_1133_length_480_cov_1.695332_g1049_i0	PRJNA1034994	1133	480	1.695332	8.1375936	Chlamydiia	204429	Bacteria	Bacteria	627	6.109999999999999e-175	NTclustered	gi\|18029193\|gb\|AF364564.1\|	174324	g1049	i0	90.289	110.147916666667	484	39	100	7	1	480	70	549	Uncultured Chlamydiales bacterium clone P-4 16S ribosomal RNA gene, partial sequence	blastn	52871	627	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
20133923	20133923	PRJNA1034994_P_NODE_1096_length_490_cov_1.016787_g1012_i0	PRJNA1034994	1096	490	1.016787	4.9822563	Candidatus Protochlamydia	282132	Bacteria	Bacteria	479	1.8499999999999998e-130	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g1012	i0	86.667	158.820408163265	435	55	89	3	1	434	2154109	2153677	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	77822	479	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
21845148	21845148	PRJNA1034994_P_NODE_638_length_652_cov_2.373057_g555_i0	PRJNA1034994	638	652	2.373057	15.47233164	Planctomycetales bacterium	2053591	Bacteria	Bacteria	793	0	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g555	i0	88.72	222.216257668712	656	65	100	7	1	652	3542259	3542909	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	144885	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
23120423	23120423	PRJNA1034994_P_NODE_3639_length_285_cov_1.452830_g3555_i0	PRJNA1034994	3639	285	1.45283	4.1405655	Luteolibacter luteus	2728835	Bacteria	Bacteria	483	7.879999999999998e-132	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g3555	i0	97.193	41.0140350877193	285	8	100	0	1	285	3804634	3804918	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	11689	483	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
24394369	24394369	PRJNA1034994_P_NODE_940_length_536_cov_1.166307_g856_i0	PRJNA1034994	940	536	1.166307	6.25140552	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	531	5.55e-146	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g856	i0	85.165	117.369402985075	546	49	100	22	1	536	1843757	1844280	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	62910	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
25233838	25233838	PRJNA1034994_P_NODE_9660_length_242_cov_2.526627_g9576_i0	PRJNA1034994	9660	242	2.526627	6.11443734	Singulisphaera	466152	Bacteria	Bacteria	296	9.12e-76	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g9576	i0	88.797	40.4876033057851	241	27	99	0	1	241	7354298	7354538	Singulisphaera acidiphila DSM 18658, complete genome	blastn	9798	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila

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