metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB50765" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB50765" and tax_superkingdom = "Bacteria"

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
119554	119554	PRJEB50765_P_NODE_1601_length_236_cov_1.733668_g1577_i0	PRJEB50765	1601	236	1.733668	4.09145648	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g1577	i0	100	322.483050847458	236	0	100	0	1	236	848538	848773	Aquabacterium sp. J223 chromosome	blastn	76106	436	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
991330	991330	PRJEB50765_P_NODE_2881_length_163_cov_1.277778_g2857_i0	PRJEB50765	2881	163	1.277778	2.08277814	Cutibacterium	1912216	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2857	i0	95.122	272.331288343558	164	6	100	2	1	163	56714	56876	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	44390	257	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
1393953	1393953	PRJEB50765_P_NODE_1862_length_214_cov_1.858757_g1838_i0	PRJEB50765	1862	214	1.858757	3.97773998	Rheinheimera sp. D18	2545632	Bacteria	Bacteria	294	2.8400000000000003e-75	NTclustered	gi\|1590159087\|gb\|CP037745.1\|	2545632	g1838	i0	91.943	872.275700934579	211	16	99	1	5	214	44822	44612	Rheinheimera sp. D18 chromosome, complete genome	blastn	186667	294	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. D18
1393958	1393958	PRJEB50765_P_NODE_2702_length_169_cov_2.295455_g2678_i0	PRJEB50765	2702	169	2.295455	3.87931895	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g2678	i0	98.81	276.159763313609	168	2	99	0	1	168	1530806	1530973	Undibacterium sp. YM2 DNA, complete genome	blastn	46671	300	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
2266599	2266599	PRJEB50765_P_NODE_322_length_584_cov_3.914077_g303_i0	PRJEB50765	322	584	3.914077	22.85820968	Oxalobacteraceae	75682	Bacteria	Bacteria	826	0	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g303	i0	92.295	489.030821917808	584	41	99	4	2	584	522875	522295	Herbaspirillum seropedicae strain Z69 chromosome	blastn	285594	832	0.992788461538462	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
3945646	3945646	PRJEB50765_P_NODE_2584_length_174_cov_1.496350_g2560_i0	PRJEB50765	2584	174	1.49635	2.603649	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	318	1.31e-82	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g2560	i0	100	486.5	172	0	99	0	1	172	807998	808169	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	84651	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
6497789	6497789	PRJEB50765_P_NODE_1306_length_268_cov_1.727273_g1282_i0	PRJEB50765	1306	268	1.727273	4.62909164	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	401	2.1099999999999995e-107	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g1282	i0	93.704	347.876865671642	270	13	100	3	1	268	1529466	1529733	Undibacterium sp. YM2 DNA, complete genome	blastn	93231	401	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
9046790	9046790	PRJEB50765_P_NODE_2888_length_163_cov_1.111111_g2864_i0	PRJEB50765	2888	163	1.111111	1.81111093	Clostridium baratii	1561	Bacteria	Bacteria	99	1.72e-16	NTclustered	gi\|2695239789\|gb\|CP124319.1\|	1561	g2864	i0	88.889	44.2331288343558	81	8	49	1	84	163	2674388	2674468	Clostridium baratii strain C110 chromosome, complete genome	blastn	7210	99	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium baratii
9919539	9919539	PRJEB50765_P_NODE_2828_length_165_cov_1.203125_g2804_i0	PRJEB50765	2828	165	1.203125	1.98515625	Enterobacteriaceae	543	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g2804	i0	100	664.157575757576	165	0	100	0	1	165	186384	186548	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	109586	305	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9919540	9919540	PRJEB50765_P_NODE_3148_length_155_cov_1.000000_g3124_i0	PRJEB50765	3148	155	1	1.55	Chryseobacterium	59732	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g3124	i0	100	558.316129032258	155	0	100	0	1	155	1757508	1757354	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	86539	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15019158	15019158	PRJEB50765_P_NODE_3272_length_151_cov_2.289474_g3248_i0	PRJEB50765	3272	151	2.289474	3.45710574	FCB group	1783270	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|209365504\|gb\|FJ229291.1\|	77133	g3248	i0	100	105	151	0	100	0	1	151	686	536	Uncultured bacterium clone Hel3ac05 16S ribosomal RNA gene, partial sequence	blastn	15855	279	1	Bacteria								uncultured bacterium
17569185	17569185	PRJEB50765_P_NODE_3134_length_155_cov_1.322034_g3110_i0	PRJEB50765	3134	155	1.322034	2.0491527	root	1	Root_unresolved	Root_unresolved	287	3.21e-73	NTclustered	gi\|238253150\|gb\|GQ047388.1\|	77133	g3110	i0	100	100	155	0	100	0	1	155	1298	1144	Uncultured bacterium clone nbu505f03c1 16S ribosomal RNA gene, partial sequence	blastn	15500	287	1	Bacteria								uncultured bacterium
17569186	17569186	PRJEB50765_P_NODE_3274_length_151_cov_2.070175_g3250_i0	PRJEB50765	3274	151	2.070175	3.12596425	Chryseobacterium	59732	Bacteria	Bacteria	278	1.87e-70	NTclustered	gi\|1276741219\|gb\|CP022986.1\|	1265445	g3250	i0	100	411.258278145695	150	0	99	0	1	150	1203151	1203002	Chryseobacterium camelliae strain Dolsongi-HT1, complete genome	blastn	62100	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
17971114	17971114	PRJEB50765_P_NODE_3215_length_153_cov_1.310345_g3191_i0	PRJEB50765	3215	153	1.310345	2.00482785	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	267	4.1099999999999994e-67	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g3191	i0	98.039	170.888888888889	153	3	100	0	1	153	847785	847633	Aquabacterium sp. J223 chromosome	blastn	26146	267	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
18842921	18842921	PRJEB50765_P_NODE_3075_length_157_cov_1.116667_g3051_i0	PRJEB50765	3075	157	1.116667	1.75316719	Gammaproteobacteria	1236	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2321448847\|gb\|CP107616.1\|	470	g3051	i0	100	583.006369426752	157	0	100	0	1	157	23208	23052	Acinetobacter baumannii strain 1326932 chromosome, complete genome	blastn	91532	291	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
20520448	20520448	PRJEB50765_P_NODE_2257_length_189_cov_1.026316_g2233_i0	PRJEB50765	2257	189	1.026316	1.93973724	[Actinomadura] parvosata	1955412	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1162989368\|gb\|CP017717.1\|	1909395	g2233	i0	100	0.153439153439153	29	0	15	0	19	47	9870514	9870486	[Actinomadura] parvosata subsp. kistnae strain ATCC 55076 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	[Actinomadura] parvosata
21393445	21393445	PRJEB50765_P_NODE_1717_length_225_cov_1.590426_g1693_i0	PRJEB50765	1717	225	1.590426	3.5784585	Pseudomonadota	1224	Bacteria	Bacteria	416	6.159999999999998e-112	NTclustered	gi\|1216866955\|gb\|MF498461.1\|	77133	g1693	i0	100	99.9911111111111	225	0	100	0	1	225	3	227	Uncultured bacterium clone W6-41 16S ribosomal RNA gene, partial sequence	blastn	22498	416	1	Bacteria								uncultured bacterium
22668241	22668241	PRJEB50765_P_NODE_2798_length_166_cov_0.899225_g2774_i0	PRJEB50765	2798	166	0.899225	1.4927135	root	1	Root_unresolved	Root_unresolved	252	1.28e-62	NTclustered	gi\|1880693168\|gb\|MT807336.1\|	1306	g2774	i0	93.976	103	166	10	100	0	1	166	247	82	Streptococcus sp. strain 365.2 16S ribosomal RNA gene, partial sequence	blastn	17098	252	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
25217449	25217449	PRJEB50765_P_NODE_2500_length_178_cov_1.021277_g2476_i0	PRJEB50765	2500	178	1.021277	1.81787306	Microbacteriaceae	85023	Bacteria	Bacteria	283	4.909999999999999e-72	NTclustered	gi\|2067841284\|gb\|CP076352.1\|	33013	g2476	i0	95.506	203.674157303371	178	7	100	1	1	178	2138059	2137883	Clavibacter michiganensis subsp. michiganensis strain VQ143 chromosome, complete genome	blastn	36254	283	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis

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