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

17 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
1283971	1283971	PRJDB4470_P_NODE_65782_length_232_cov_1.103825_g64627_i0	PRJDB4470	65782	232	1.103825	2.560874	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	230	8.929999999999999e-56	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g64627	i0	84.848	37.9353448275862	231	32	99	3	1	230	3047922	3047694	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	8801	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
1284059	1284059	PRJDB4470_P_NODE_76182_length_206_cov_3.560510_g75027_i0	PRJDB4470	76182	206	3.56051	7.3346506	Polystyrenella longa	2528007	Bacteria	Bacteria	215	2.17e-51	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g75027	i0	87.912	42.9708737864078	182	22	88	0	4	185	1415656	1415475	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	8852	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
3835880	3835880	PRJDB4470_P_NODE_67284_length_227_cov_3.129213_g66129_i0	PRJDB4470	67284	227	3.129213	7.10331351	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g66129	i0	100	0.127753303964758	29	0	13	0	178	206	1818139	1818111	Lacunisphaera limnophila strain IG16b, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
6387971	6387971	PRJDB4470_P_NODE_66066_length_231_cov_1.401099_g64911_i0	PRJDB4470	66066	231	1.401099	3.23653869	Bremerella sp. P1	3026424	Bacteria	Bacteria	222	1.4899999999999999e-53	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g64911	i0	93.333	1.94805194805195	150	10	65	0	66	215	2122794	2122645	Bremerella sp. P1 chromosome, complete genome	blastn	450	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
7662053	7662053	PRJDB4470_P_NODE_67487_length_227_cov_1.432584_g66332_i0	PRJDB4470	67487	227	1.432584	3.25196568	Fontisphaera persica	2974023	Bacteria	Bacteria	231	2.4199999999999997e-56	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g66332	i0	85.345	12.9471365638767	232	24	100	10	1	227	3862168	3862394	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	2939	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
8936460	8936460	PRJDB4470_P_NODE_41128_length_337_cov_1.625000_g39976_i0	PRJDB4470	41128	337	1.625	5.47625	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	335	2.819999999999999e-87	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g39976	i0	85.583	208.522255192878	326	40	97	4	1	326	1867539	1867221	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	70272	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
8936475	8936475	PRJDB4470_P_NODE_42948_length_326_cov_2.870036_g41795_i0	PRJDB4470	42948	326	2.870036	9.35631736	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	569	6.839999999999998e-158	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g41795	i0	98.16	163.70245398773	326	6	100	0	1	326	345	670	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	53367	569	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
10212695	10212695	PRJDB4470_P_NODE_83289_length_193_cov_1.416667_g82134_i0	PRJDB4470	83289	193	1.416667	2.73416731	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	228	2.579999999999999e-55	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g82134	i0	90.698	30.5233160621762	172	14	89	2	1	171	5085671	5085501	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	5891	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
12762855	12762855	PRJDB4470_P_NODE_22491_length_502_cov_1.962472_g21370_i0	PRJDB4470	22491	502	1.962472	9.85160944	Bremerella sp. P1	3026424	Bacteria	Bacteria	640	8.229999999999999e-179	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g21370	i0	91.102	2.77290836653386	472	42	94	0	17	488	318591	318120	Bremerella sp. P1 chromosome, complete genome	blastn	1392	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
15009186	15009186	PRJDB4470_P_NODE_36092_length_370_cov_1.535826_g34940_i0	PRJDB4470	36092	370	1.535826	5.6825562	Bremerella	2714594	Bacteria	Bacteria	231	4.209999999999998e-56	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g34940	i0	78.628	166.745945945946	379	59	99	19	1	363	2674318	2674690	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	61696	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
15311805	15311805	PRJDB4470_P_NODE_56433_length_263_cov_1.144860_g55278_i0	PRJDB4470	56433	263	1.14486	3.0109818	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	2.8499999999999997e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g55278	i0	83.955	140.285171102662	268	34	100	9	1	263	320151	320414	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	36895	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
15311830	15311830	PRJDB4470_P_NODE_59693_length_251_cov_1.514851_g58538_i0	PRJDB4470	59693	251	1.514851	3.80227601	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	375	1.1899999999999998e-99	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g58538	i0	93.625	161.99203187251	251	16	100	0	1	251	1301779	1302029	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	40660	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15312044	15312044	PRJDB4470_P_NODE_85793_length_189_cov_1.407143_g84638_i0	PRJDB4470	85793	189	1.407143	2.65950027	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	233	5.399999999999999e-57	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g84638	i0	88.889	188.936507936508	189	21	100	0	1	189	4467690	4467502	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	35709	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
16586267	16586267	PRJDB4470_P_NODE_3134_length_1280_cov_15.156783_g2697_i0	PRJDB4470	3134	1280	15.156783	194.0068224	Fontisphaera persica	2974023	Bacteria	Bacteria	1085	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g2697	i0	85.377	168.49453125	1060	139	82	10	179	1225	3862490	3861434	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	215673	1085	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
17861091	17861091	PRJDB4470_P_NODE_17935_length_574_cov_6.099048_g16864_i0	PRJDB4470	17935	574	6.099048	35.00853552	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	244	8.71e-60	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g16864	i0	78.607	247.905923344948	402	63	67	16	50	436	582	189	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	142298	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
19135181	19135181	PRJDB4470_P_NODE_57696_length_258_cov_1.679426_g56541_i0	PRJDB4470	57696	258	1.679426	4.33291908	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g56541	i0	94.286	0.255813953488372	35	2	14	0	90	124	99609	99643	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	66	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
22658326	22658326	PRJDB4470_P_NODE_49278_length_293_cov_1.934426_g48125_i0	PRJDB4470	49278	293	1.934426	5.66786818	Phycisphaerae	666505	Bacteria	Bacteria	375	1.4199999999999998e-99	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g48125	i0	89.796	88.5529010238908	294	28	100	2	1	293	1831011	1831303	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	25946	377	0.994694960212202	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales 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);;