metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA879314" 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
857947	857947	PRJNA879314_P_NODE_9221_length_245_cov_0.906977_g9171_i0	PRJNA879314	9221	245	0.906977	2.22209365	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	145	3.5499999999999996e-30	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g9171	i0	77.778	33.3877551020408	252	44	100	12	1	245	2556447	2556693	Lacunisphaera limnophila strain IG16b, complete genome	blastn	8180	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
2515947	2515947	PRJNA879314_P_NODE_3242_length_280_cov_1.386473_g3192_i0	PRJNA879314	3242	280	1.386473	3.8821244	PVC group	1783257	Bacteria	Bacteria	239	1.85e-58	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g3192	i0	85.345	87.6428571428571	232	32	83	2	49	279	4289281	4289511	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	24540	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
3408649	3408649	PRJNA879314_P_NODE_3923_length_263_cov_1.526316_g3873_i0	PRJNA879314	3923	263	1.526316	4.01421108	Candidatus Jettenia sp. CY-1	3054210	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2556878231\|gb\|CP129468.1\|	3054210	g3873	i0	100	1.83269961977186	30	0	11	0	68	97	2604411	2604382	MAG: Candidatus Jettenia sp. CY-1 chromosome, complete genome	blastn	482	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Jettenia	Candidatus Jettenia sp. CY-1
5961134	5961134	PRJNA879314_P_NODE_7165_length_249_cov_0.886364_g7115_i0	PRJNA879314	7165	249	0.886364	2.20704636	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	185	2.1299999999999994e-42	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g7115	i0	80.488	37.2530120481928	246	44	98	4	6	249	3330173	3329930	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	9276	185	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium CCUG 44730
8510818	8510818	PRJNA879314_P_NODE_6227_length_250_cov_0.881356_g6177_i0	PRJNA879314	6227	250	0.881356	2.20339	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	189	1.6499999999999999e-43	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g6177	i0	80.4	32.064	250	47	99	2	1	249	532861	533109	Luteolibacter sp. LG18 DNA, complete genome	blastn	8016	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
8510828	8510828	PRJNA879314_P_NODE_6927_length_249_cov_0.886364_g6877_i0	PRJNA879314	6927	249	0.886364	2.20704636	Congregicoccus parvus	3081749	Bacteria	Bacteria	211	3.51e-50	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g6877	i0	84.722	80.6425702811245	216	27	92	5	21	233	4998492	4998704	Opitutales bacterium ASA1 DNA, complete genome	blastn	20080	211	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
9785715	9785715	PRJNA879314_P_NODE_5308_length_252_cov_0.871508_g5258_i0	PRJNA879314	5308	252	0.871508	2.19620016	Opitutus terrae	107709	Bacteria	Bacteria	220	5.919999999999999e-53	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g5258	i0	83.913	5.37301587301587	230	37	91	0	2	231	845863	846092	Opitutus terrae PB90-1, complete genome	blastn	1354	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
13611530	13611530	PRJNA879314_P_NODE_6831_length_249_cov_0.886364_g6781_i0	PRJNA879314	6831	249	0.886364	2.20704636	Opitutus terrae	107709	Bacteria	Bacteria	316	7.239999999999998e-82	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g6781	i0	89.558	60.3935742971888	249	26	100	0	1	249	262205	262453	Opitutus terrae PB90-1, complete genome	blastn	15038	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
14885811	14885811	PRJNA879314_P_NODE_10292_length_243_cov_1.500000_g10242_i0	PRJNA879314	10292	243	1.5	3.645	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	130	9.84e-26	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g10242	i0	86.441	0.753086419753086	118	16	49	0	1	118	3956511	3956628	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	183	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22534567	22534567	PRJNA879314_P_NODE_5598_length_251_cov_0.876404_g5548_i0	PRJNA879314	5598	251	0.876404	2.19977404	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	69.4	2.26e-7	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g5548	i0	90.385	0.207171314741036	52	5	21	0	148	199	727423	727474	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	52	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
23810077	23810077	PRJNA879314_P_NODE_8339_length_247_cov_0.896552_g8289_i0	PRJNA879314	8339	247	0.896552	2.21448344	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	318	1.9899999999999998e-82	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g8289	i0	89.879	5.90283400809717	247	25	100	0	1	247	3686623	3686869	Lacunisphaera limnophila strain IG16b, complete genome	blastn	1458	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila

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