metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
675017	675017	PRJNA694770_P_NODE_63281_length_275_cov_1.004950_g62987_i0	PRJNA694770	63281	275	1.00495	2.7636125	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	82.4	3.22e-11	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g62987	i0	89.231	0.4	65	7	24	0	50	114	2748989	2749053	Luteolibacter sp. Populi chromosome, complete genome	blastn	110	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
1951673	1951673	PRJNA694770_P_NODE_87082_length_247_cov_0.885057_g86788_i0	PRJNA694770	87082	247	0.885057	2.18609079	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g86788	i0	94.937	31.7732793522267	79	4	32	0	58	136	808844	808922	Luteolibacter sp. SL250 chromosome	blastn	7848	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
5779041	5779041	PRJNA694770_P_NODE_81325_length_250_cov_0.870056_g81031_i0	PRJNA694770	81325	250	0.870056	2.17514	Luteolibacter luteus	2728835	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g81031	i0	86.694	0.992	248	31	99	2	1	247	2471528	2471774	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	248	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
7053990	7053990	PRJNA694770_P_NODE_74446_length_256_cov_2.103825_g74152_i0	PRJNA694770	74446	256	2.103825	5.385792	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	137	6.25e-28	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g74152	i0	80.435	33.56640625	184	32	71	4	7	188	1116877	1116696	Lacunisphaera limnophila strain IG16b, complete genome	blastn	8593	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
13429205	13429205	PRJNA694770_P_NODE_77531_length_251_cov_1.730337_g77237_i0	PRJNA694770	77531	251	1.730337	4.34314587	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g77237	i0	85.185	0.752988047808765	189	28	75	0	48	236	4075725	4075913	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	189	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13429587	13429587	PRJNA694770_P_NODE_91771_length_245_cov_0.895349_g91477_i0	PRJNA694770	91771	245	0.895349	2.19360505	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	158	4.56e-34	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g91477	i0	81.538	6.64489795918367	195	33	79	3	51	243	2545452	2545259	Luteolibacter sp. LG18 DNA, complete genome	blastn	1628	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14704277	14704277	PRJNA694770_P_NODE_72832_length_259_cov_1.655914_g72538_i0	PRJNA694770	72832	259	1.655914	4.28881726	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	69.4	2.34e-7	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g72538	i0	81.395	0.332046332046332	86	14	33	2	105	189	1527775	1527859	Luteolibacter sp. LG18 DNA, complete genome	blastn	86	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14705017	14705017	PRJNA694770_P_NODE_99552_length_241_cov_0.916667_g99258_i0	PRJNA694770	99552	241	0.916667	2.20916747	Actomonas aquatica	2866162	Bacteria	Bacteria	182	2.65e-41	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g99258	i0	95.575	9.96265560165975	113	5	47	0	129	241	346195	346307	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	2401	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
22352207	22352207	PRJNA694770_P_NODE_58398_length_282_cov_1.253589_g58104_i0	PRJNA694770	58398	282	1.253589	3.53512098	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	475	1.2999999999999999e-129	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g58104	i0	97.153	0.99645390070922	281	8	99	0	1	281	3352062	3351782	Luteolibacter sp. SL250 chromosome	blastn	281	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250

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