RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA909412" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA909412 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
2524855 2524855 PRJNA909412_P_NODE_5942_length_215_cov_0.937500_g5801_i0 PRJNA909412 5942 215 0.9375 2.015625 Viruses 10239 Viruses Viruses 141 3.93e-29   NTclustered gi|2196309042|gb|MZ679248.1| 2715102 g5801 i0 90.741 3.16279069767442 108 7 50 3 74 180 10027 9922 MAG: Marnaviridae sp. isolate R65-k141_733993 hypothetical protein gene, complete cds blastn 680 141 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
5993919 5993919 PRJNA909412_P_NODE_17285_length_151_cov_1.482143_g17144_i0 PRJNA909412 17285 151 1.482143 2.23803593 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 257 2.43e-64   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g17144 i0 97.351 1 151 4 100 0 1 151 8222 8072 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 151 257 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
11094306 11094306 PRJNA909412_P_NODE_7609_length_192_cov_1.588235_g7468_i0 PRJNA909412 7609 192 1.588235 3.0494112 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 350 5.24e-92   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g7468 i0 99.479 1.99479166666667 192 1 100 0 1 192 776 967 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 383 350 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
12369826 12369826 PRJNA909412_P_NODE_6110_length_212_cov_1.930636_g5969_i0 PRJNA909412 6110 212 1.930636 4.09294832 Crogonang virus 58 3063050 Viruses Viruses 285 1.69e-72   NTclustered gi|2626079542|gb|OR270365.1| 3063050 g5969 i0 90.995 0.995283018867924 211 19 99 0 2 212 344 554 MAG: Crogonang virus 58 isolate CGH03 genomic sequence blastn 211 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
12369831 12369831 PRJNA909412_P_NODE_7110_length_198_cov_1.962264_g6969_i0 PRJNA909412 7110 198 1.962264 3.88528272 Crogonang virus 47 3063018 Viruses Viruses 211 2.68e-50   NTclustered gi|2626079445|gb|OR270332.1| 3063018 g6969 i0 85.859 2 198 28 100 0 1 198 546 743 MAG: Crogonang virus 47 isolate CGH03 genomic sequence blastn 396 211 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
14918642 14918642 PRJNA909412_P_NODE_1612_length_433_cov_2.147208_g1472_i0 PRJNA909412 1612 433 2.147208 9.29741064 Crogonang virus 58 3063050 Viruses Viruses 510 5.7399999999999985e-140   NTclustered gi|2626079542|gb|OR270365.1| 3063050 g1472 i0 88.112 0.990762124711316 429 51 99 0 1 429 1272 844 MAG: Crogonang virus 58 isolate CGH03 genomic sequence blastn 429 510 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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