metadata: contig_metadata: 5 rows where bioproject = "PRJEB75230" and tax

5 rows where bioproject = "PRJEB75230" 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
6099134	6099134	PRJEB75230_P_NODE_180785_length_241_cov_0.916667_g180603_i0	PRJEB75230	180785	241	0.916667	2.20916747	Mimivirus	315393	Viruses	Viruses	154	5.78e-33	NTclustered	gi\|2574490570\|gb\|OQ700913.1\|	212035	g180603	i0	80.676	30.4066390041494	207	32	99	8	12	215	294565	294364	Mutant Acanthamoeba polyphaga mimivirus isolate KO_qu_143, complete genome	blastn	7328	154	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus bradfordmassiliense
6515964	6515964	PRJEB75230_P_NODE_7746_length_516_cov_1.340858_g7564_i0	PRJEB75230	7746	516	1.340858	6.91882728	Moumouvirus australiense	3080759	Viruses	Viruses	56.5	0.004	NTclustered	gi\|2500366567\|ref\|NC_075368.1\|	2109587	g7564	i0	89.362	0.0910852713178295	47	1	9	4	346	392	518687	518729	Moumouvirus australiensis isolate 10A, complete genome	blastn	47	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus australiense
8648999	8648999	PRJEB75230_P_NODE_140467_length_248_cov_0.880000_g140285_i0	PRJEB75230	140467	248	0.88	2.1824	Moumouvirus	3080801	Viruses	Viruses	69.4	2.23e-7	NTclustered	gi\|441431943\|ref\|NC_020104.1\|	1269028	g140285	i0	76.259	2.02016129032258	139	27	55	6	53	188	264957	264822	Acanthamoeba polyphaga moumouvirus, complete genome	blastn	501	69.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus moumou
28771118	28771118	PRJEB75230_P_NODE_55247_length_305_cov_1.327586_g55065_i0	PRJEB75230	55247	305	1.327586	4.0491373	Chlorovirus heliozoae	322019	Viruses	Viruses	42.4	0.0208	NR	YP_001427234.1	322019	g55065	i0	39	0.757377049180328	77	43	75.7	3	55	285	7	79	YP_001427234.1 hypothetical protein ATCV1_z753L [Chlorovirus heliozoae]	diamond	231	42.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus heliozoae
31393203	31393203	PRJEB75230_P_NODE_57276_length_303_cov_1.004348_g57094_i0	PRJEB75230	57276	303	1.004348	3.04317444	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	53.5	6.44e-6	NR	YP_009448950.1	2023057	g57094	i0	61	0.801980198019802	41	16	40.6	0	302	180	171	211	YP_009448950.1 Synaptobrevin/VAMP-like protein [Orpheovirus IHUMI-LCC2]	diamond	243	53.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense

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