metadata: contig_metadata: 10 rows where bioproject = "PRJEB10140", tax_phylum = "Preplasmiviricota" and tax

10 rows where bioproject = "PRJEB10140", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

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
19138881	19138881	PRJEB10140_P_NODE_81576_length_449_cov_2.790000_g64318_i0	PRJEB10140	81576	449	2.79	12.5271	Siadenovirus ranae	3241308	Viruses	Viruses	52.8	0.043	NTclustered	gi\|9635795\|ref\|NC_002501.1\|	114102	g64318	i0	100	0.0623608017817372	28	0	6	0	419	446	11698	11671	Frog adenovirus 1, complete genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Siadenovirus	Siadenovirus ranae
27158710	27158710	PRJEB10140_P_NODE_197542_length_197_cov_1.520270_g180233_i0	PRJEB10140	197542	197	1.52027	2.9949319	Adintovirus clytia12738	3115900	Viruses	Viruses	62.8	1.42e-9	NR	DBA47857.1	3115900	g180233	i0	48.1	2.39086294416244	52	27	79.2	0	197	42	258	309	DBA47857.1 MAG TPA_asm: Penton [Adintovirus clytia12738]	diamond	471	62.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus clytia12738
27222057	27222057	PRJEB10140_P_NODE_267283_length_165_cov_1.741379_g249974_i0	PRJEB10140	267283	165	1.741379	2.87327535	Adintovirus notospermus15	3115931	Viruses	Viruses	63.9	4.44e-10	NR	DBA47334.1	3115931	g249974	i0	52.6	1.03636363636364	57	25	100	1	165	1	515	571	DBA47334.1 MAG TPA_asm: PolBg [Adintovirus notospermus15040]	diamond	171	63.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus notospermus15040
28074799	28074799	PRJEB10140_P_NODE_13905_length_1879_cov_3.976503_g7834_i0	PRJEB10140	13905	1879	3.976503	74.71849137	Adintovirus eleutherobia11187	3115903	Viruses	Viruses	301	1.15e-84	NR	DBA48763.1	3115903	g7834	i0	42.2	2.59765832889835	367	207	58.3	3	1141	47	165	528	DBA48763.1 MAG TPA_asm: PolBg [Adintovirus eleutherobia11187]	diamond	4881	301	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus eleutherobia11187
28390594	28390594	PRJEB10140_P_NODE_128506_length_285_cov_2.826271_g111199_i0	PRJEB10140	128506	285	2.826271	8.05487235	Adintovirus notospermus15	3115931	Viruses	Viruses	87.4	1.93e-19	NR	DBA47343.1	3115931	g111199	i0	44.2	0.905263157894737	86	47	89.5	1	25	279	37	122	DBA47343.1 MAG TPA_asm: Adenain [Adintovirus notospermus15040]	diamond	258	87.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus notospermus15040
28769584	28769584	PRJEB10140_P_NODE_65467_length_561_cov_1.078125_g48493_i0	PRJEB10140	65467	561	1.078125	6.04828125	Adintovirus lineus2	3115920	Viruses	Viruses	58.2	2.04e-6	NR	DBA50433.1	3115920	g48493	i0	28.8	0.818181818181818	153	84	79.7	5	3	449	28	159	DBA50433.1 MAG TPA_asm: Penton [Adintovirus lineus20002]	diamond	459	58.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus lineus20002
29836966	29836966	PRJEB10140_P_NODE_171931_length_221_cov_0.889535_g154622_i0	PRJEB10140	171931	221	0.889535	1.96587235	Viruses	10239	Viruses	Viruses	81.6	3.45e-16	NR	DBA47049.1	3115890	g154622	i0	54.8	3.96380090497738	73	33	99.1	0	3	221	108	180	DBA47049.1 MAG TPA_asm: Integrase [Adintovirus anguis11817]	diamond	876	82.4	0.990291262135922	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguis11817
29937984	29937984	PRJEB10140_P_NODE_295071_length_158_cov_2.807339_g277762_i0	PRJEB10140	295071	158	2.807339	4.43559562	Adintovirus anguis11817	3115890	Viruses	Viruses	61.2	1.02e-9	NR	DBA47053.1	3115890	g277762	i0	51.9	1.9746835443038	52	25	98.7	0	158	3	33	84	DBA47053.1 MAG TPA_asm: Adenain [Adintovirus anguis11817]	diamond	312	61.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguis11817
30822459	30822459	PRJEB10140_P_NODE_150714_length_246_cov_1.979695_g133406_i0	PRJEB10140	150714	246	1.979695	4.8700497	Adintovirus sp.	2835276	Viruses	Viruses	43.9	0.0118	NR	DAD55548.1	2835276	g133406	i0	30.3	0.926829268292683	76	49	87.8	1	241	26	135	210	DAD55548.1 MAG TPA: hypothetical protein [Adintovirus sp.]	diamond	228	43.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus sp.
32213955	32213955	PRJEB10140_P_NODE_141398_length_261_cov_0.981132_g124091_i0	PRJEB10140	141398	261	0.981132	2.56075452	Adintovirus arcovestia1655	3115892	Viruses	Viruses	58.5	8.97e-8	NR	DBA50520.1	3115892	g124091	i0	42.5	1.71264367816092	73	42	83.9	0	38	256	123	195	DBA50520.1 MAG TPA_asm: Adintoc2 [Adintovirus arcovestia16550]	diamond	447	58.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus arcovestia16550

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