metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA890871" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA890871" and tax_clade = "PVC group"

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
864626	864626	PRJNA890871_P_NODE_46681_length_271_cov_1.964646_g46546_i0	PRJNA890871	46681	271	1.964646	5.32419066	Planctopirus ephydatiae	2528019	Bacteria	Bacteria	224	4.979999999999999e-54	NTclustered	gi\|1712709119\|gb\|CP036299.1\|	2528019	g46546	i0	81.685	1.00738007380074	273	46	100	4	1	271	3013627	3013897	Planctopirus ephydatiae strain spb1 chromosome, complete genome	blastn	273	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
864739	864739	PRJNA890871_P_NODE_51981_length_264_cov_1.387435_g51846_i0	PRJNA890871	51981	264	1.387435	3.6628284	Lacipirellula parvula	2650471	Bacteria	Bacteria	300	7.8e-77	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g51846	i0	87.938	1.09848484848485	257	27	97	4	9	264	1725205	1725458	Lacipirellula parvula PX69 DNA, complete genome	blastn	290	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
2140480	2140480	PRJNA890871_P_NODE_70462_length_248_cov_0.880000_g70327_i0	PRJNA890871	70462	248	0.88	2.1824	Lacipirellula parvula	2650471	Bacteria	Bacteria	102	2.2e-17	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g70327	i0	98.276	0.233870967741935	58	1	23	0	191	248	1556904	1556961	Lacipirellula parvula PX69 DNA, complete genome	blastn	58	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
2140703	2140703	PRJNA890871_P_NODE_83582_length_242_cov_0.911243_g83447_i0	PRJNA890871	83582	242	0.911243	2.20520806	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	207	4.4e-49	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g83447	i0	83.478	2.44628099173554	230	31	93	4	7	231	4608598	4608371	Planctomyces sp. SH-PL62, complete genome	blastn	592	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
5967646	5967646	PRJNA890871_P_NODE_35965_length_290_cov_1.396313_g35830_i0	PRJNA890871	35965	290	1.396313	4.0493077	Lacipirellula parvula	2650471	Bacteria	Bacteria	261	4.1e-65	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g35830	i0	83	1.03448275862069	300	40	100	7	1	290	5019812	5019514	Lacipirellula parvula PX69 DNA, complete genome	blastn	300	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
5968431	5968431	PRJNA890871_P_NODE_77645_length_244_cov_2.409357_g77510_i0	PRJNA890871	77645	244	2.409357	5.87883108	Lacipirellula parvula	2650471	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g77510	i0	94.672	3.37295081967213	244	13	100	0	1	244	5052600	5052357	Lacipirellula parvula PX69 DNA, complete genome	blastn	823	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
9792430	9792430	PRJNA890871_P_NODE_41208_length_280_cov_1.483092_g41073_i0	PRJNA890871	41208	280	1.483092	4.1526576	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	250	8.52e-62	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g41073	i0	83.712	0.942857142857143	264	43	94	0	1	264	370210	370473	Luteolibacter sp. SL250 chromosome	blastn	264	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
14893232	14893232	PRJNA890871_P_NODE_83072_length_242_cov_1.366864_g82937_i0	PRJNA890871	83072	242	1.366864	3.30781088	Lacipirellula parvula	2650471	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g82937	i0	83.871	0.256198347107438	62	6	25	4	67	126	355988	355929	Lacipirellula parvula PX69 DNA, complete genome	blastn	62	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
17441889	17441889	PRJNA890871_P_NODE_14894_length_411_cov_5.603550_g14759_i0	PRJNA890871	14894	411	5.60355	23.0305905	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	106	2.99e-18	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g14759	i0	96.825	14.1849148418491	63	2	15	0	346	408	1727738	1727676	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	5830	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
17820025	17820025	PRJNA890871_P_NODE_38114_length_286_cov_1.169014_g37979_i0	PRJNA890871	38114	286	1.169014	3.34338004	Gemmata	113	Bacteria	Bacteria	483	7.909999999999998e-132	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g37979	i0	97.193	37.1923076923077	285	8	99	0	1	285	3153058	3153342	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	10637	483	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18716733	18716733	PRJNA890871_P_NODE_88275_length_237_cov_2.390244_g88140_i0	PRJNA890871	88275	237	2.390244	5.66487828	Gemmataceae bacterium	2052164	Bacteria	Bacteria	322	1.47e-83	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g88140	i0	91.775	0.974683544303797	231	19	97	0	7	237	3742240	3742010	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	231	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19991715	19991715	PRJNA890871_P_NODE_72356_length_247_cov_0.885057_g72221_i0	PRJNA890871	72356	247	0.885057	2.18609079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	329	9.21e-86	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g72221	i0	90.688	1.89878542510121	247	23	100	0	1	247	6333035	6332789	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	469	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
20369120	20369120	PRJNA890871_P_NODE_81996_length_243_cov_0.905882_g81861_i0	PRJNA890871	81996	243	0.905882	2.20129326	Gemmata	113	Bacteria	Bacteria	379	8.849999999999998e-101	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g81861	i0	94.694	5.8641975308642	245	11	100	2	1	243	932480	932236	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1425	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23816955	23816955	PRJNA890871_P_NODE_55059_length_260_cov_1.427807_g54924_i0	PRJNA890871	55059	260	1.427807	3.7122982	Gemmataceae bacterium	2052164	Bacteria	Bacteria	222	1.71e-53	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g54924	i0	82.422	0.984615384615385	256	43	98	2	5	259	4017395	4017141	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	256	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;