metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
401199	401199	PRJNA379145_P_NODE_68441_length_163_cov_1.938462_g66287_i0	PRJNA379145	68441	163	1.938462	3.15969306	Luteolibacter sp.	1962973	Bacteria	Bacteria	267	4.459999999999999e-67	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g66287	i0	96.855	334.779141104294	159	5	98	0	1	159	1008969	1008811	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	54569	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
4227986	4227986	PRJNA379145_P_NODE_32224_length_385_cov_3.633523_g30089_i0	PRJNA379145	32224	385	3.633523	13.98906355	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	407	6.809999999999999e-109	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g30089	i0	85.751	195.236363636364	386	53	100	2	1	385	455029	455413	Luteolibacter sp. AS25 chromosome, complete genome	blastn	75166	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
4902017	4902017	PRJNA379145_P_NODE_71824_length_155_cov_1.688525_g69669_i0	PRJNA379145	71824	155	1.688525	2.61721375	Akkermansia	239934	Bacteria	Bacteria	104	3.47e-18	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g69669	i0	91.892	8.54838709677419	74	6	48	0	74	147	1765855	1765782	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	1325	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis
5504517	5504517	PRJNA379145_P_NODE_43665_length_273_cov_3.695833_g41513_i0	PRJNA379145	43665	273	3.695833	10.08962409	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	436	5.9199999999999985e-118	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g41513	i0	95.588	289.714285714286	272	12	99	0	2	273	3411545	3411816	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	79092	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9329094	9329094	PRJNA379145_P_NODE_55308_length_207_cov_2.356322_g53154_i0	PRJNA379145	55308	207	2.356322	4.87758654	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	359	9.53e-95	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g53154	i0	99	304.463768115942	200	2	97	0	1	200	1321652	1321453	Luteolibacter sp. Populi chromosome, complete genome	blastn	63024	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
13154669	13154669	PRJNA379145_P_NODE_44951_length_264_cov_2.333333_g42799_i0	PRJNA379145	44951	264	2.333333	6.15999912	Luteolibacter luteus	2728835	Bacteria	Bacteria	414	2.6699999999999998e-111	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g42799	i0	95.057	119.799242424242	263	13	99	0	2	264	3803528	3803790	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	31627	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
15703542	15703542	PRJNA379145_P_NODE_35793_length_343_cov_4.600000_g33646_i0	PRJNA379145	35793	343	4.6	15.778	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	562	1.21e-155	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g33646	i0	96.221	287.833819241982	344	11	100	2	1	343	1035	693	Luteolibacter sp. SL250 chromosome	blastn	98727	562	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15703875	15703875	PRJNA379145_P_NODE_71053_length_157_cov_1.500000_g68898_i0	PRJNA379145	71053	157	1.5	2.355	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	233	4.31e-57	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g68898	i0	93.711	164.898089171975	159	4	100	5	1	157	3048334	3048488	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	25889	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
18252723	18252723	PRJNA379145_P_NODE_61815_length_182_cov_2.369128_g59661_i0	PRJNA379145	61815	182	2.369128	4.31181296	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	124	3.2299999999999997e-24	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g59661	i0	93.976	1.78021978021978	83	4	46	1	1	83	2749968	2749887	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	324	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19526681	19526681	PRJNA379145_P_NODE_35776_length_344_cov_1.234727_g33629_i0	PRJNA379145	35776	344	1.234727	4.24746088	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	542	1.58e-149	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g33629	i0	95.058	127.988372093023	344	17	100	0	1	344	5152926	5153269	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	44028	542	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20802020	20802020	PRJNA379145_P_NODE_14197_length_764_cov_4.181943_g12657_i0	PRJNA379145	14197	764	4.181943	31.95004452	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1072	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g12657	i0	94.294	290.611256544503	701	39	92	1	64	764	1343	2042	Luteolibacter sp. SL250 chromosome	blastn	222027	1072	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20802052	20802052	PRJNA379145_P_NODE_16777_length_678_cov_7.896124_g15060_i0	PRJNA379145	16777	678	7.896124	53.53572072	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	520	1.54e-142	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g15060	i0	92.391	147.622418879056	368	23	54	5	1	366	455381	455745	Luteolibacter sp. AS25 chromosome, complete genome	blastn	100088	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
22077273	22077273	PRJNA379145_P_NODE_28258_length_442_cov_2.264059_g26166_i0	PRJNA379145	28258	442	2.264059	10.00714078	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	616	1.2099999999999996e-171	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g26166	i0	92.027	170.984162895928	439	33	99	1	4	442	27979	28415	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	75575	616	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22077440	22077440	PRJNA379145_P_NODE_43678_length_273_cov_2.620833_g41526_i0	PRJNA379145	43678	273	2.620833	7.15487409	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	361	3.67e-95	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g41526	i0	90.545	122.223443223443	275	22	100	4	1	273	454490	454762	Luteolibacter sp. AS25 chromosome, complete genome	blastn	33367	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
24627364	24627364	PRJNA379145_P_NODE_62120_length_181_cov_2.966216_g59966_i0	PRJNA379145	62120	181	2.966216	5.36885096	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	126	8.93e-25	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g59966	i0	79.474	5.24861878453039	190	30	100	7	1	181	633335	633146	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	950	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius

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