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

11 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax_phylum = "Verrucomicrobiota"

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
2004062	2004062	PRJNA752278_P_NODE_69762_length_258_cov_2.064865_g69559_i0	PRJNA752278	69762	258	2.064865	5.3273517	Prosthecobacter debontii	48467	Bacteria	Bacteria	460	3.29e-125	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g69559	i0	98.837	279.697674418605	258	3	100	0	1	258	2940	3197	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	72162	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
5830469	5830469	PRJNA752278_P_NODE_110465_length_226_cov_2.751634_g110262_i0	PRJNA752278	110465	226	2.751634	6.21869284	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	209	1.13e-49	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g110262	i0	85.096	29.9867256637168	208	27	91	4	1	205	3047782	3047576	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	6777	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
5831666	5831666	PRJNA752278_P_NODE_72945_length_255_cov_2.021978_g72742_i0	PRJNA752278	72945	255	2.021978	5.1560439	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	130	1.04e-25	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g72742	i0	90	2.17254901960784	100	10	39	0	154	253	66933	67032	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	554	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
5832102	5832102	PRJNA752278_P_NODE_97985_length_243_cov_1.952941_g97782_i0	PRJNA752278	97985	243	1.952941	4.74564663	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	139	1.63e-28	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g97782	i0	92.784	14.1440329218107	97	6	40	1	20	116	3187860	3187955	Opitutaceae bacterium TAV5, complete genome	blastn	3437	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
7106869	7106869	PRJNA752278_P_NODE_79406_length_250_cov_2.418079_g79203_i0	PRJNA752278	79406	250	2.418079	6.0451975	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	298	2.63e-76	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g79203	i0	88.446	110.88	251	23	99	6	1	247	915004	915252	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	27720	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
8380117	8380117	PRJNA752278_P_NODE_11087_length_438_cov_2.241096_g10884_i0	PRJNA752278	11087	438	2.241096	9.81600048	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	219	3.94e-52	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g10884	i0	90.361	16.9977168949772	166	16	38	0	1	166	3216206	3216371	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	7445	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8381006	8381006	PRJNA752278_P_NODE_54427_length_273_cov_1.395000_g54224_i0	PRJNA752278	54427	273	1.395	3.80835	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	324	4.81e-84	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g54224	i0	89.189	6.37728937728938	259	28	95	0	15	273	3216454	3216196	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1741	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12207023	12207023	PRJNA752278_P_NODE_47150_length_280_cov_1.304348_g46947_i0	PRJNA752278	47150	280	1.304348	3.6521744	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	196	1.13e-45	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g46947	i0	87.283	0.617857142857143	173	21	61	1	107	278	291095	290923	Lacunisphaera limnophila strain IG16b, complete genome	blastn	173	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
16030971	16030971	PRJNA752278_P_NODE_8993_length_472_cov_15.090226_g8790_i0	PRJNA752278	8993	472	15.090226	71.22586672	Akkermansia sp. BCRC 18949	3037987	Bacteria	Bacteria	69.4	4.56e-7	NTclustered	gi\|2853145803\|gb\|CP123619.1\|	3037987	g8790	i0	86.364	0.139830508474576	66	5	14	3	340	404	2273171	2273109	Akkermansia sp. BCRC 18949 chromosome, complete genome	blastn	66	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. BCRC 18949
21130811	21130811	PRJNA752278_P_NODE_81797_length_249_cov_3.687500_g81594_i0	PRJNA752278	81797	249	3.6875	9.181875	Verrucomicrobia bacterium S94	2488809	Bacteria	Bacteria	113	1.02e-20	NTclustered	gi\|1580986208\|gb\|CP036201.1\|	2488809	g81594	i0	100	34.2449799196787	61	0	24	0	175	235	343331	343271	Verrucomicrobia bacterium S94 chromosome, complete genome	blastn	8527	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium S94
23680973	23680973	PRJNA752278_P_NODE_69979_length_258_cov_1.664865_g69776_i0	PRJNA752278	69979	258	1.664865	4.2953517	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	137	6.300000000000001e-28	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g69776	i0	85.938	40.8372093023256	128	18	50	0	54	181	1047813	1047940	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	10536	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717

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