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

19 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax_phylum = "Myxococcota"

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
3295202	3295202	PRJNA763243_P_NODE_68143_length_228_cov_2.541935_g67797_i0	PRJNA763243	68143	228	2.541935	5.7956118	Labilithrix luteola	1391654	Bacteria	Bacteria	316	6.53e-82	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67797	i0	91.703	148.456140350877	229	17	100	2	1	228	3944163	3943936	Labilithrix luteola strain DSM 27648, complete genome	blastn	33848	316	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4572342	4572342	PRJNA763243_P_NODE_71124_length_215_cov_4.401408_g70778_i0	PRJNA763243	71124	215	4.401408	9.4630272	Labilithrix luteola	1391654	Bacteria	Bacteria	340	3.609999999999999e-89	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g70778	i0	95.755	135.246511627907	212	8	98	1	4	214	7089328	7089539	Labilithrix luteola strain DSM 27648, complete genome	blastn	29078	340	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5033475	5033475	PRJNA763243_P_NODE_3344_length_740_cov_40.583208_g3065_i0	PRJNA763243	3344	740	40.583208	300.3157392	Anaeromyxobacter	161492	Bacteria	Bacteria	824	0	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g3065	i0	96.407	177.105405405405	501	17	99	1	237	737	1109	610	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	131058	832	0.990384615384615	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
7121692	7121692	PRJNA763243_P_NODE_26006_length_318_cov_3.167347_g25660_i0	PRJNA763243	26006	318	3.167347	10.07216346	Labilithrix luteola	1391654	Bacteria	Bacteria	521	1.8899999999999994e-143	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g25660	i0	96.226	194.691823899371	318	12	100	0	1	318	3942348	3942665	Labilithrix luteola strain DSM 27648, complete genome	blastn	61912	521	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8396320	8396320	PRJNA763243_P_NODE_31007_length_305_cov_3.288793_g30661_i0	PRJNA763243	31007	305	3.288793	10.03081865	Minicystis rosea	888845	Bacteria	Bacteria	361	4.1599999999999996e-95	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g30661	i0	88.274	158.983606557377	307	29	99	6	4	305	768833	769137	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	48490	361	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
10947569	10947569	PRJNA763243_P_NODE_47089_length_260_cov_2.406417_g46743_i0	PRJNA763243	47089	260	2.406417	6.2566842	Labilithrix luteola	1391654	Bacteria	Bacteria	246	1.01e-60	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g46743	i0	86.726	264.261538461538	226	24	86	6	1	223	3942134	3941912	Labilithrix luteola strain DSM 27648, complete genome	blastn	68708	246	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12223100	12223100	PRJNA763243_P_NODE_46630_length_261_cov_2.430851_g46284_i0	PRJNA763243	46630	261	2.430851	6.34452111	Nannocystis pusilla	889268	Bacteria	Bacteria	409	1.23e-109	NTclustered	gi\|1386873113\|gb\|MF774780.1\|	889268	g46284	i0	95.331	115.35632183908	257	12	98	0	3	259	62	318	Nannocystis pusilla strain Na p29 23S ribosomal RNA gene, partial sequence	blastn	30108	409	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
16045657	16045657	PRJNA763243_P_NODE_27773_length_311_cov_1.407563_g27427_i0	PRJNA763243	27773	311	1.407563	4.37752093	Labilithrix luteola	1391654	Bacteria	Bacteria	412	1.1599999999999999e-110	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27427	i0	90.909	160.810289389068	308	27	99	1	4	311	3943986	3944292	Labilithrix luteola strain DSM 27648, complete genome	blastn	50012	412	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16508045	16508045	PRJNA763243_P_NODE_25393_length_321_cov_4.883065_g25047_i0	PRJNA763243	25393	321	4.883065	15.67463865	Sorangium	39643	Bacteria	Bacteria	472	1.95e-128	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g25047	i0	94.463	120.485981308411	307	16	95	1	13	318	1505	1199	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	38676	472	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18595186	18595186	PRJNA763243_P_NODE_50875_length_252_cov_14.201117_g50529_i0	PRJNA763243	50875	252	14.201117	35.78681484	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	350	7.24e-92	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g50529	i0	92	183.944444444444	250	18	99	2	1	249	1383268	1383516	Anaeromyxobacter paludicola DNA, complete genome	blastn	46354	350	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
18595474	18595474	PRJNA763243_P_NODE_62955_length_241_cov_6.297619_g62609_i0	PRJNA763243	62955	241	6.297619	15.17726179	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	427	3.079999999999999e-115	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g62609	i0	99.156	243.058091286307	237	2	98	0	5	241	2161783	2161547	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	58577	427	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19057002	19057002	PRJNA763243_P_NODE_43815_length_267_cov_39.309278_g43469_i0	PRJNA763243	43815	267	39.309278	104.95577226	Myxococcales	29	Bacteria	Bacteria	375	1.28e-99	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g43469	i0	94.628	211.59925093633	242	13	91	0	25	266	5180873	5181114	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	56497	375	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
19870098	19870098	PRJNA763243_P_NODE_37456_length_283_cov_5.414286_g37110_i0	PRJNA763243	37456	283	5.414286	15.32242938	Archangium violaceum	83451	Bacteria	Bacteria	344	3.85e-90	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g37110	i0	88.968	203.127208480565	281	27	99	4	1	280	2689508	2689785	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	57485	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
20331617	20331617	PRJNA763243_P_NODE_32876_length_297_cov_29.049107_g32530_i0	PRJNA763243	32876	297	29.049107	86.27584779	Anaeromyxobacter	161492	Bacteria	Bacteria	516	8.14e-142	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g32530	i0	98.625	267.087542087542	291	4	98	0	4	294	2969	2679	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	79325	521	0.990403071017274	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20331688	20331688	PRJNA763243_P_NODE_53396_length_250_cov_0.824859_g53050_i0	PRJNA763243	53396	250	0.824859	2.0621475	Myxococcia	32015	Bacteria	Bacteria	399	7.019999999999998e-107	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g53050	i0	97.436	236.28	234	6	94	0	14	247	1549431	1549664	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	59070	401	0.99501246882793	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
21146004	21146004	PRJNA763243_P_NODE_4617_length_650_cov_44.733102_g4303_i0	PRJNA763243	4617	650	44.733102	290.765163	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	946	0	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g4303	i0	93.077	131.610769230769	650	40	99	5	2	649	2981188	2980542	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	85547	946	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
23697107	23697107	PRJNA763243_P_NODE_939_length_1245_cov_9.671502_g784_i0	PRJNA763243	939	1245	9.671502	120.4101999	Minicystis rosea	888845	Bacteria	Bacteria	1565	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g784	i0	89.669	166.853012048193	1239	112	99	15	15	1243	13716537	13715305	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	207732	1565	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
24969649	24969649	PRJNA763243_P_NODE_29440_length_310_cov_3.189873_g29094_i0	PRJNA763243	29440	310	3.189873	9.8886063	uncultured Anaeromyxobacter sp.	293435	Bacteria	Bacteria	272	2.04e-68	NTclustered	gi\|2908992372\|gb\|PV095178.1\|	293435	g29094	i0	99.333	57.2129032258064	150	1	48	0	1	150	173	24	Uncultured Anaeromyxobacter sp. clone c3ad0c817fb9da13ce680cd785298ec3 16S ribosomal RNA gene, partial sequence	blastn	17736	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	uncultured Anaeromyxobacter sp.
25431981	25431981	PRJNA763243_P_NODE_69700_length_222_cov_4.053691_g69354_i0	PRJNA763243	69700	222	4.053691	8.99919402	Myxococcales	29	Bacteria	Bacteria	399	6.099999999999999e-107	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g69354	i0	99.543	241.063063063063	219	1	99	0	1	219	1905	1687	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	53516	399	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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