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

13 rows where analysis = "blastn", bioproject = "PRJNA680334" 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
1926115	1926115	PRJNA680334_S_NODE_57162_length_184_cov_1.953642_g56676_i0	PRJNA680334	57162	184	1.953642	3.59470128	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	303	3.92e-78	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g56676	i0	96.739	215.298913043478	184	2	99	3	1	183	1155550	1155730	Planctomyces sp. SH-PL62, complete genome	blastn	39615	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
3721141	3721141	PRJNA680334_S_NODE_82443_length_163_cov_4.753846_g81957_i0	PRJNA680334	82443	163	4.753846	7.74876898	Verrucomicrobium	2735	Bacteria	Bacteria	200	4.589999999999999e-47	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g81957	i0	89.441	168.39263803681	161	14	98	2	1	159	347	506	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	27448	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
7027911	7027911	PRJNA680334_S_NODE_15246_length_276_cov_8.242798_g14760_i0	PRJNA680334	15246	276	8.242798	22.75012248	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	196	1.11e-45	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g14760	i0	80.135	1.07608695652174	297	31	99	18	1	273	1818519	1818811	Luteolibacter sp. SL250 chromosome	blastn	297	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7028596	7028596	PRJNA680334_S_NODE_51966_length_189_cov_9.455128_g51480_i0	PRJNA680334	51966	189	9.455128	17.87019192	Caulifigura coniformis	2527983	Bacteria	Bacteria	335	1.4399999999999993e-87	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g51480	i0	98.93	12.6825396825397	187	2	99	0	1	187	2924863	2924677	Caulifigura coniformis strain Pan44 chromosome	blastn	2397	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
8303756	8303756	PRJNA680334_S_NODE_84007_length_162_cov_4.775194_g83521_i0	PRJNA680334	84007	162	4.775194	7.73581428	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g83521	i0	91.772	278.530864197531	158	13	98	0	5	162	2190	2347	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	45122	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
10097975	10097975	PRJNA680334_S_NODE_45528_length_197_cov_7.829268_g45042_i0	PRJNA680334	45528	197	7.829268	15.42365796	Planctomycetia	203683	Bacteria	Bacteria	182	2.09e-41	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g45042	i0	83.77	27.5736040609137	191	31	97	0	1	191	5093571	5093761	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	5432	183	0.994535519125683	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
10853959	10853959	PRJNA680334_S_NODE_49429_length_192_cov_8.088050_g48943_i0	PRJNA680334	49429	192	8.08805	15.529056	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g48943	i0	100	0.3125	29	0	15	0	150	178	6896188	6896160	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	60	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
13404544	13404544	PRJNA680334_S_NODE_87511_length_160_cov_3.897638_g87025_i0	PRJNA680334	87511	160	3.897638	6.2362208	Humisphaera borealis	2807512	Bacteria	Bacteria	241	2.6400000000000007e-59	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g87025	i0	94.304	85.83125	158	8	99	1	1	158	5062835	5062679	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	13733	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
17227585	17227585	PRJNA680334_S_NODE_30554_length_223_cov_6.284211_g30068_i0	PRJNA680334	30554	223	6.284211	14.01379053	Luteolibacter sp.	1962973	Bacteria	Bacteria	351	1.74e-92	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g30068	i0	95.853	199.856502242152	217	9	97	0	7	223	1009882	1010098	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	44568	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18501351	18501351	PRJNA680334_S_NODE_10115_length_313_cov_7.096429_g9629_i0	PRJNA680334	10115	313	7.096429	22.21182277	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	217	9.81e-52	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g9629	i0	80	47.3546325878594	320	42	97	19	1	305	5627106	5627418	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	14822	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
19776154	19776154	PRJNA680334_S_NODE_16676_length_269_cov_3.169492_g16190_i0	PRJNA680334	16676	269	3.169492	8.52593348	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	268	2.2499999999999994e-67	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g16190	i0	84.982	285.650557620818	273	32	100	7	1	269	1346	1079	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	76840	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
19776536	19776536	PRJNA680334_S_NODE_38156_length_208_cov_12.805714_g37670_i0	PRJNA680334	38156	208	12.805714	26.63588512	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2621786302\|emb\|OY782760.1\|	2026780	g37670	i0	100	0.134615384615385	28	0	13	0	10	37	2644891	2644864	MAG: Planctomycetota bacterium isolate 4c5731f0-34ce-4739-be05-23ee86c4296e genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23602422	23602422	PRJNA680334_S_NODE_29859_length_225_cov_3.447917_g29373_i0	PRJNA680334	29859	225	3.447917	7.75781325	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	244	3.08e-60	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g29373	i0	86.222	278.053333333333	225	31	100	0	1	225	266618	266394	Tautonia plasticadhaerens strain ElP chromosome	blastn	62562	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens

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