metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA397733" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA397733" and tax_kingdom = "Pseudomonadati"

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
1079932	1079932	PRJNA397733_S_NODE_3181_length_347_cov_4.452830_g3093_i0	PRJNA397733	3181	347	4.45283	15.4513201	Bacteria	2	Bacteria	Bacteria	636	7.13e-178	NTclustered	gi\|1403355347\|emb\|LS483369.1\|	483	g3093	i0	99.712	348.005763688761	347	1	100	0	1	347	1115287	1115633	Neisseria cinerea strain NCTC10294 genome assembly, chromosome: 1	blastn	120758	641	0.992199687987519	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria cinerea
2962884	2962884	PRJNA397733_S_NODE_7583_length_219_cov_3.500000_g7495_i0	PRJNA397733	7583	219	3.5	7.665	Chryseobacterium sp.	1871047	Bacteria	Bacteria	394	2.79e-105	NTclustered	gi\|1757093052\|gb\|CP044507.1\|	1871047	g7495	i0	99.087	457.022831050228	219	2	100	0	1	219	454200	454418	Chryseobacterium sp. strain SNU WT7 chromosome, complete genome	blastn	100088	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
3630688	3630688	PRJNA397733_S_NODE_1963_length_453_cov_12.004717_g1876_i0	PRJNA397733	1963	453	12.004717	54.38136801	Pseudomonas	286	Bacteria	Bacteria	809	0	NTclustered	gi\|2313359605\|gb\|CP104408.1\|	294	g1876	i0	98.896	532.088300220751	453	5	100	0	1	453	29915	30367	Pseudomonas fluorescens strain Ant01 chromosome, complete genome	blastn	241036	809	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
4239184	4239184	PRJNA397733_S_NODE_1944_length_455_cov_8.485915_g1857_i0	PRJNA397733	1944	455	8.485915	38.61091325	Faucicola osloensis	34062	Bacteria	Bacteria	793	0	NTclustered	gi\|2722728872\|dbj\|AP031472.1\|	34062	g1857	i0	99.315	359.98021978022	438	3	96	0	1	438	30639	30202	Moraxella osloensis NBRC 115781 DNA, complete genome	blastn	163791	793	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
4907900	4907900	PRJNA397733_S_NODE_13464_length_166_cov_3.102190_g13376_i0	PRJNA397733	13464	166	3.10219	5.1496354	Cloacibacterium	501783	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g13376	i0	100	476.006024096386	166	0	100	0	1	166	131843	132008	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	79017	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
7457827	7457827	PRJNA397733_S_NODE_7746_length_216_cov_16.475936_g7658_i0	PRJNA397733	7746	216	16.475936	35.58802176	Moraxellaceae	468	Bacteria	Bacteria	399	5.909999999999999e-107	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g7658	i0	100	319.768518518519	216	0	100	0	1	216	1497419	1497634	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	69070	399	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
8732680	8732680	PRJNA397733_S_NODE_11027_length_182_cov_2.764706_g10939_i0	PRJNA397733	11027	182	2.764706	5.03176492	Weeksellaceae	2762318	Bacteria	Bacteria	226	8.619999999999999e-55	NTclustered	gi\|1678513594\|gb\|CP040694.1\|	2583851	g10939	i0	89.888	400.225274725275	178	14	97	4	3	179	648065	648239	Elizabethkingia sp. JS20170427COW chromosome, complete genome	blastn	72841	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia sp. JS20170427COW
8732682	8732682	PRJNA397733_S_NODE_16887_length_150_cov_7.057851_g16799_i0	PRJNA397733	16887	150	7.057851	10.5867765	Enterobacteriaceae	543	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g16799	i0	100	694.026666666667	150	0	100	0	1	150	723	872	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	104104	278	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8732685	8732685	PRJNA397733_S_NODE_2587_length_386_cov_17.098039_g2499_i0	PRJNA397733	2587	386	17.098039	65.99843054	Pseudomonas	286	Bacteria	Bacteria	697	0	NTclustered	gi\|2703326990\|gb\|CP148752.1\|	294	g2499	i0	99.223	561.59067357513	386	3	100	0	1	386	114315	114700	Pseudomonas fluorescens strain AB1 chromosome, complete genome	blastn	216774	702	0.992877492877493	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
11890933	11890933	PRJNA397733_S_NODE_2830_length_368_cov_7.356932_g2742_i0	PRJNA397733	2830	368	7.356932	27.07350976	Acinetobacter variabilis	70346	Bacteria	Bacteria	549	1.0199999999999994e-151	NTclustered	gi\|2213367804\|gb\|CP094246.1\|	70346	g2742	i0	94.872	610.64402173913	351	18	95	0	18	368	2770033	2769683	Acinetobacter variabilis strain BDT2044 chromosome, complete genome	blastn	224717	549	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter variabilis
12558621	12558621	PRJNA397733_S_NODE_12750_length_170_cov_8.127660_g12662_i0	PRJNA397733	12750	170	8.12766	13.817022	Pseudomonadota	1224	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1304837108\|gb\|MF044475.1\|	472	g12662	i0	100	112	170	0	100	0	1	170	148	317	Acinetobacter sp. strain D4 16S ribosomal RNA gene, partial sequence	blastn	19040	315	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter sp.
12558625	12558625	PRJNA397733_S_NODE_15990_length_154_cov_2.600000_g15902_i0	PRJNA397733	15990	154	2.6	4.004	Weeksellaceae	2762318	Bacteria	Bacteria	263	5.36e-66	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g15902	i0	97.403	441.012987012987	154	4	100	0	1	154	2943976	2944129	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	67916	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
12558629	12558629	PRJNA397733_S_NODE_7690_length_217_cov_11.744681_g7602_i0	PRJNA397733	7690	217	11.744681	25.48595777	Moraxellaceae	468	Bacteria	Bacteria	396	7.689999999999997e-106	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g7602	i0	99.539	364.15668202765	217	1	100	0	1	217	1497856	1497640	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	79022	396	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
13833395	13833395	PRJNA397733_S_NODE_11991_length_175_cov_4.020548_g11903_i0	PRJNA397733	11991	175	4.020548	7.035959	Hydrogenophaga	47420	Bacteria	Bacteria	265	1.74e-66	NTclustered	gi\|1796319018\|gb\|CP044549.1\|	2651974	g11903	i0	94.737	162.571428571429	171	8	97	1	1	170	5746769	5746599	Hydrogenophaga sp. BPS33 chromosome, complete genome	blastn	28450	265	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hydrogenophaga	Hydrogenophaga sp. BPS33
16989615	16989615	PRJNA397733_S_NODE_8494_length_206_cov_3.740113_g8406_i0	PRJNA397733	8494	206	3.740113	7.70463278	Haemophilus parahaemolyticus	735	Bacteria	Bacteria	364	2.0399999999999993e-96	NTclustered	gi\|1986026646\|gb\|CP069510.1\|	735	g8406	i0	98.544	581.631067961165	206	3	100	0	1	206	1265227	1265432	Haemophilus parahaemolyticus strain FDAARGOS_1199 chromosome, complete genome	blastn	119816	364	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parahaemolyticus
18931392	18931392	PRJNA397733_S_NODE_16635_length_151_cov_5.344262_g16547_i0	PRJNA397733	16635	151	5.344262	8.06983562	Neisseria	482	Bacteria	Bacteria	257	2.43e-64	NTclustered	gi\|730569312\|gb\|CP009418.1\|	487	g16547	i0	97.351	348.198675496689	151	4	100	0	1	151	1061636	1061486	Neisseria meningitidis strain NM3686, complete genome	blastn	52578	257	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria meningitidis
18931395	18931395	PRJNA397733_S_NODE_7435_length_221_cov_16.338542_g7347_i0	PRJNA397733	7435	221	16.338542	36.10817782	Acinetobacter	469	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g7347	i0	100	683.013574660633	221	0	100	0	1	221	27460	27240	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	150946	409	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
19537992	19537992	PRJNA397733_S_NODE_14476_length_161_cov_2.522727_g14388_i0	PRJNA397733	14476	161	2.522727	4.06159047	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g14388	i0	98.758	408.875776397516	161	2	100	0	1	161	442971	443131	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	65829	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
20206094	20206094	PRJNA397733_S_NODE_14996_length_158_cov_7.457364_g14908_i0	PRJNA397733	14996	158	7.457364	11.78263512	Salmonella	590	Bacteria	Bacteria	281	1.53e-71	NTclustered	gi\|2475988518\|gb\|CP121075.1\|	595	g14908	i0	98.734	694.025316455696	158	2	100	0	1	158	180535	180692	Salmonella enterica subsp. enterica serovar Infantis strain R22.2574 chromosome, complete genome	blastn	109656	281	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
21481594	21481594	PRJNA397733_S_NODE_1517_length_525_cov_11.372984_g1439_i0	PRJNA397733	1517	525	11.372984	59.708166	Neisseria	482	Bacteria	Bacteria	737	0	NTclustered	gi\|1917206562\|gb\|CP062976.1\|	2709396	g1439	i0	92.22	592.358095238095	527	31	100	8	1	525	71188	70670	Neisseria yangbaofengii strain ZJ785 chromosome, complete genome	blastn	310988	737	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria yangbaofengii
21481597	21481597	PRJNA397733_S_NODE_6297_length_240_cov_5.260664_g6209_i0	PRJNA397733	6297	240	5.260664	12.6255936	Acinetobacter	469	Bacteria	Bacteria	422	1.4299999999999998e-113	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g6209	i0	98.333	611.070833333333	240	4	100	0	1	240	1489377	1489616	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	146657	422	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
22088648	22088648	PRJNA397733_S_NODE_15038_length_158_cov_3.449612_g14950_i0	PRJNA397733	15038	158	3.449612	5.45038696	Haemophilus parainfluenzae	729	Bacteria	Bacteria	287	3.29e-73	NTclustered	gi\|1919206354\|gb\|CP063111.1\|	729	g14950	i0	99.367	598.012658227848	158	1	100	0	1	158	388800	388957	Haemophilus parainfluenzae strain M1C152_1 chromosome, complete genome	blastn	94486	287	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
22088649	22088649	PRJNA397733_S_NODE_9438_length_196_cov_2.976048_g9350_i0	PRJNA397733	9438	196	2.976048	5.83305408	Sphingomonas sp. P5-21	428631	Bacteria	Bacteria	335	1.5e-87	NTclustered	gi\|126567495\|dbj\|AB288314.1\|	428631	g9350	i0	97.449	98.3061224489796	196	5	100	0	1	196	1	196	Sphingomonas sp. P5-21 gene for 16S ribosomal RNA, partial sequence	blastn	19268	335	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. P5-21
22756862	22756862	PRJNA397733_S_NODE_8918_length_201_cov_5.494186_g8830_i0	PRJNA397733	8918	201	5.494186	11.04331386	Comamonadaceae	80864	Bacteria	Bacteria	351	1.54e-92	NTclustered	gi\|1972901683\|gb\|CP063167.1\|	34073	g8830	i0	98.5	261.696517412935	200	2	99	1	2	201	487729	487927	Variovorax paradoxus strain VAI-C plasmid unnamed, complete sequence	blastn	52601	351	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
23364200	23364200	PRJNA397733_S_NODE_10979_length_182_cov_4.764706_g10891_i0	PRJNA397733	10979	182	4.764706	8.67176492	Haemophilus parainfluenzae	729	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|1919204515\|gb\|CP063110.1\|	729	g10891	i0	100	597.412087912088	182	0	100	0	1	182	391852	391671	Haemophilus parainfluenzae strain M1C160_1 chromosome, complete genome	blastn	108729	337	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
24031659	24031659	PRJNA397733_S_NODE_15259_length_157_cov_4.531250_g15171_i0	PRJNA397733	15259	157	4.53125	7.1140625	Neisseriaceae	481	Bacteria	Bacteria	237	3.33e-58	NTclustered	gi\|2021766776\|gb\|CP072524.1\|	490	g15171	i0	97.81	320.248407643312	137	3	87	0	21	157	67335	67199	Neisseria sicca strain NS20201025 chromosome, complete genome	blastn	50279	237	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria sicca
24638528	24638528	PRJNA397733_S_NODE_6820_length_231_cov_4.589109_g6732_i0	PRJNA397733	6820	231	4.589109	10.60084179	Comamonadaceae bacterium OTU4NAUVB1	2952996	Bacteria	Bacteria	366	6.49e-97	NTclustered	gi\|2274984632\|gb\|CP099605.1\|	2952996	g6732	i0	95.279	185.419913419913	233	7	100	4	1	231	2832031	2832261	Comamonadaceae bacterium OTU4NAUVB1 chromosome, complete genome	blastn	42832	366	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium OTU4NAUVB1
25306055	25306055	PRJNA397733_S_NODE_1840_length_469_cov_9.065909_g1753_i0	PRJNA397733	1840	469	9.065909	42.51911321	Pseudomonas	286	Bacteria	Bacteria	743	0	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g1753	i0	95.319	569.217484008529	470	18	100	4	1	469	9899	10365	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	266963	749	0.991989319092123	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens

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