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

17 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
1998067	1998067	PRJNA743294_P_NODE_33862_length_288_cov_2.800000_g33406_i0	PRJNA743294	33862	288	2.8	8.064	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	255	1.8900000000000001e-63	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g33406	i0	84.133	119.722222222222	271	35	92	8	19	284	2833483	2833750	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	34480	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
4550628	4550628	PRJNA743294_P_NODE_43504_length_259_cov_2.516129_g43048_i0	PRJNA743294	43504	259	2.516129	6.51677411	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	134	8.190000000000001e-27	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g43048	i0	79.787	3.71428571428571	188	34	72	4	2	187	2410236	2410421	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	962	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
4550684	4550684	PRJNA743294_P_NODE_50424_length_248_cov_1.577143_g49968_i0	PRJNA743294	50424	248	1.577143	3.91131464	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	387	5.409999999999998e-103	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g49968	i0	94.779	294.358870967742	249	11	100	2	1	248	1320405	1320652	Luteolibacter sp. Populi chromosome, complete genome	blastn	73001	387	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
8375289	8375289	PRJNA743294_P_NODE_22927_length_342_cov_1.130112_g22471_i0	PRJNA743294	22927	342	1.130112	3.86498304	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	507	5.74e-139	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g22471	i0	95.046	179.520467836257	323	15	94	1	20	342	1482	1803	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	61396	507	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
8375413	8375413	PRJNA743294_P_NODE_39687_length_270_cov_0.923858_g39231_i0	PRJNA743294	39687	270	0.923858	2.4944166	Fontisphaera persica	2974023	Bacteria	Bacteria	361	3.619999999999999e-95	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g39231	i0	90.775	90.4444444444444	271	24	100	1	1	270	3863306	3863036	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	24420	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
10127041	10127041	PRJNA743294_P_NODE_50448_length_248_cov_1.491429_g49992_i0	PRJNA743294	50448	248	1.491429	3.69874392	Prosthecobacter	48463	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g49992	i0	90.323	286	248	24	100	0	1	248	2466	2219	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	70928	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
10925810	10925810	PRJNA743294_P_NODE_13109_length_441_cov_1.967391_g12653_i0	PRJNA743294	13109	441	1.967391	8.67619431	Opitutales bacterium	2026772	Bacteria	Bacteria	416	1.31e-111	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g12653	i0	83.747	271.863945578231	443	68	100	4	1	441	679762	680202	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	119892	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
10926040	10926040	PRJNA743294_P_NODE_40749_length_266_cov_4.269430_g40293_i0	PRJNA743294	40749	266	4.26943	11.3566838	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	303	6.08e-78	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g40293	i0	87.739	98.0827067669173	261	31	98	1	6	266	1315026	1315285	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	26090	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14751112	14751112	PRJNA743294_P_NODE_5532_length_651_cov_3.235294_g5085_i0	PRJNA743294	5532	651	3.235294	21.06176394	Opitutales bacterium	2026772	Bacteria	Bacteria	604	3.9599999999999987e-168	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g5085	i0	83.587	168.680491551459	658	94	100	14	1	651	678918	679568	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	109811	604	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
16024658	16024658	PRJNA743294_P_NODE_37653_length_276_cov_1.290640_g37197_i0	PRJNA743294	37653	276	1.29064	3.5621664	Luteolibacter sp.	1962973	Bacteria	Bacteria	438	1.6699999999999996e-118	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g37197	i0	95.29	262.753623188406	276	13	100	0	1	276	1010302	1010027	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	72520	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
17300311	17300311	PRJNA743294_P_NODE_48274_length_251_cov_0.876404_g47818_i0	PRJNA743294	48274	251	0.876404	2.19977404	Akkermansia muciniphila	239935	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1583980166\|gb\|CP036293.1\|	239935	g47818	i0	99.602	11	251	1	100	0	1	251	635762	636012	Akkermansia muciniphila strain 139 chromosome, complete genome	blastn	2761	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17300367	17300367	PRJNA743294_P_NODE_56754_length_242_cov_0.863905_g56298_i0	PRJNA743294	56754	242	0.863905	2.0906501	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g56298	i0	98.347	217.954545454545	242	4	100	0	1	242	28058	28299	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	52745	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18573654	18573654	PRJNA743294_P_NODE_19635_length_366_cov_2.232082_g19179_i0	PRJNA743294	19635	366	2.232082	8.16942012	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	588	2.1399999999999994e-163	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g19179	i0	95.628	287.803278688525	366	16	100	0	1	366	1320105	1319740	Luteolibacter sp. Populi chromosome, complete genome	blastn	105336	588	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
19849106	19849106	PRJNA743294_P_NODE_3996_length_756_cov_3.345534_g3598_i0	PRJNA743294	3996	756	3.345534	25.29223704	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1147	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3598	i0	94.071	139.937830687831	759	40	100	5	1	756	1315654	1316410	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	105793	1147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22399555	22399555	PRJNA743294_P_NODE_39978_length_269_cov_1.331633_g39522_i0	PRJNA743294	39978	269	1.331633	3.58209277	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	375	1.2899999999999998e-99	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g39522	i0	91.852	31.4609665427509	270	20	100	2	1	269	1727685	1727417	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	8463	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22875830	22875830	PRJNA743294_P_NODE_25938_length_324_cov_1.593625_g25482_i0	PRJNA743294	25938	324	1.593625	5.163345	Prosthecobacter	48463	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g25482	i0	100	192.839506172839	324	0	100	0	1	324	599	922	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	62480	599	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
23674952	23674952	PRJNA743294_P_NODE_21419_length_352_cov_2.724014_g20963_i0	PRJNA743294	21419	352	2.724014	9.58852928	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	305	2.31e-78	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g20963	i0	82.486	137.215909090909	354	56	99	6	1	351	2749957	2750307	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	48300	305	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);;