metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Planctomycetota"

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
2826289	2826289	PRJNA1120203_P_NODE_95383_length_245_cov_0.895349_g94367_i0	PRJNA1120203	95383	245	0.895349	2.19360505	Gimesia panareensis	2527978	Bacteria	Bacteria	169	2.1e-37	NTclustered	gi\|1712695368\|gb\|CP036317.1\|	2527978	g94367	i0	83.422	8.17142857142857	187	25	75	3	57	240	2514442	2514259	Gimesia panareensis strain Pan153 chromosome, complete genome	blastn	2002	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis
4101993	4101993	PRJNA1120203_P_NODE_49224_length_322_cov_2.285141_g48208_i0	PRJNA1120203	49224	322	2.285141	7.35815402	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	442	1.5299999999999995e-119	NTclustered	gi\|242254791\|gb\|FJ844340.1\|	120965	g48208	i0	93.506	95.6273291925466	308	3	96	1	14	321	721	431	Uncultured planctomycete clone PL09-05 16S ribosomal RNA gene, partial sequence	blastn	30792	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5378596	5378596	PRJNA1120203_P_NODE_86285_length_248_cov_0.880000_g85269_i0	PRJNA1120203	86285	248	0.88	2.1824	Phycisphaera sp.	2030824	Bacteria	Bacteria	67.6	8.01e-7	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g85269	i0	95.238	0.310483870967742	42	2	17	0	14	55	1413767	1413726	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	77	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
5378710	5378710	PRJNA1120203_P_NODE_92825_length_246_cov_0.890173_g91809_i0	PRJNA1120203	92825	246	0.890173	2.18982558	Stieleria maiorica	2795974	Bacteria	Bacteria	219	2.07e-52	NTclustered	gi\|1726207917\|gb\|CP036264.1\|	2795974	g91809	i0	85.446	8.8739837398374	213	28	86	3	1	212	3736638	3736428	Stieleria maiorica strain Mal15 chromosome	blastn	2183	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria maiorica
6652783	6652783	PRJNA1120203_P_NODE_46106_length_333_cov_1.184615_g45091_i0	PRJNA1120203	46106	333	1.184615	3.94476795	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	603	6.909999999999999e-168	NTclustered	gi\|383502255\|gb\|JQ860982.1\|	100371	g45091	i0	99.399	101.576576576577	333	1	100	1	1	333	486	817	Uncultured Planctomycetales bacterium clone 14 15th day 16S ribosomal RNA gene, partial sequence	blastn	33825	603	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
6653227	6653227	PRJNA1120203_P_NODE_78906_length_251_cov_0.865169_g77890_i0	PRJNA1120203	78906	251	0.865169	2.17157419	Mariniblastus fucicola	980251	Bacteria	Bacteria	248	2.7e-61	NTclustered	gi\|1730062935\|gb\|CP042912.1\|	980251	g77890	i0	84.585	1.00796812749004	253	35	100	4	1	251	2432906	2432656	Mariniblastus fucicola strain FC18 chromosome, complete genome	blastn	253	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus fucicola
7928122	7928122	PRJNA1120203_P_NODE_66847_length_275_cov_1.326733_g65831_i0	PRJNA1120203	66847	275	1.326733	3.64851575	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	187	6.639999999999998e-43	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g65831	i0	80.315	58.4327272727273	254	44	91	6	7	257	2524056	2523806	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	16069	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
7928378	7928378	PRJNA1120203_P_NODE_86327_length_248_cov_0.880000_g85311_i0	PRJNA1120203	86327	248	0.88	2.1824	Candidatus Brocadia sp.	2172549	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1958017660\|gb\|CP064969.1\|	2172549	g85311	i0	100	4.16532258064516	248	0	100	0	1	248	3163096	3163343	MAG: Candidatus Brocadia sp. isolate Ega_18-Q3-R5-49_MAXAC.112v2 chromosome, complete genome	blastn	1033	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia	Candidatus Brocadia sp.
10478221	10478221	PRJNA1120203_P_NODE_105589_length_241_cov_0.916667_g104573_i0	PRJNA1120203	105589	241	0.916667	2.20916747	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	147	9.67e-31	NTclustered	gi\|2108078657\|gb\|CP070747.1\|	2052180	g104573	i0	87.5	1.06224066390041	128	15	53	1	68	195	4518558	4518684	MAG: Phycisphaerales bacterium isolate bin358 chromosome	blastn	256	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
11753681	11753681	PRJNA1120203_P_NODE_64410_length_281_cov_0.798077_g63394_i0	PRJNA1120203	64410	281	0.798077	2.24259637	Lacipirellula parvula	2650471	Bacteria	Bacteria	233	8.62e-57	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g63394	i0	82.353	88.9964412811388	272	44	96	2	1	270	2778203	2777934	Lacipirellula parvula PX69 DNA, complete genome	blastn	25008	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
19401359	19401359	PRJNA1120203_P_NODE_86256_length_248_cov_0.880000_g85240_i0	PRJNA1120203	86256	248	0.88	2.1824	Paludisphaera borealis	1387353	Bacteria	Bacteria	198	2.7199999999999993e-46	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g85240	i0	92.701	29.4637096774194	137	10	55	0	28	164	3483714	3483578	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	7307	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
24501464	24501464	PRJNA1120203_P_NODE_90180_length_247_cov_0.885057_g89164_i0	PRJNA1120203	90180	247	0.885057	2.18609079	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	230	9.61e-56	NTclustered	gi\|2108078657\|gb\|CP070747.1\|	2052180	g89164	i0	85.981	0.866396761133603	214	30	87	0	1	214	1061534	1061747	MAG: Phycisphaerales bacterium isolate bin358 chromosome	blastn	214	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
25254227	25254227	PRJNA1120203_P_NODE_53960_length_307_cov_3.371795_g52944_i0	PRJNA1120203	53960	307	3.371795	10.35141065	Planctomyces	118	Bacteria	Bacteria	507	5.09e-139	NTclustered	gi\|523452794\|gb\|KF183214.1\|	120965	g52944	i0	97.945	92.8762214983713	292	6	95	0	15	306	757	466	Uncultured planctomycete clone S3-086 16S ribosomal RNA gene, partial sequence	blastn	28513	507	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium

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