metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
439061	439061	PRJNA450343_P_NODE_1181_length_512_cov_2.894168_g1114_i0	PRJNA450343	1181	512	2.894168	14.81814016	Pseudoroseicyclus sp. CXY001	3242492	Bacteria	Bacteria	808	0	NTclustered	gi\|2796624051\|gb\|CP168219.1\|	3242492	g1114	i0	96.715	201.732421875	487	12	95	4	1	485	3386571	3386087	Pseudoroseicyclus sp. CXY001 chromosome, complete genome	blastn	103287	808	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Pseudoroseicyclus	Pseudoroseicyclus sp. CXY001
439062	439062	PRJNA450343_P_NODE_1201_length_508_cov_7.895425_g1134_i0	PRJNA450343	1201	508	7.895425	40.108759	Escherichia coli	562	Bacteria	Bacteria	867	0	NTclustered	gi\|2617063636\|dbj\|AP027764.1\|	562	g1134	i0	97.441	698.490157480315	508	13	100	0	1	508	4925799	4925292	Escherichia coli 2017-02-2CC DNA, complete genome	blastn	354833	867	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
1092515	1092515	PRJNA450343_P_NODE_4761_length_243_cov_1.494845_g4693_i0	PRJNA450343	4761	243	1.494845	3.63247335	Sphingomonas	13687	Bacteria	Bacteria	383	6.84e-102	NTclustered	gi\|400532535\|gb\|JX219393.1\|	1221571	g4693	i0	95.062	156.312757201646	243	12	100	0	1	243	1163	1405	Sphingomonas sp. SL2 23S ribosomal RNA gene, partial sequence	blastn	37984	383	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. SL2
1092521	1092521	PRJNA450343_P_NODE_861_length_613_cov_3.556738_g105_i1	PRJNA450343	861	613	3.556738	21.80280394	Oxalobacteraceae	75682	Bacteria	Bacteria	544	8.22e-150	NTclustered	gi\|2459474170\|gb\|CP119520.1\|	34071	g105	i1	84.348	344.913539967374	575	68	93	13	41	613	1102638	1103192	Telluria mixta strain ACM 1762 chromosome, complete genome	blastn	211432	549	0.990892531876138	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Telluria	Telluria mixta
3643529	3643529	PRJNA450343_P_NODE_7803_length_193_cov_1.840278_g7735_i0	PRJNA450343	7803	193	1.840278	3.55173654	Comamonadaceae	80864	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|1593334796\|gb\|CP037867.1\|	47421	g7735	i0	100	215.00518134715	193	0	100	0	1	193	3257185	3256993	Hydrogenophaga pseudoflava strain DSM 1084 chromosome, complete genome	blastn	41496	357	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hydrogenophaga	Hydrogenophaga pseudoflava
4266080	4266080	PRJNA450343_P_NODE_4664_length_246_cov_0.984772_g4596_i0	PRJNA450343	4664	246	0.984772	2.42253912	Aeromonas veronii	654	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1987851774\|gb\|CP070205.1\|	654	g4596	i0	100	100.833333333333	246	0	100	0	1	246	1288526	1288771	Aeromonas veronii strain Colony604 chromosome	blastn	24805	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
5542869	5542869	PRJNA450343_P_NODE_5825_length_221_cov_1.813953_g5757_i0	PRJNA450343	5825	221	1.813953	4.00883613	Pseudomonas oryzae	1392877	Bacteria	Bacteria	387	4.729999999999998e-103	NTclustered	gi\|1085834887\|emb\|LT629751.1\|	1392877	g5757	i0	98.19	401.710407239819	221	4	100	0	1	221	610114	610334	Pseudomonas oryzae strain KCTC 32247 genome assembly, chromosome: I	blastn	88778	387	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas oryzae
8092283	8092283	PRJNA450343_P_NODE_9447_length_177_cov_1.945312_g9379_i0	PRJNA450343	9447	177	1.945312	3.44320224	Rhodovastum atsumiense	504468	Bacteria	Bacteria	270	3.7899999999999986e-68	NTclustered	gi\|2234009978\|emb\|OW485601.1\|	504468	g9379	i0	94.35	332.141242937853	177	9	100	1	1	177	109036	109211	Rhodovastum atsumiense strain G2-11 genome assembly, chromosome: RHOA	blastn	58789	270	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Rhodovastum	Rhodovastum atsumiense
10020726	10020726	PRJNA450343_P_NODE_9928_length_173_cov_0.822581_g9860_i0	PRJNA450343	9928	173	0.822581	1.42306513	Pseudomonas	286	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2090491025\|dbj\|LC649993.1\|	306	g9860	i0	100	119.936416184971	173	0	100	0	1	173	182	10	Pseudomonas sp. NKN_5_28 gene for 16S rRNA, partial sequence	blastn	20749	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp.
10642891	10642891	PRJNA450343_P_NODE_12309_length_164_cov_0.886957_g12241_i0	PRJNA450343	12309	164	0.886957	1.45460948	Bacterioplanes sanyensis	1249553	Bacteria	Bacteria	169	1.3000000000000001e-37	NTclustered	gi\|1226114968\|gb\|CP022530.1\|	1249553	g12241	i0	85.542	157.128048780488	166	19	100	5	1	164	1257455	1257617	Bacterioplanes sanyensis strain NV9, complete genome	blastn	25769	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Oceanospirillaceae	Bacterioplanes	Bacterioplanes sanyensis
13846035	13846035	PRJNA450343_P_NODE_13631_length_161_cov_1.821429_g13563_i0	PRJNA450343	13631	161	1.821429	2.93250069	Neisseria	482	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1373029274\|gb\|CP028150.1\|	488	g13563	i0	100	372.006211180124	161	0	100	0	1	161	76772	76932	Neisseria mucosa strain ATCC 19696 chromosome, complete genome	blastn	59893	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria mucosa
15741662	15741662	PRJNA450343_P_NODE_12493_length_164_cov_0.886957_g12425_i0	PRJNA450343	12493	164	0.886957	1.45460948	Faucicola osloensis	34062	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|1943280950\|gb\|CP065751.1\|	34062	g12425	i0	99.39	15.7560975609756	164	1	100	0	1	164	2434961	2434798	Moraxella osloensis strain FDAARGOS_870 chromosome, complete genome	blastn	2584	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
15741663	15741663	PRJNA450343_P_NODE_12753_length_163_cov_0.894737_g12685_i0	PRJNA450343	12753	163	0.894737	1.45842131	Hyphomicrobium denitrificans	53399	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|299523359\|gb\|CP002083.1\|	582899	g12685	i0	100	1.92638036809816	163	0	100	0	1	163	3360175	3360013	Hyphomicrobium denitrificans ATCC 51888 chromosome, complete genome	blastn	314	302	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Hyphomicrobiaceae	Hyphomicrobium	Hyphomicrobium denitrificans
17016399	17016399	PRJNA450343_P_NODE_7854_length_193_cov_1.062500_g7786_i0	PRJNA450343	7854	193	1.0625	2.050625	Methylomonas sp. AM2-LC	3153301	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2737232881\|gb\|CP157005.1\|	3153301	g7786	i0	100	0.145077720207254	28	0	15	0	11	38	2040977	2040950	Methylomonas sp. AM2-LC chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales	Methylococcaceae	Methylomonas	Methylomonas sp. AM2-LC
18290682	18290682	PRJNA450343_P_NODE_12055_length_165_cov_0.879310_g11987_i0	PRJNA450343	12055	165	0.87931	1.4508615	Aquaspirillum sp. LM1	1938604	Bacteria	Bacteria	244	2.12e-60	NTclustered	gi\|1148310490\|gb\|CP019509.1\|	1938604	g11987	i0	93.333	350.690909090909	165	11	100	0	1	165	430688	430852	Aquaspirillum sp. LM1 chromosome, complete genome	blastn	57864	244	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Aquaspirillaceae	Aquaspirillum	Aquaspirillum sp. LM1
18290695	18290695	PRJNA450343_P_NODE_1575_length_442_cov_2.720102_g1507_i0	PRJNA450343	1575	442	2.720102	12.02285084	Rubrivivax gelatinosus	28068	Bacteria	Bacteria	736	0	NTclustered	gi\|2916315737\|gb\|CP181387.1\|	28068	g1507	i0	96.629	186.303167420814	445	12	100	3	1	442	1300235	1299791	Mutant Rubrivivax gelatinosus isolate AJ1, complete genome	blastn	82346	736	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Rubrivivax	Rubrivivax gelatinosus
18943978	18943978	PRJNA450343_P_NODE_1215_length_505_cov_7.508772_g1147_i0	PRJNA450343	1215	505	7.508772	37.9192986	Acinetobacter	469	Bacteria	Bacteria	867	0	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g1147	i0	97.996	605.249504950495	499	10	99	0	4	502	27006	27504	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	305651	867	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
18943980	18943980	PRJNA450343_P_NODE_12375_length_164_cov_0.886957_g12307_i0	PRJNA450343	12375	164	0.886957	1.45460948	Sphingopyxis	165697	Bacteria	Bacteria	150	4.72e-32	NTclustered	gi\|2210030175\|gb\|CP093335.1\|	267128	g12307	i0	85.034	24.8048780487805	147	22	90	0	1	147	1752882	1753028	Sphingopyxis granuli strain A2-E30 chromosome, complete genome	blastn	4068	150	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis granuli
18943986	18943986	PRJNA450343_P_NODE_2555_length_339_cov_2.272414_g2487_i0	PRJNA450343	2555	339	2.272414	7.70348346	Pseudomonas	286	Bacteria	Bacteria	621	1.95e-173	NTclustered	gi\|2703326990\|gb\|CP148752.1\|	294	g2487	i0	99.705	599.563421828909	339	1	100	0	1	339	739158	739496	Pseudomonas fluorescens strain AB1 chromosome, complete genome	blastn	203252	627	0.990430622009569	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
18943989	18943989	PRJNA450343_P_NODE_3735_length_276_cov_1.215859_g3667_i0	PRJNA450343	3735	276	1.215859	3.35577084	Bacteria	2	Bacteria	Bacteria	483	7.589999999999998e-132	NTclustered	gi\|857120193\|gb\|CP011224.1\|	730	g3667	i0	98.195	372.079710144928	277	4	100	1	1	276	1697257	1697533	[Haemophilus] ducreyi strain HD183 chromosome	blastn	102694	483	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	[Haemophilus] ducreyi
24665228	24665228	PRJNA450343_P_NODE_11040_length_167_cov_0.864407_g10972_i0	PRJNA450343	11040	167	0.864407	1.44355969	Sediminicoccus rosea	1225128	Bacteria	Bacteria	143	8.08e-30	NTclustered	gi\|2619757590\|gb\|CP137852.1\|	1225128	g10972	i0	85.507	4.09580838323353	138	18	82	2	1	137	4112054	4112190	Sediminicoccus rosea strain R-30 chromosome, complete genome	blastn	684	143	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Roseomonadaceae	Sediminicoccus	Sediminicoccus rosea
24665273	24665273	PRJNA450343_P_NODE_2920_length_315_cov_1.150376_g2852_i0	PRJNA450343	2920	315	1.150376	3.6236844	Pseudoalteromonas translucida	166935	Bacteria	Bacteria	80.5	1.35e-10	NTclustered	gi\|961461195\|gb\|CP011034.1\|	1315283	g2852	i0	97.826	1.81904761904762	46	1	15	0	17	62	1768324	1768369	Pseudoalteromonas translucida KMM 520 chromosome I, complete sequence	blastn	573	80.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas translucida
25318711	25318711	PRJNA450343_P_NODE_1820_length_408_cov_5.749304_g1752_i0	PRJNA450343	1820	408	5.749304	23.45716032	Oxalobacteraceae	75682	Bacteria	Bacteria	749	0	NTclustered	gi\|1861348618\|gb\|CP049828.1\|	29581	g1752	i0	99.755	554.541666666667	408	1	100	0	1	408	212209	211802	Janthinobacterium lividum strain EIF2 chromosome, complete genome	blastn	226253	749	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium lividum
25318723	25318723	PRJNA450343_P_NODE_7880_length_192_cov_2.510490_g7812_i0	PRJNA450343	7880	192	2.51049	4.8201408	Sphaerotilaceae	2975441	Bacteria	Bacteria	344	2.44e-90	NTclustered	gi\|971166764\|gb\|CP013729.1\|	76731	g7812	i0	98.958	301.854166666667	192	2	100	0	1	192	1976326	1976135	Roseateles depolymerans strain KCTC 42856 chromosome, complete genome	blastn	57956	344	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles depolymerans

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