metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax_kingdom = "Bamfordvirae"

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
495719	495719	PRJNA526367_P_NODE_1301_length_519_cov_2.534043_g1160_i0	PRJNA526367	1301	519	2.534043	13.15168317	Thermus phage phiKo	2301535	Viruses	Viruses	172	3.74e-38	NTclustered	gi\|1800414188\|gb\|MH673671.2\|	2301535	g1160	i0	93.22	0.227360308285164	118	7	23	1	199	316	601	717	Thermus phage phiKo, complete genome	blastn	118	172	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
496368	496368	PRJNA526367_P_NODE_62141_length_155_cov_5.754717_g61931_i0	PRJNA526367	62141	155	5.754717	8.91981135	Thermus phage phiKo	2301535	Viruses	Viruses	119	1.24e-22	NTclustered	gi\|1800414188\|gb\|MH673671.2\|	2301535	g61931	i0	81.333	0.967741935483871	150	25	95	3	7	153	6119	6268	Thermus phage phiKo, complete genome	blastn	150	119	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
5599639	5599639	PRJNA526367_P_NODE_20705_length_324_cov_2.378182_g20496_i0	PRJNA526367	20705	324	2.378182	7.70530968	Thermus phage phiKo	2301535	Viruses	Viruses	145	4.88e-30	NTclustered	gi\|1800414188\|gb\|MH673671.2\|	2301535	g20496	i0	92.929	0.592592592592593	99	7	59	0	2	100	5085	5183	Thermus phage phiKo, complete genome	blastn	192	145	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
9424092	9424092	PRJNA526367_P_NODE_28728_length_324_cov_1.701818_g28519_i0	PRJNA526367	28728	324	1.701818	5.51389032	Harvfovirus sp.	2487768	Viruses	Viruses	54.7	0.008	NTclustered	gi\|1512475942\|gb\|MK072244.1\|	2487768	g28519	i0	100	0.0895061728395062	29	0	9	0	27	55	43646	43674	MAG: Harvfovirus sp. clone Harvfovirus_2 genomic sequence	blastn	29	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
15141750	15141750	PRJNA526367_P_NODE_34572_length_204_cov_3.290323_g34362_i0	PRJNA526367	34572	204	3.290323	6.71225892	root	1	Root_unresolved	Root_unresolved	368	1.56e-97	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g34362	i0	100	97.5490196078431	199	0	98	0	1	199	15025	15223	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	19900	368	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
15799001	15799001	PRJNA526367_P_NODE_61853_length_155_cov_9.339623_g61643_i0	PRJNA526367	61853	155	9.339623	14.47641565	Thermus phage phiKo	2301535	Viruses	Viruses	122	9.58e-24	NTclustered	gi\|1800414188\|gb\|MH673671.2\|	2301535	g61643	i0	88.889	0.638709677419355	99	11	64	0	49	147	308	210	Thermus phage phiKo, complete genome	blastn	99	122	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo
17691623	17691623	PRJNA526367_P_NODE_38854_length_185_cov_2.683824_g38644_i0	PRJNA526367	38854	185	2.683824	4.9650744	root	1	Root_unresolved	Root_unresolved	315	1.8199999999999998e-81	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g38644	i0	99.422	93.5135135135135	173	1	94	0	8	180	13296	13124	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	17300	315	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
22172855	22172855	PRJNA526367_P_NODE_45818_length_173_cov_4.838710_g45608_i0	PRJNA526367	45818	173	4.83871	8.3709683	Thermus phage phiKo	2301535	Viruses	Viruses	202	1.3599999999999999e-47	NTclustered	gi\|1800414188\|gb\|MH673671.2\|	2301535	g45608	i0	88.554	0.959537572254335	166	19	96	0	1	166	1252	1417	Thermus phage phiKo, complete genome	blastn	166	202	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Thermus phage phiKo

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