metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1139127" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1139127" and tax_kingdom = "Orthornavirae"

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
11763902	11763902	PRJNA1139127_P_NODE_41150_length_256_cov_1.322404_g40657_i0	PRJNA1139127	41150	256	1.322404	3.38535424	Coltivirus dermacentoris	3428066	Viruses	Viruses	241	4.630000000000001e-59	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g40657	i0	95.973	1.57421875	149	5	58	1	1	149	4633	4486	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	403	241	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
11763938	11763938	PRJNA1139127_P_NODE_44470_length_249_cov_0.875000_g43977_i0	PRJNA1139127	44470	249	0.875	2.17875	Capillovirus mali	28347	Viruses	Viruses	436	5.32e-118	NTclustered	gi\|2108669534\|gb\|MZ126530.1\|	28347	g43977	i0	100	94.6907630522088	236	0	95	0	1	236	6443	6208	Apple stem grooving virus isolate 13TF142, complete genome	blastn	23578	436	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
16862016	16862016	PRJNA1139127_P_NODE_10734_length_649_cov_2.010417_g10271_i0	PRJNA1139127	10734	649	2.010417	13.04760633	Chemarfal virus 258	3063149	Viruses	Viruses	1110	0	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g10271	i0	97.535	1	649	16	100	0	1	649	1403	2051	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	649	1110	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
16862473	16862473	PRJNA1139127_P_NODE_694_length_2314_cov_3.116020_g628_i0	PRJNA1139127	694	2314	3.11602	72.1047028	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	4108	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g628	i0	98.704	1.14909248055315	2315	28	100	2	1	2314	2636	323	Malassezia restricta virus MrV40L, complete genome	blastn	2659	4108	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
20686541	20686541	PRJNA1139127_P_NODE_27797_length_337_cov_1.784091_g27305_i0	PRJNA1139127	27797	337	1.784091	6.01238667	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	571	1.97e-158	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g27305	i0	99.367	0.937685459940653	316	1	94	1	22	337	1	315	Malassezia restricta virus MrV40L, complete genome	blastn	316	571	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L

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