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

10 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
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
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
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
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
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);;