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

9 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
1822101	1822101	PRJNA564013_P_NODE_106082_length_400_cov_21.525074_g103243_i0	PRJNA564013	106082	400	21.525074	86.100296	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	521	2.4299999999999995e-143	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g103243	i0	98.639	152.9825	294	4	89	0	25	318	4041	3748	Luteolibacter sp. SL250 chromosome	blastn	61193	521	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
1824442	1824442	PRJNA564013_P_NODE_206182_length_300_cov_5.682008_g203331_i0	PRJNA564013	206182	300	5.682008	17.046024	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	76.8	1.66e-9	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g203331	i0	95.745	2.07333333333333	47	2	16	0	154	200	1256987	1256941	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	622	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
3098847	3098847	PRJNA564013_P_NODE_163163_length_340_cov_1.620072_g160313_i0	PRJNA564013	163163	340	1.620072	5.5082448	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	202	3.0099999999999996e-47	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g160313	i0	78.571	0.947058823529412	322	58	93	11	23	338	2959926	2960242	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	322	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
5650266	5650266	PRJNA564013_P_NODE_104825_length_402_cov_10.832845_g101989_i0	PRJNA564013	104825	402	10.832845	43.5480369	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	383	1.2e-101	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g101989	i0	86.158	64.1069651741294	354	49	88	0	22	375	1052990	1053343	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	25771	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9477132	9477132	PRJNA564013_P_NODE_191808_length_314_cov_2.130435_g188957_i0	PRJNA564013	191808	314	2.130435	6.6895659	Oceaniferula spumae	2979115	Bacteria	Bacteria	75	6.27e-9	NTclustered	gi\|2753272999\|dbj\|AP026866.1\|	2979115	g188957	i0	83.544	0.251592356687898	79	13	25	0	214	292	3016571	3016493	Verrucomicrobiaceae bacterium NT6N DNA, complete genome	blastn	79	75	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula spumae
10751472	10751472	PRJNA564013_P_NODE_131429_length_370_cov_1.728155_g128581_i0	PRJNA564013	131429	370	1.728155	6.3941735	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	239	2.52e-58	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g128581	i0	85.043	1.99189189189189	234	35	63	0	45	278	5910229	5909996	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	737	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
12028006	12028006	PRJNA564013_P_NODE_205330_length_301_cov_3.562500_g202479_i0	PRJNA564013	205330	301	3.5625	10.723125	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	244	4.3099999999999997e-60	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g202479	i0	83.271	13.0299003322259	269	41	89	4	23	289	4199366	4199632	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3922	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
13302117	13302117	PRJNA564013_P_NODE_165351_length_338_cov_2.021661_g162501_i0	PRJNA564013	165351	338	2.021661	6.83321418	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	337	7.869999999999997e-88	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g162501	i0	86.306	67.1923076923077	314	37	92	6	1	311	633277	632967	Luteolibacter sp. LG18 DNA, complete genome	blastn	22711	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14580054	14580054	PRJNA564013_P_NODE_325952_length_210_cov_3.496644_g323100_i0	PRJNA564013	325952	210	3.496644	7.3429524	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	137	4.95e-28	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g323100	i0	83.221	23.5857142857143	149	25	71	0	53	201	5181599	5181747	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	4953	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae 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);;