metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1002816" 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
152758	152758	PRJNA1002816_P_NODE_10921_length_337_cov_0.882576_g10761_i0	PRJNA1002816	10921	337	0.882576	2.97428112	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	514	3.37e-141	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g10761	i0	94.118	310.727002967359	340	17	100	2	1	337	361028	360689	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	104715	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
152913	152913	PRJNA1002816_P_NODE_19261_length_246_cov_0.890173_g19101_i0	PRJNA1002816	19261	246	0.890173	2.18982558	Plesiomonas shigelloides	703	Bacteria	Bacteria	448	2.4299999999999995e-121	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g19101	i0	100	682.650406504065	242	0	99	0	5	246	335658	335417	Plesiomonas shigelloides strain Colony13 chromosome	blastn	167932	448	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
2276027	2276027	PRJNA1002816_P_NODE_20482_length_242_cov_0.911243_g20322_i0	PRJNA1002816	20482	242	0.911243	2.20520806	Vibrio	662	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2271101951\|dbj\|AP024905.1\|	184755	g20322	i0	100	0.347107438016529	28	0	12	0	162	189	502138	502165	Vibrio ruber LMG 23124 DNA, chromosome 1, complete sequence	blastn	84	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio ruber
2703027	2703027	PRJNA1002816_P_NODE_13443_length_300_cov_1.775330_g13283_i0	PRJNA1002816	13443	300	1.77533	5.32599	Marinobacter sp. MMG032	3158548	Bacteria	Bacteria	159	1.6e-34	NTclustered	gi\|2741296914\|gb\|CP157802.1\|	3158548	g13283	i0	79.386	14.8733333333333	228	45	76	2	74	300	3240152	3239926	Marinobacter sp. MMG032 chromosome, complete genome	blastn	4462	159	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	Marinobacter sp. MMG032
2703070	2703070	PRJNA1002816_P_NODE_15783_length_271_cov_1.545455_g15623_i0	PRJNA1002816	15783	271	1.545455	4.18818305	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2676815323\|gb\|CP144799.1\|	2608262	g15623	i0	100	0.206642066420664	28	0	10	0	178	205	146767	146794	MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome	blastn	56	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
2703294	2703294	PRJNA1002816_P_NODE_9303_length_367_cov_1.418367_g9143_i0	PRJNA1002816	9303	367	1.418367	5.20540689	Plesiomonas shigelloides	703	Bacteria	Bacteria	662	0	NTclustered	gi\|1037176310\|emb\|LT575468.1\|	703	g9143	i0	99.183	705.967302452316	367	3	100	0	1	367	2138623	2138989	Plesiomonas shigelloides strain NCTC10360 genome assembly, chromosome: 1	blastn	259090	662	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
6531049	6531049	PRJNA1002816_P_NODE_17886_length_250_cov_0.870056_g17726_i0	PRJNA1002816	17886	250	0.870056	2.17514	uncultured Macellibacteroides sp.	1243007	Bacteria	Bacteria	176	1.2899999999999999e-39	NTclustered	gi\|2621704019\|emb\|OY762974.1\|	1243007	g17726	i0	79.675	1.92	246	48	98	2	4	248	1595622	1595378	MAG: uncultured Macellibacteroides sp. isolate 8f74f0af-0976-4f32-9dab-69c3ce622fc1 genome assembly, chromosome: 1	blastn	480	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Macellibacteroides	uncultured Macellibacteroides sp.
11204222	11204222	PRJNA1002816_P_NODE_6969_length_429_cov_1.244382_g6809_i0	PRJNA1002816	6969	429	1.244382	5.33839878	Vibrio	662	Bacteria	Bacteria	765	0	NTclustered	gi\|1821214403\|gb\|CP049913.1\|	2714948	g6809	i0	98.834	896.107226107226	429	5	100	0	1	429	1044593	1045021	Vibrio sp. HDW18 chromosome, complete genome	blastn	384430	771	0.992217898832685	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. HDW18
13754287	13754287	PRJNA1002816_P_NODE_15391_length_276_cov_1.413793_g15231_i0	PRJNA1002816	15391	276	1.413793	3.90206868	Escherichia	561	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|2577445669\|gb\|CP115178.1\|	562	g15231	i0	100	58	276	0	100	0	1	276	3014777	3015052	Escherichia coli strain B chromosome, complete genome	blastn	16008	510	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15455436	15455436	PRJNA1002816_P_NODE_12973_length_307_cov_1.316239_g12813_i0	PRJNA1002816	12973	307	1.316239	4.04085373	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g12813	i0	100	0.0912052117263844	28	0	9	0	278	305	1347978	1347951	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
18004481	18004481	PRJNA1002816_P_NODE_11875_length_322_cov_0.879518_g11715_i0	PRJNA1002816	11875	322	0.879518	2.83204796	Plesiomonas shigelloides	703	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g11715	i0	100	776.748447204969	322	0	100	0	1	322	334578	334257	Plesiomonas shigelloides strain Colony13 chromosome	blastn	250113	595	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
18852621	18852621	PRJNA1002816_P_NODE_7595_length_410_cov_1.370920_g7435_i0	PRJNA1002816	7595	410	1.37092	5.620772	Aquirufa	2676247	Bacteria	Bacteria	532	1.15e-146	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g7435	i0	91.371	435.639024390244	394	26	96	6	19	410	360118	359731	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	178612	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
19278498	19278498	PRJNA1002816_P_NODE_21136_length_226_cov_2.117647_g20976_i0	PRJNA1002816	21136	226	2.117647	4.78588222	Candidatus Desulfobacillus denitrificans	2608985	Bacteria	Bacteria	147	8.97e-31	NTclustered	gi\|1996214876\|dbj\|AP021857.1\|	2608985	g20976	i0	81.152	70.0265486725664	191	29	82	3	14	199	1499273	1499085	Candidatus Desulfobacillus denitrificans DNA, complete genome	blastn	15826	147	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria			Candidatus Desulfobacillus	Candidatus Desulfobacillus denitrificans
20127334	20127334	PRJNA1002816_P_NODE_20716_length_241_cov_1.214286_g20556_i0	PRJNA1002816	20716	241	1.214286	2.92642926	root	1	Root_unresolved	Root_unresolved	444	3.06e-120	NTclustered	gi\|922671885\|gb\|KP967513.1\|	703	g20556	i0	100	130.45643153527	240	0	99	0	1	240	7	246	Plesiomonas shigelloides strain M_S_TSA_21-14 16S ribosomal RNA gene, partial sequence	blastn	31440	444	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
20127349	20127349	PRJNA1002816_P_NODE_6576_length_442_cov_2.352304_g6416_i0	PRJNA1002816	6576	442	2.352304	10.39718368	Betaproteobacteria	28216	Bacteria	Bacteria	782	0	NTclustered	gi\|1218526113\|gb\|CP022423.1\|	63	g6416	i0	98.643	203.316742081448	442	5	99	1	2	442	637026	637467	Vitreoscilla filiformis strain ATCC 15551, complete genome	blastn	89866	789	0.991128010139417	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Vitreoscilla	Vitreoscilla filiformis
24378886	24378886	PRJNA1002816_P_NODE_18940_length_247_cov_0.885057_g18780_i0	PRJNA1002816	18940	247	0.885057	2.18609079	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g18780	i0	92.544	362.481781376518	228	15	92	2	21	247	3670	3444	Dyadobacter pollutisoli strain U1 chromosome	blastn	89533	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
24378957	24378957	PRJNA1002816_P_NODE_3520_length_606_cov_1.994371_g3362_i0	PRJNA1002816	3520	606	1.994371	12.08588826	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	920	0	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g3362	i0	94.108	281.42904290429	611	26	100	10	1	606	339346	338741	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	170546	920	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128

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