metadata: contig_metadata: 15 rows where bioproject = "PRJNA400391" and tax

15 rows where bioproject = "PRJNA400391" and tax_phylum = "Campylobacterota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1081054	1081054	PRJNA400391_S_NODE_1181_length_338_cov_48.907591_g1120_i0	PRJNA400391	1181	338	48.907591	165.30765758	Aliarcobacter	2321111	Bacteria	Bacteria	540	5.59e-149	NTclustered	gi\|219846315\|ref\|NR_025905.1\|	28198	g1120	i0	98.68	218.334319526627	303	4	90	0	1	303	305	3	Aliarcobacter cryaerophilus strain A 169/B 16S ribosomal RNA, partial sequence	blastn	73797	545	0.990825688073395	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
2356426	2356426	PRJNA400391_S_NODE_1002_length_357_cov_58.152174_g941_i0	PRJNA400391	1002	357	58.152174	207.60326118	Arcobacteraceae	2808963	Bacteria	Bacteria	588	2.0799999999999998e-163	NTclustered	gi\|290877936\|emb\|FN600702.1\|	28198	g941	i0	96.359	368.050420168067	357	13	100	0	1	357	929	573	Arcobacter cryaerophilus partial 23S rRNA gene, strain LMG 10209, biovar 1B	blastn	131394	588	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
4241169	4241169	PRJNA400391_S_NODE_4324_length_193_cov_2.468354_g4263_i0	PRJNA400391	4324	193	2.468354	4.76392322	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	335	1.48e-87	NTclustered	gi\|346681541\|gb\|JF740655.1\|	120858	g4263	i0	100	310.487046632124	181	0	94	0	13	193	192	12	Uncultured epsilon proteobacterium clone 23S_S3M_218 23S ribosomal RNA gene, partial sequence	blastn	59924	335	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
9342222	9342222	PRJNA400391_S_NODE_288_length_528_cov_26.470588_g234_i0	PRJNA400391	288	528	26.470588	139.76470464	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	750	0	NTclustered	gi\|17530431\|gb\|AF445743.1\|	120858	g234	i0	94.141	90.907196969697	495	26	93	3	36	528	1	494	Uncultured Campylobacterota bacterium clone SM2H05 16S ribosomal RNA gene, partial sequence	blastn	47999	750	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
11284311	11284311	PRJNA400391_S_NODE_2109_length_274_cov_2.573222_g2048_i0	PRJNA400391	2109	274	2.573222	7.05062828	Sulfurimonas	202746	Bacteria	Bacteria	246	1.08e-60	NTclustered	gi\|1765925958\|gb\|CP035534.1\|	2509341	g2048	i0	88.945	167.916058394161	199	22	73	0	74	272	32607	32805	Sulfurimonas hydrogeniphila strain NW10 chromosome, complete genome	blastn	46009	246	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas hydrogeniphila
11284324	11284324	PRJNA400391_S_NODE_29_length_895_cov_92.373256_g19_i0	PRJNA400391	29	895	92.373256	826.7406412	Arcobacter	28196	Bacteria	Bacteria	1598	0	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g19	i0	98.883	399.924022346369	895	10	100	0	1	895	1732801	1733695	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	357932	1598	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
15108796	15108796	PRJNA400391_S_NODE_3352_length_220_cov_1.297297_g3291_i0	PRJNA400391	3352	220	1.297297	2.8540534	Sulfurimonas	202746	Bacteria	Bacteria	104	5.3e-18	NTclustered	gi\|470477533\|ref\|NR_076390.1\|	39766	g3291	i0	93.151	55	73	2	32	3	1	71	167	238	Sulfurimonas denitrificans strain DSM 1251 23S ribosomal RNA gene, complete sequence	blastn	12100	104	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas denitrificans
16383396	16383396	PRJNA400391_S_NODE_1233_length_333_cov_26.983221_g1172_i0	PRJNA400391	1233	333	26.983221	89.85412593	Pseudomonadati	3379134	Bacteria	Bacteria	460	4.4e-125	NTclustered	gi\|297499180\|gb\|HM057695.1\|	120858	g1172	i0	91.843	156.957957957958	331	26	99	1	3	333	1150	1479	Uncultured epsilon proteobacterium clone C13W_147 16S ribosomal RNA gene, partial sequence	blastn	52267	460	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
18265776	18265776	PRJNA400391_S_NODE_95_length_707_cov_12.465774_g69_i0	PRJNA400391	95	707	12.465774	88.13302218	uncultured Campylobacterota bacterium	120858	Bacteria	Bacteria	1105	0	NTclustered	gi\|219880899\|gb\|FJ535176.1\|	120858	g69	i0	95.157	99.3691654879774	702	30	99	4	9	707	1436	736	Uncultured epsilon proteobacterium clone ATB-LH-5995 16S ribosomal RNA gene, partial sequence	blastn	70254	1105	1	Bacteria	Pseudomonadati	Campylobacterota					uncultured Campylobacterota bacterium
18932548	18932548	PRJNA400391_S_NODE_475_length_456_cov_36.163895_g415_i0	PRJNA400391	475	456	36.163895	164.9073612	Arcobacteraceae	2808963	Bacteria	Bacteria	734	0	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g415	i0	97.025	393.25	437	12	96	1	21	456	1734754	1734318	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	179322	739	0.993234100135318	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
20207237	20207237	PRJNA400391_S_NODE_436_length_467_cov_56.187500_g377_i0	PRJNA400391	436	467	56.1875	262.395625	Arcobacteraceae	2808963	Bacteria	Bacteria	769	0	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g377	i0	96.368	395.997858672377	468	16	100	1	1	467	850750	851217	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	184931	769	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
20207245	20207245	PRJNA400391_S_NODE_4696_length_184_cov_2.308725_g4635_i0	PRJNA400391	4696	184	2.308725	4.248054	Sulfurospirillum	57665	Bacteria	Bacteria	333	5e-87	NTclustered	gi\|1729059542\|gb\|CP042966.1\|	66821	g4635	i0	99.454	196.233695652174	183	1	99	0	2	184	2244806	2244988	Sulfurospirillum multivorans strain N chromosome, complete genome	blastn	36107	333	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum multivorans
22090601	22090601	PRJNA400391_S_NODE_718_length_397_cov_11.102210_g658_i0	PRJNA400391	718	397	11.10221	44.0757737	Sulfurospirillum diekertiae	1854492	Bacteria	Bacteria	431	4.1799999999999984e-116	NTclustered	gi\|1243308819\|gb\|CP023275.1\|	1854492	g658	i0	87.335	267.31234256927	379	45	95	3	1	377	2762206	2762583	Sulfurospirillum diekertiae strain JPD-1 chromosome, complete genome	blastn	106123	431	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum diekertiae
23366214	23366214	PRJNA400391_S_NODE_739_length_393_cov_3.094972_g679_i0	PRJNA400391	739	393	3.094972	12.16323996	Helicobacter sp. 'pancake tortoise'	611767	Bacteria	Bacteria	220	9.74e-53	NTclustered	gi\|224181628\|gb\|FJ667779.1\|	611767	g679	i0	81.786	74.941475826972	280	36	71	10	6	283	1054	1320	Helicobacter sp. 'pancake tortoise' 16S ribosomal RNA gene, partial sequence	blastn	29452	220	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. 'pancake tortoise'
24640507	24640507	PRJNA400391_S_NODE_5860_length_162_cov_1.700787_g5799_i0	PRJNA400391	5860	162	1.700787	2.75527494	Sulfurospirillum halorespirans	194424	Bacteria	Bacteria	283	4.39e-72	NTclustered	gi\|1063807422\|gb\|CP017111.1\|	1193502	g5799	i0	98.148	311.512345679012	162	3	100	0	1	162	2091354	2091193	Sulfurospirillum halorespirans DSM 13726 chromosome, complete genome	blastn	50465	283	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum halorespirans

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