metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
3182086	3182086	PRJNA666695_S_NODE_161143_length_170_cov_1.782946_g160049_i0	PRJNA666695	161143	170	1.782946	3.0310082	Sulfurospirillum sp. UCH001	1581011	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|757804895\|dbj\|AP014723.1\|	1581011	g160049	i0	100	0.176470588235294	30	0	18	0	46	75	2213588	2213559	Sulfurospirillum sp. UCH001 DNA, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. UCH001
3184606	3184606	PRJNA666695_S_NODE_99623_length_220_cov_2.089385_g98529_i0	PRJNA666695	99623	220	2.089385	4.596647	Nitrosophilus kaiyonis	2930200	Bacteria	Bacteria	132	2.43e-26	NTclustered	gi\|2329051130\|dbj\|AP025696.1\|	2930200	g98529	i0	79.167	48.4818181818182	192	38	87	2	21	211	409170	408980	Nitrosophilus sp. MOT50 DNA, complete genome	blastn	10666	132	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitrosophilus	Nitrosophilus kaiyonis
6267087	6267087	PRJNA666695_S_NODE_66965_length_261_cov_3.390909_g65871_i0	PRJNA666695	66965	261	3.390909	8.85027249	Helicobacter	209	Bacteria	Bacteria	60.2	1.42e-4	NTclustered	gi\|2642949270\|gb\|CP079480.1\|	210	g65871	i0	100	24.1532567049808	32	0	12	0	230	261	1018237	1018268	Helicobacter pylori strain HpGP-ITA-029 chromosome, complete genome	blastn	6304	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
7012040	7012040	PRJNA666695_S_NODE_89726_length_231_cov_1.768421_g88632_i0	PRJNA666695	89726	231	1.768421	4.08505251	Hydrogenimonas leucolamina	2954236	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2735261051\|dbj\|AP026369.1\|	2954236	g88632	i0	100	0.121212121212121	28	0	12	0	152	179	642391	642364	Hydrogenimonas sp. SS33 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Hydrogenimonadaceae	Hydrogenimonas	Hydrogenimonas leucolamina
9560345	9560345	PRJNA666695_S_NODE_21608_length_403_cov_4.720994_g20515_i0	PRJNA666695	21608	403	4.720994	19.02560582	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|2620255116\|gb\|CP129949.1\|	2933791	g20515	i0	100	0.347394540942928	28	0	7	0	348	375	1319581	1319554	Arcobacter cryaerophilus gv. pseudocryaerophilus strain DSM 115956 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
11366894	11366894	PRJNA666695_S_NODE_95869_length_224_cov_2.180328_g94775_i0	PRJNA666695	95869	224	2.180328	4.88393472	Helicobacter	209	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2222004445\|gb\|CP094088.1\|	210	g94775	i0	92.5	33.6651785714286	40	1	18	2	185	224	130735	130698	Helicobacter pylori strain Hpfe092 chromosome, complete genome	blastn	7541	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
13385584	13385584	PRJNA666695_S_NODE_183071_length_157_cov_1.543103_g181977_i0	PRJNA666695	183071	157	1.543103	2.42267171	Halarcobacter bivalviorum	663364	Bacteria	Bacteria	58.4	2.78e-4	NTclustered	gi\|1435902972\|gb\|CP031217.1\|	663364	g181977	i0	94.595	0.636942675159236	37	2	24	0	52	88	69829	69793	Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome	blastn	100	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter bivalviorum
16465493	16465493	PRJNA666695_S_NODE_150353_length_177_cov_2.205882_g149259_i0	PRJNA666695	150353	177	2.205882	3.90441114	Arcobacter	28196	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|296095720\|gb\|CP001999.1\|	572480	g149259	i0	100	0.327683615819209	29	0	16	0	100	128	446904	446876	Arcobacter nitrofigilis DSM 7299 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter nitrofigilis
19758933	19758933	PRJNA666695_S_NODE_27516_length_368_cov_2.483180_g26423_i0	PRJNA666695	27516	368	2.48318	9.1381024	Halarcobacter sp.	2321133	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2621784481\|emb\|OY780939.1\|	2321133	g26423	i0	100	0.0760869565217391	28	0	8	0	195	222	1965489	1965516	MAG: Halarcobacter sp. isolate c23ce619-377f-483f-a597-00588adfbfa9 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter sp.
22307580	22307580	PRJNA666695_S_NODE_116958_length_203_cov_2.567901_g115864_i0	PRJNA666695	116958	203	2.567901	5.21283903	Arcobacter aquimarinus	1315211	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1845961186\|gb\|CP030944.1\|	1315211	g115864	i0	100	0.137931034482759	28	0	14	0	73	100	1855527	1855500	Arcobacter aquimarinus strain W63 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter aquimarinus
22308459	22308459	PRJNA666695_S_NODE_160498_length_170_cov_3.209302_g159404_i0	PRJNA666695	160498	170	3.209302	5.4558134	Aliarcobacter vitoriensis	2011099	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2922069336\|gb\|CP182882.1\|	2011099	g159404	i0	100	0.170588235294118	29	0	17	0	134	162	1222856	1222828	Aliarcobacter vitoriensis strain BNI-4100 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter vitoriensis
22311032	22311032	PRJNA666695_S_NODE_99858_length_220_cov_1.541899_g98764_i0	PRJNA666695	99858	220	1.541899	3.3921778	Aliarcobacter butzleri	28197	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2305706618\|gb\|CP104378.1\|	28197	g98764	i0	96.875	0.145454545454545	32	0	14	1	61	91	1691729	1691760	Aliarcobacter butzleri strain P1100 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
24114940	24114940	PRJNA666695_S_NODE_38739_length_324_cov_2.127208_g37645_i0	PRJNA666695	38739	324	2.127208	6.89215392	Helicobacter	209	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2222040433\|gb\|CP094113.1\|	210	g37645	i0	100	9.39814814814815	29	0	9	0	210	238	478416	478388	Helicobacter pylori strain Hpfe069 chromosome, complete genome	blastn	3045	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
24857895	24857895	PRJNA666695_S_NODE_188760_length_154_cov_1.221239_g187666_i0	PRJNA666695	188760	154	1.221239	1.88070806	Caminibacter mediatlanticus	291048	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1666442357\|gb\|CP040463.1\|	391592	g187666	i0	100	0.181818181818182	28	0	18	0	54	81	481117	481090	Caminibacter mediatlanticus TB-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Caminibacter	Caminibacter mediatlanticus

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